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

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
University of the People Ad

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

Learn More → DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More →

Overview

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 1923 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.