Module 1: Reporting in Excel
This module explains how to create a report in Excel.
- Filtering and Formatting Data
- Charts
Module 2: Excel Tables
This module explains how to create data tables in Excel
- Excel Data Tables
- Summarizing Data
Module 3: Pivot Tables and Pivot Charts
This module describes pivot tables and pivot charts and how to work with them.
- Pivot Tables
- Pivot Charts
- Editing Pivot Tables and Pivot Charts
Module 4: Dashboards
This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables.
- Creating a Dashboard
- Data Analysis in Excel Pivot Tables
Module 5: Hierarchies
This module describes hierarchies and time data.
- Hierarchies
- Time Data
Module 6: The Excel Data Model
This module explores the Excel data model and looks at ways of extending it.
- Using an Excel Data Model
- External Data