Create an Excel Dashboard with Power Query (Office 365)

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!