There is 0 item now in your comparison listView a comparison list

Create an Excel Dashboard with Power Query (Office 365)

Provided by
1,095 people completed this program


Creating a Dashboard in Excel from scratch can feel overwhelming. But it does not have to be!

In this class we will use Excel Power Query together with Excel's data modeling and Pivot Table tools to get it setup REALLY fast.

In this class you will learn:

  • Import from Text/CSV and Excel files
  • Apply regional settings to make sure dates and numbers are shown correctly
  • Use Excel's data model and Power Pivot
  • How to create an interactive dashboard that can be refreshed with the click of a button
  • How to use Pivot Charts and Pivot Slicers
  • Useful Excel Dashboards Tips and Tricks

The techniques we cover in this class will give you additional ideas to apply to your own reports to give them an edge and make them more professional.

Follow along with me and create this interactive dashboard from scratch!

Authored by


Reviews (0)

Help others make their choice. Be the first one to leave a review

Leave a review
Create an Excel Dashboard with Power Query (Office 365)
This website uses cookies to ensure you get the best experience