Wayne Winston
Microsoft Excel 2019 Data Analysis and Business Modeling
E-book Engels 2019 9781509306084
Verwachte levertijd ongeveer 9 werkdagen
Samenvatting
Master business modeling and analysis techniques with Microsoft Excel 2019, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables–and how to effectively build a relational data source inside an Excel workbook.
The full text downloaded to your computer
With eBooks you can: search for key concepts, words and phrases make highlights and notes as you study share your notes with friends
eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.
Upon purchase, you will receive via email the code and instructions on how to access this product.
Time limit
The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.
Specificaties
Lezersrecensies
Wees de eerste die een lezersrecensie schrijft!
Inhoudsopgave
<ul> <li> <div style="MARGIN: 0px"> Chapter 1 Basic spreadsheet modeling </div> </li> <li> <div style="MARGIN: 0px"> Chapter 2 Range names </div> </li> <li> <div style="MARGIN: 0px"> Chapter 3 Lookup functions </div> </li> <li>Chapter 4 The INDEX function </li> <li> <div style="MARGIN: 0px"> Chapter 5 The MATCH function </div> </li> <li> <div style="MARGIN: 0px"> Chapter 6 Text functions </div> </li> <li> <div style="MARGIN: 0px"> Chapter 7 Dates and date functions </div> </li> <li>Chapter 8 Evaluating investment by using net present value criteria </li> <li> <div style="MARGIN: 0px"> Chapter 9 Internal rate of return </div> </li> <li> <div style="MARGIN: 0px"> Chapter 10 More Excel financial functions </div> </li> <li> <div style="MARGIN: 0px"> Chapter 11 Circular references </div> </li> <li> <div style="MARGIN: 0px"> Chapter 12 IF statements </div> </li> <li> <div style="MARGIN: 0px"> Chapter 13 Time and time functions </div> </li> <li> <div style="MARGIN: 0px"> Chapter 14 The Paste Special command </div> </li> <li> <div style="MARGIN: 0px"> Chapter 15 Three-dimensional formulas and hyperlinks </div> </li> <li> <div style="MARGIN: 0px"> Chapter 16 The auditing tool </div> </li> <li> <div style="MARGIN: 0px"> Chapter 17 Sensitivity analysis with data tables </div> </li> <li> <div style="MARGIN: 0px"> Chapter 18 The Goal Seek command </div> </li> <li> <div style="MARGIN: 0px"> Chapter 19 Using the Scenario Manager for sensitivity analysis </div> </li> <li> <div style="MARGIN: 0px"> Chapter 20The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions </div> </li> <li> <div style="MARGIN: 0px"> Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions </div> </li> <li> <div style="MARGIN: 0px"> Chapter 22 The OFFSET function </div> </li> <li> <div style="MARGIN: 0px"> Chapter 23 The INDIRECT function </div> </li> <li> <div style="MARGIN: 0px"> Chapter 24 Conditional formatting </div> </li> <li> <div style="MARGIN: 0px"> Chapter 25 Sorting in Excel </div> </li> <li> <div style="MARGIN: 0px"> Chapter 26 Tables </div> </li> <li> <div style="MARGIN: 0px"> Chapter 27 Spin buttons, scroll bars, option buttons, check </div> </li> <li> <div style="MARGIN: 0px"> boxes, combo boxes, and group list boxes </div> </li> <li> <div style="MARGIN: 0px"> Chapter 28 The analytics revolution </div> </li> <li> <div style="MARGIN: 0px"> Chapter 29 An introduction to optimization with Excel Solver </div> </li> <li> <div style="MARGIN: 0px"> Chapter 30 Using Solver to determine the optimal product mix </div> </li> <li> <div style="MARGIN: 0px"> Chapter 31 Using Solver to schedule your workforce </div> </li> <li> <div style="MARGIN: 0px"> Chapter 32 Using Solver to solve transportation or distribution problems </div> </li> <li> <div style="MARGIN: 0px"> Chapter 33 Using Solver for capital budgeting </div> </li> <li> <div style="MARGIN: 0px"> Chapter 34 Using Solver for financial planning </div> </li> <li> <div style="MARGIN: 0px"> Chapter 35 Using Solver to rate sports teams </div> </li> <li> <div style="MARGIN: 0px"> Chapter 36 Warehouse location and the GRG Multistart and Evolutionary Solver engines </div> </li> <li> <div style="MARGIN: 0px"> Chapter 37 Penalties and the Evolutionary Solver </div> </li> <li>Chapter 38 The traveling salesperson problem </li> <li>Chapter 39 Importing data from a text file or document </li> <li>C</li> </ul>
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan