How Duolingo Plans to Reach 100M Users

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Data Analysis with Excel Power Tools

via DataCamp

Go to class Write review

Overview

Get Certified in Python, SQL & AI — 50% Off This May
690+ courses, career tracks, and industry-leading certifications trusted by 19M+ learners and 80% of the Fortune 1000.
Start Learning Today
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

Reviews

Start your review of Data Analysis with Excel Power Tools

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.