Curriculum
- 10 Sections
- 57 Lessons
- 104 Weeks
Expand all sectionsCollapse all sections
- Chapter 1: Creating & Pivoting PivotTables11
- 2.1Overview2 Minutes
- 2.2Introducing PivotTables6 Minutes
- 2.3Course Documents2 Minutes
- 2.4Formatting data for use in a PivotTable6 Minutes
- 2.5Creating a PivotTable5 Minutes
- 2.6Creating a recommended PivotTable3 Minutes
- 2.7Pivoting a PivotTable6 Minutes
- 2.8Configuring a PivotTable5 Minutes
- 2.9Connecting to an external data source4 Minutes
- 2.10Consolidating data from multiple sources6 Minutes
- 2.11Managing PivotTables5 Minutes
- Chapter 2: Summarizing PivotTable Data6
- Chapter 3: Sorting & Filtering PivotTable Data9
- 4.1Sorting PivotTable data4 Minutes
- 4.2Creating a custom sort order4 Minutes
- 4.3Filtering a PivotTable field by selection4 Minutes
- 4.4Filtering a PivotTable by rule5 Minutes
- 4.5Filtering a PivotTable using a search filter3 Minutes
- 4.6Filtering a PivotTable using slicers4 Minutes
- 4.7Formatting slicers7 Minutes
- 4.8Filtering with report filter fields4 Minutes
- 4.9Clearing and reapplying PivotTable filters4 Minutes
- Chapter 4: Formatting PivotTables4
- Chapter 5: Applying Conditional Formats to PivotTables8
- 6.1Highlighting cells by applying a rule6 Minutes
- 6.2Highlighting the top or bottom values in a PivotTable5 Minutes
- 6.3Formatting cells using data bars8 Minutes
- 6.4Formatting cells using color scales4 Minutes
- 6.5Formatting cells using icon sets7 Minutes
- 6.6Editing a conditional formatting rule4 Minutes
- 6.7Controlling how multiple rules are applied5 Minutes
- 6.8Deleting a conditional formatting rule3 Minutes
- Chapter 6: Creating & Manipulating PivotCharts7
- Chapter 7: Printing PivotTables4
- Chapter 8: ManipulatingPivotTables4
- Chapter 9: Creating PivotTable Using the Data Model3
- Conclusion1
