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