Analyzing and presenting data effectively is an increasingly important skill for EAs to possess as strategic business partners. With the powerful new tools added in the last few years, an Excel report can be dynamically created from multiple changing data files in seconds.
In this hands-on, high-energy masterclass, learn how to use Power Query to compile data from various locations, then leverage Pivot Tables to build dynamic dashboards from that data. You’ll also learn how to analyze data like a pro with the skills gained from this session.
Key Takeaways:
- Pull data from outside data sources into Excel
- Compile multiple files into one in seconds
- Generate dynamic analysis of a dataset with Pivot Tables
- Use Pivot Charts and Slicers to investigate data effectively
Â
Please bring your laptop to the session.