Coursera Plus Annual is 40% Off — Ends July 13.

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

LinkedIn Learning

Excel: Working Together with Power Query and Power Pivot

via LinkedIn Learning

Write review
Noble Desktop Ad

Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes

Learn More → University of the People Ad

Earn Your Business Degree, Tuition-Free, 100% Online!

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Learn how to combine Power Query and Power Pivot, two robust features of Microsoft Excel, to analyze data.

Syllabus

Introduction
  • Getting the most out of your data
  • What you should know
1. Understanding Power Query and Power Pivot
  • How Power Query and Power Pivot work together
2. Using Power Query
  • Select your data
  • Prepare your query
  • Use a query to cleanse data
  • Enhance your query
  • Prepare data for Power Pivot
3. Using Power Pivot
  • Create your data model
  • Import additional data
  • Build relationships
  • Create lookups as new fields
  • Analyze data using PivotTables
  • Analyze data using PivotCharts
4. Using Power Query with Power Pivot
  • Scenario 1: Refresh source data
  • Scenario 2: Updating queries
  • Scenario 3: New reports
  • Scenario 4: New source data
  • Scenario 5: Finessing reports
Conclusion
  • Next steps

Taught by

Joshua Rischin

Reviews

4.7 rating at LinkedIn Learning based on 1945 ratings

Start your review of Excel: Working Together with Power Query and Power Pivot

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.