Excel 2019 Bible
715 C H A P T E R 31 Performing Spreadsheet What-If Analysis IN THIS CHAPTER Considering a what-if example Identifying types of ...
Part IV: Managing and Analyzing Data FIGURE 31.1 This simple worksheet model uses four input cells to produce the results. This ...
Chapter 31: Performing Spreadsheet What-If Analysis 3131 You could use the value 360, for example, for the loan term argument of ...
Part IV: Managing and Analyzing Data data table fairly easily, but data tables have some limitations. In particular, a data tabl ...
Chapter 31: Performing Spreadsheet What-If Analysis 3131 This example uses the mortgage loan worksheet from earlier in the chapt ...
Part IV: Managing and Analyzing Data FIGURE 31.4 The Data Table dialog box FIGURE 31.5 The result of the one-input data table ...
Chapter 31: Performing Spreadsheet What-If Analysis 3131 Using the Data Table command wipes out Excel’s undo stack. Operations t ...
Part IV: Managing and Analyzing Data FIGURE 31.6 The setup for a two-input data table A formula or a reference to a formula Resu ...
Chapter 31: Performing Spreadsheet What-If Analysis 3131 This workbook, named direct mail data table.xlsx, is on this book’s web ...
Part IV: Managing and Analyzing Data FIGURE 31.8 Preparing to create a two-input data table Specify B5 as the Row input cell (t ...
Chapter 31: Performing Spreadsheet What-If Analysis 3131 Using Scenario Manager Data tables are useful, but they have a few limi ...
Part IV: Managing and Analyzing Data This workbook, named production model scenarios.xlsx, is available on this book’s website a ...
Chapter 31: Performing Spreadsheet What-If Analysis 3131 FIGURE 31.11 Use the Add Scenario dialog box to create a named scenario ...
Part IV: Managing and Analyzing Data box, which then displays your named scenario in its list. If you have more scenarios to cre ...
Chapter 31: Performing Spreadsheet What-If Analysis 3131 Using the Scenarios Drop-Down List The Scenarios drop-down list shows a ...
Part IV: Managing and Analyzing Data Choose the sheet that contains the scenarios you want to merge from the Sheet list box and ...
Chapter 31: Performing Spreadsheet What-If Analysis 3131 FIGURE 31.14 A Scenario Summary report produced by Scenario Manager ...
733 C H A P T E R 32 Analyzing Data Using Goal Seeking and Solver IN THIS CHAPTER Performing what-if analysis—in reverse Single- ...
Part IV: Managing and Analyzing Data Using Single-Cell Goal Seeking Single-cell goal seeking is a rather simple concept. Excel d ...
Chapter 32: Analyzing Data Using Goal Seeking and Solver 3232 example, you could plug values into cell C4 until C11 displays $1, ...
«
33
34
35
36
37
38
39
40
41
42
»
Free download pdf