1 - Reporting in Excel
Filtering and Formatting DataChartsLab : Create an Excel report
2 - Excel Tables
Excel Data TablesSummarizing DataLab : Create an Excel Table
3 - Pivot Tables and Pivot Charts
Pivot TablesPivot ChartsEditing Pivot Tables and Pivot ChartsLab : Importing Data from a CSV File
4 - Dashboards
Creating a DashboardData Analysis in Excel Pivot TablesLab : Create a Dashboard
5 - Hierarchies
HierarchiesTime DataLab : Creating Hierarchies
6 - The Excel Data Model
Using an Excel Data ModelExternal DataLab : Explore an Excel Data Model
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.