Advanced

PivotTables for Data Geeks

When you’ve progressed beyond the bare basics of PivotTables you start to realize how much more is possible by linking information from disparate sets and formatting it for other users to understand. The world of data will open up as you learn about the 3-D data model and the building blocks of dashboards.

  1. 3-D Pivot Tables
  2. The Data Model
  3. Showing Multiple Tables in the
    PivotTable Fields Panel
  4. Building Many-to-One Relationships
  5. Multiple PivotTables from same Data Set
  6. Crosstab Data Reports
  7. Grouping Data
  8. PivotTable Layout
  9. Slicers
  10. Timelines