PIVOT TABLE FUNDAMENTALS

• What is a Pivot Table

• Why Should you use a Pivot Table

• When Should you use a Pivot Table

• The Anatomy of a Pivot Table

• Pivot Tables Behind the Scenes

• Limitations of Pivot Table Reports

CREATING A BASIC PIVOT TABLE

• Preparing Your Data

• Creating a Basic Pivot Table

• Keeping up with Changes in your Data Source

CUSTOMIZING FIELDS IN A PIVOT TABLE

• The Need to Customize

• Displaying the Pivot Table Field Dialog box

• Customising Field Names

• Applying Numeric Formats in Data Fields

• Changing Summary Calculations

• Adding and Removing Subtotals

• Using Running Total Options

FORMATTING YOUR PIVOT TABLE REPORT

• Using AutoFormat

• Applying your own Style

• Setting Table Options

  • Grand totals for columns and rows

  • AutoFormat table

  • Subtotal hidden Page items

  • Merged Labels

  • Preserve Formatting

  • Repeat Item Labels on Each Printed Page

  • Mark Totals with *

  • Page Layout

  • For Error Values Show

  • For Empty Cells Show

  • Set Print Titles

  • Formatting a Pivot Table

CONTROLLING THE WAY YOU VIEW YOUR PIVOT DATA

• Showing and Hiding Options

• Sorting in a Pivot table

• Producing Top 10 Reports

• Group Pivot Fields

PERFORMING CALCULATIONS WITHIN YOUR PIVOT TABLE

• Introducing Calculated Fields and Calculated Items

• Rules and Shortcomings of Pivot Table Calculations

• Managing and maintaining your Pivot Table Calculations