- Why PivotTables? Free
- Structuring Your Source Data Free
- Inserting Your First PivotTable Free
- IMPORTANT: Add to Data Model Free
- Navigating the Field List Free
- KNOWLEDGE CHECK: Manipulating PivotTable Views Free
- PivotTable Options: Analyze & Design Free
- Selecting, Clearing, Moving & Copying Pivots Free
- Refreshing & Updating Pivots Free
- PRO TIP: Dealing with Growing Source Data Pro
- Removing & Reviving Data from Cache Pro
- How PivotTables ACTUALLY Work Pro
- QUIZ: PivotTable 101 Pro
- HOMEWORK: Pivot Table 101 Pro
- Number Formatting Pro
- PRO TIP: Automatically Formatting Empty Cells Pro
- Table Layouts & Styles Pro
- PRO TIP: Using Tabular Tables to Create New Source Data Pro
- Customizing Headers & Labels Pro
- Conditional Formatting Pro
- PRO TIP: Data Bars with Invisible Text Pro
- Advanced Conditional Formatting Pro
- HOMEWORK: Pivot Table Formatting Pro
- QUIZ: PivotTable Formatting Pro
- Sorting Options Pro
- PRO TIP: Incorrect Alphabetical Sorting Pro
- Label Filters & Manual Selections Pro
- PRO TIP: Label Filters with Wildcards Pro
- Value Filters Pro
- PRO TIP: Enabling Multiple Filters Pro
- Grouping Data Pro
- PRO TIP: Automatic Date Grouping Pro
- Using Slicers & Timelines to Filter Data Pro
- Breaking Out Report Filter Pages Pro
- HOMEWORK: Sorting, Filtering, and Grouping Pro
- QUIZ: Sorting, Filtering & Grouping Pro
- Summarize Values By Options Pro
- PRO TIP: Avoiding the Count Of Trap Pro
- Show Values As Calculations Pro
- Show Values As: % of Column/Row Pro
- Show Values As: % of Parent Pro
- Show Values As: Difference From Pro
- Show Values As: Running Total Pro
- Show Values As: Rank Pro
- Show Values As: Index Pro
- KNOWLEDGE CHECK: Show Values As Pro
- Inserting Calculated Fields Pro
- Calculations in Pivots vs. Raw Data Pro
- PRO TIP: Calculating Using Counts (Part 1) Pro
- PRO TIP: Calculating Using Counts (Part 2) Pro
- Inserting a Calculated Item (use with caution!) Pro
- The Solve Order & List Formulas Tools Pro
- QUIZ: Calculated Values, Fields & Items Pro
- HOMEWORK: Calculated Values, Fields & Items Pro
- Intro to PivotCharts Pro
- Pivot Chart Demo: Column Chart Pro
- Pivot Chart Demo: Pie & Donut Charts Pro
- Pivot Chart Demo: Clustered Bar Chart Pro
- PRO TIP: Prevent Charts from Resizing with Cells Pro
- Changing Chart Types on the Fly Pro
- Pivot Chart Demo: Stacked Area Chart Pro
- Pivot Chart Layouts & Styles Pro
- Moving Pivot Charts to New Sheets Pro
- Applying Slicers & Timelines to Multiple Charts Pro
- Building a Dynamic Dashboard Pro
- QUIZ: Pivot Charts Pro
- HOMEWORK: Pivot Charts Pro
- Setting Expectations Pro
- U.S. Voters (2012) Pro
- HOMEWORK: US Voters 2012 Pro
- San Francisco Salaries Pro
- HOMEWORK: San Francisco Salaries Pro
- Shark Attack Records Pro
- HOMEWORK: Shark Attack Records Pro
- Stock Market Data Pro
- HOMEWORK: Stock Market Data Pro
- Baseball Team Stats Pro
- HOMEWORK: Baseball Team Stats Pro
- San Diego Burrito Ratings Pro
- HOMEWORK: San Diego Burrito Ratings Pro
- Daily Weather Conditions Pro
- HOMEWORK: Daily Weather Conditions Pro
- Spartan Race Facebook Posts Pro
- HOMEWORK: Spartan Race Facebook Posts Pro
- Apple App Data Pro
- HOMEWORK: Apple App Data Pro
- Wine Tasting Scores Pro
- HOMEWORK: Wine Tasting Scores Pro