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

xiv
Excel 2013 All-in-One For Dummies
Book VII: Data Analysis............................................ 643
Chapter 1: Performing What-If Scenarios . . . . . . . . . . . . . . . . . . . . . . .645
Using Data Tables........................................................................................646 Creating a one-variable data table...................................................646 Creating a two-variable data table................................................... 649
Exploring Different Scenarios .................................................................... 652 Creating new scenarios.....................................................................652 Producing a summary report ........................................................... 656
Hide and Goal Seeking................................................................................. 657 Using the Solver...........................................................................................659 Setting up and defining the problem...............................................660 Solving the problem .......................................................................... 662 Changing the Solver options ............................................................ 663 Saving and loading a model problem .............................................. 665 Creating Solver reports.....................................................................665
Chapter 2: Generating Pivot Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . .667
Creating Pivot Tables..................................................................................668 Pivot tables with the Quick Analysis tool.......................................668 Recommended pivot tables..............................................................670 Manually created pivot tables.......................................................... 672
Formatting a Pivot Table ............................................................................ 676 Refining the pivot table layout and style ........................................ 676 Formatting the parts of the pivot table...........................................679
Sorting and Filtering the Pivot Table Data ............................................... 681 Filtering the report ............................................................................ 681 Filtering individual Column and Row fields.................................... 682 Slicing the pivot table data...............................................................683 Using timeline filters.......................................................................... 685 Sorting the pivot table....................................................................... 686
Modifying the Pivot Table .......................................................................... 687 Changing the summary functions....................................................688 Adding Calculated Fields .................................................................. 690 Changing the pivot table options..................................................... 691
Creating Pivot Charts..................................................................................693 Moving a pivot chart to its own sheet............................................. 693 Filtering a pivot chart........................................................................694 Formatting a pivot chart ................................................................... 695
Using the PowerPivot and Power View Add-Ins ...................................... 695 Data modeling with PowerPivot....................................................... 696 Switching between the Data View and Diagram View...................699 Adding calculated columns courtesy of DAX.................................701 Creating visual reports with Power View ....................................... 703