Page 662 - Excel 2013 All-in-One For Dummies

Contents at a Glance
Chapter 1: Performing What-If Scenarios . . . . . . . . . . . . . . . . . . . . . . .645
Using Data Tables........................................................................................646 Exploring Different Scenarios .................................................................... 652 Hide and Goal Seeking................................................................................. 657 Using the Solver...........................................................................................659
Chapter 2: Generating Pivot Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . .667
Creating Pivot Tables..................................................................................668 Formatting a Pivot Table ............................................................................ 676 Sorting and Filtering the Pivot Table Data ............................................... 681 Modifying the Pivot Table .......................................................................... 687 Creating Pivot Charts..................................................................................693 Using the PowerPivot and Power View Add-Ins ...................................... 695