Take messy data from multiple sources, clean it with Power Query, and build a simple dashboard in Excel.
In this training, you will learn how to:
- Use Excel functions to shape data
- Use Power Query to tame wild and crazy data
- Use a Pivot Table to analyze the data
- Use Slicers to create a simple dashboard
- Create a Pivot Chart to visualize the data
No wand required, just Power Query, Excel, and a little bit of magic.