Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, 2nd Edition -- Credits -- About the Author -- Author's Acknowledgments -- How to Use This Visual Blueprint Book -- TABLE OF CONTENTS -- Chapter 1: UNDERSTANDING PIVOTTABLES AND PIVOTCHARTS -- Understanding Data Analysis -- Introducing the PivotTable -- Learn PivotTable Benefits -- Learn When to Use PivotTables -- Explore PivotTable Features -- Introducing the PivotChart -- Chapter 2: BUILDING A PIVOTTABLE -- Prepare Your Worksheet Data -- Create a Table for a PivotTable Report -- Build a PivotTable from an Excel Table -- Build a PivotTable from an Excel Range -- Recreate an Existing PivotTable -- Chapter 3: MANIPULATING YOUR PIVOTTABLE -- Turn the PivotTable Field List On and Off -- Customize the PivotTable Field List -- Select PivotTable Items -- Remove a PivotTable Field -- Refresh PivotTable Data -- Display the Details Behind PivotTable Data -- Create a Chart from PivotTable Data -- Enable the Classic PivotTable Layout -- Add Multiple Fields to the Row or Column Area -- Add Multiple Fields to the Data Area -- Add Multiple Fields to the Report Filter -- Publish a PivotTable to a Web Page -- Convert a PivotTable to Regular Data -- Delete a PivotTable -- Chapter 4: CHANGING THE PIVOTTABLE VIEW -- Move a Field to a Different Area -- Change the Order of Fields within an Area -- Change the Report Layout -- Sort PivotTable Data with AutoSort -- Move Row and Column Items -- Group Numeric Values -- Group Date and Time Values -- Group Text Values -- Hide Group Details -- Show Group Details -- Ungroup Values -- Chapter 5: FILTERING A PIVOTTABLE -- Apply a Report Filter -- Change the Report Filter Layout -- Filter Row or Column Items -- Filter PivotTable Values -- Hide Items in a Row or Column Field -- Use Search to Display Multiple Items.

Show Hidden Items in a Row or Column Field -- Filter a PivotTable with a Slicer -- Connect a PivotTable to an Existing Slicer -- Connect a Slicer to Multiple PivotTables -- Chapter 6: CUSTOMIZING PIVOTTABLE FIELDS -- Rename a PivotTable Field -- Rename a PivotTable Item -- Format a PivotTable Cell -- Apply a Numeric Format to PivotTable Data -- Apply a Date Format to PivotTable Data -- Apply a Conditional Format to PivotTable Data -- Show Items with No Data -- Exclude Items from a Report Filter -- Repeat Item Labels in Fields -- Chapter 7: CREATING A PIVOTCHART -- Understanding PivotChart Limitations -- Create a PivotChart from a PivotTable -- Create a PivotChart beside a PivotTable -- Create a PivotChart from an Excel Table -- Move a PivotChart to another Sheet -- Filter a PivotChart -- Change the PivotChart Type -- Sort the PivotChart -- Add PivotChart Titles -- Move the PivotChart Legend -- Display a Data Table with the PivotChart -- Chapter 8: SETTING PIVOTTABLE OPTIONS -- Apply a PivotTable Quick Style -- Create a Custom PivotTable Quick Style -- Preserve PivotTable Formatting -- Rename the PivotTable -- Turn Off Grand Totals -- Merge Item Labels -- Specify Characters for Errors and Empty Cells -- Protect a PivotTable -- Chapter 9: PERFORMING PIVOTTABLE CALCULATIONS -- Change the PivotTable Summary Calculation -- Create a Difference Summary Calculation -- Create a Percentage Summary Calculation -- Create a Running Total Summary Calculation -- Create an Index Summary Calculation -- Turn Off Subtotals for a Field -- Display Multiple Subtotals for a Field -- Chapter 10: CREATING CUSTOM PIVOTTABLE CALCULATIONS -- Introducing Custom Calculations -- Understanding Custom Calculation Limitations -- Insert a Custom Calculated Field -- Insert a Custom Calculated Item -- Edit a Custom Calculation -- Change the Solve Order of Calculated Items.

List Your Custom Calculations -- Delete a Custom Calculation -- Chapter 11: BUILDING FORMULAS FOR PIVOTTABLES -- Introducing Formulas -- Understanding Formula Types -- Introducing Worksheet Functions -- Understanding Function Types -- Build a Function -- Build a Formula -- Work with Custom Numeric and Date Formats -- Chapter 12: USING MICROSOFT QUERY WITH PIVOTTABLES -- Understanding Microsoft Query -- Define a Data Source -- Start Microsoft Query -- Tour the Microsoft Query Window -- Add a Table to the Query -- Add Fields to the Query -- Filter the Records with Query Criteria -- Sort the Query Records -- Return the Query Results -- Chapter 13: IMPORTING DATA FOR PIVOTTABLES -- Understanding External Data -- Import Data from a Data Source -- Import Data from an Access Table -- Import Data from a Word Table -- Import Data from a Text File -- Import Data from a Web Page -- Import Data from an XML File -- Create a PowerPivot Data Connection -- Refresh Imported Data -- Chapter 14: BUILDING MORE ADVANCED PIVOTTABLES -- Create a PivotTable from Multiple Consolidation Ranges -- Create a PivotTable from an Existing PivotTable -- Create a PivotTable from External Data -- Create a PivotTable Using PowerPivot -- Automatically Refresh a PivotTable that Uses External Data -- Save Your Password with an External Data Connection -- Export an Access PivotTable Form to Excel -- Reduce the Size of PivotTable Workbooks -- Use a PivotTable Value in a Formula -- Chapter 15: BUILDING A PIVOTTABLE FROM AN OLAP CUBE -- Understanding OLAP -- Create an OLAP Cube Data Source -- Create a PivotTable from an OLAP Cube -- Show and Hide Details for Dimensions and Levels -- Hide Levels -- Display Selected Levels and Members -- Display Multiple Report Filter Items -- Include Hidden Items in PivotTable Totals -- Performing What-if Analysis on the PivotTable.

Create an Offline OLAP Cube -- Chapter 16: LEARNING VBA BASICS FOR PIVOTTABLES -- Open the VBA Editor -- Add a Macro to a Module -- Run a Macro -- Set Macro Security -- Assign a Shortcut Key to a Macro -- APPENDIX: GLOSSARY OF PIVOTTABLE TERMS -- INDEX.