Introduction to PivotTables (FULL COURSE)

Introduction to PivotTables and some of their basic features.

The topics:

• What is a PivotTable and why do we use them?
• Creating a basic PivotTable
• Building a PivotTable with multiple areas
• Using multiple numerical fields in Values area
• Hiding the PivotTable Fields list
• Refreshing PivotTable data
• Showing details behind the numbers
• Importance of cleansing data for accuracy
• Benefits of using an Excel Formatted table
• Working with columns added to a data source
• Modifying Value Field Settings
• Changing Grand Totals, Subtotals and Layout
• Using non-numerical fields in the Values area
• Grouping with date fields
• Using multiple fields in Filters area