Power up and transform your data skills from foundational to extraordinary! Wield Power Query to clean and shape your data and easily streamline your reports. You will advance by integrating and transforming data using the mighty M language and the Power Query Advanced Editor. Finally, you’ll master Power Pivot, create dynamic dashboards, uncover actionable insights with DAX, and become an Excel Superhero. This track will empower you to save the day by extracting valuable insights from your data, perfect for data analysts, business professionals, and Excel enthusiasts. Put on your supersuit and become the data hero of this Excel skill track!
Overview
Syllabus
- Introduction to Power Query in Excel
- Explore Excel Power Query for advanced data transformation and cleansing to boost your decision-making and analysis.
- Power Pivot in Excel
- Master Power Pivot in Excel to help import data, create relationships, and utilize DAX. Build dynamic dashboards to uncover actionable insights.
- Intermediate Power Query in Excel
- Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery
Taught by
Lyndsay Girard and Nick Edwards
