What You Need to Know Before
You Start

Starts 4 June 2025 23:59

Ends 4 June 2025

00 days
00 hours
00 minutes
00 seconds
course image

Data Analysis with Excel Power Tools

Supercharge your Excel skills with Excel Power Tools: Master Power Query, Power Pivot, and the dynamic M Language.
via DataCamp

120 Courses


9 hours

Optional upgrade avallable

Intermediate

Progress at your own speed

Free Trial Available

Optional upgrade avallable

Overview

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!

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


Subjects

Business