Excel 2010 Bible

Chapter 35: Analyzing Data with Pivot Tables 739 Another Pivot Table Example The pivot table example in this section demonstrate ...

Part V: Analyzing Data with Excel 740 FIGURE 35.29 This pivot table was created from the county data. I created three calculated ...

Chapter 35: Analyzing Data with Pivot Tables 741 FIGURE 35.30 This worksheet lists calculated fields and items for the pivot tab ...

Part V: Analyzing Data with Excel 742 Producing a Report with a Pivot Table By using a pivot table, you can convert a huge table ...

Chapter 35: Analyzing Data with Pivot Tables 743 On the CD This workbook, named music list.xlsx, is available on the companion C ...

...

745 CHAPTER Performing Spreadsheet What-If Analysis IN THIS CHAPTER A what-if example Types of what-if analyses Manual what-if a ...

Part V: Analyzing Data with Excel 746 With this worksheet, you can easily answer the following what-if questions: l What if I ca ...

Chapter 36: Performing Spreadsheet What-If Analysis 747 Types of What-If Analyses Not surprisingly, Excel can handle much more s ...

Part V: Analyzing Data with Excel 748 fairly easily, but data tables have some limitations. In particular, a data table can deal ...

Chapter 36: Performing Spreadsheet What-If Analysis 749 On the CD This workbook is available on the companion CD-ROM. The file i ...

Part V: Analyzing Data with Excel 750 FIGURE 36.5 The result of the one-input data table. Using this table, you can now see the ...

Chapter 36: Performing Spreadsheet What-If Analysis 751 FIGURE 36.6 The setup for a two-input data table. FIGURE 36.7 This works ...

Part V: Analyzing Data with Excel 752 l (^) Mailing costs per unit: A fixed cost, $0.28 per unit mailed. l Responses: The number ...

Chapter 36: Performing Spreadsheet What-If Analysis 753 Select the range E4:M14 and choose Data ➪ Data Tools ➪ What-If Analysis ...

Part V: Analyzing Data with Excel 754 effect of various combinations of values on any number of result cells. These summary repo ...

Chapter 36: Performing Spreadsheet What-If Analysis 755 TABLE 36.1 Three Scenarios for the Production Model Scenario Hourly Cost ...

Part V: Analyzing Data with Excel 756 This dialog box consists of four parts: l Scenario Name: You can give the scenario any nam ...

Chapter 36: Performing Spreadsheet What-If Analysis 757 Displaying scenarios After you define all the scenarios and return to th ...

Part V: Analyzing Data with Excel 758 Modifying scenarios After you’ve created scenarios, you may need to change them. Click the ...