Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

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

Go to class Write review

Overview

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
Conclusion
  • Next steps

Taught by

Joshua Rischin

Reviews

4.6 rating at LinkedIn Learning based on 370 ratings

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

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.