This module looks at the classic Excel dashboard and at ways to extend it.
Lessons
Lab : Building a Classic Excel Dashboard
After completing this module, students will be able to:
This module looks at the classic Excel data model and at ways to extend it.
Lessons
Lab : Explore an Excel Data Model
After completing this module, students will be able to:
This module looks at pre-formatting and importing CSV files.
Lessons
Lab : Importing Data from a CSV File
After completing this module, students will be able to:
This module looks at how to import data into Excel from a SQL Server database.
Lessons
Lab : Import Data from Multiple Sources
After completing this module, students will be able to:
This module describes how to import data from a report.
Lessons
Lab : Importing Data from a Report
After completing this module, students will be able to:
This module describes how to create and format measures.Lessons
Lab : Creating Measures using Advanced DAX Functions
After completing this module, students will be able to:
This module describes how to visualize data in Excel.
Lessons
Lab : Data Visualization in Excel
After completing this module, students will be able to:
This module describes how to use Excel with Power BI.
Lessons
Lab : Creating a Power BI Dashboard with Excel
After completing this module, students will be able to: