This course is also available in: Norsk Norsk Svenska Svenska
Power Query Essentials

Learn how to pull and transform data with Power Query

Power Query, or Get & Transform, is Excel’s data management tool, which is used to, among other things, import, process, and combine data. You will learn how to organise and analyse data, and manage large databases professionally, which will become a huge time saver at work.

  • Go through the course at your own pace
  • Practical exercises and quizzes
  • Personal diploma
  • Save lessons as favorites
Learnesy
4.9
Based on 140 reviews
powered by Google
js_loader

Some of the things you will learn in this course:

Power Query Basics

Learn how to retrieve or “Get” data from the many different available sources, such as Excel files, other local files, or real-time data from the internet.

Manage Data

Working with formulas, combining queries, and making connections (“Joins”) to combine data is Power Query’s livelihood. Learn to do all this and much more!

Transform and edit

Learn how to transform data to suit the way you display information and insights. After the course, you will be able to normalise and merge columns and queries to make your data more accessible.

Combine queries

“Joining” is used to combine data in many different ways, such as Inner Join, Left Join, and Full Outer Join!

A lesson from the course

In this lesson named Grouping data we learn how to use the command “Group by”. Grouping in Power Query is a powerful feature for aggregating, summarizing, and organizing data. This function allows you to group your data by one or more columns.

When you apply grouping, Power Query creates a summary table based on the selected columns. For each group, you can perform various aggregations like counting, summing, finding the average, maximum, or minimum values. This is particularly useful in data analysis tasks where you need to consolidate and compare subsets of data. The Grouping feature simplifies handling large datasets by segmenting them into manageable and meaningful groups, making it easier to analyze trends and patterns. The feature simplifies handling large datasets by segmenting them into manageable and meaningful groups, making it easier to analyze trends and patterns.

Course Content

Expand All
Chapter Content
0% Complete 0/7 Steps
Get & Transform
Get Data
Get data from a different Excel file
Get data from Folder
Load as a Connection
Get data from Web page
External Data Sources
Chapter Content
0% Complete 0/3 Steps
Fill up and down
Split by Delimiter
Custom and Conditional columns
Chapter Content
0% Complete 0/4 Steps
Formulas and Functions in Power Query
IF Functions
IF & AND formulas
VLOOKUP in Power Query
Chapter Content
0% Complete 0/1 Steps
Grouping data
Chapter Content
0% Complete 0/2 Steps
Multiple tables
Combine tables with different headers
Chapter Content
0% Complete 0/8 Steps
Joining
Full Outer Join
Inner Join
Left Anti Join
Right Anti Join
Left Outer Join
Right Outer Join
Combining multiple fields

More about the course

Power Query, or “Get and Transform”, is Excel’s data management tool used, among other things, to import, process and combine data. Power Query gives us access to data from several different data sources. In this course we go through Power Query’s basic functions, and how we can apply them to different situations. After each lesson you’ll be asked to take a quiz to test your knowledge. Navigate further down to see which chapters and lessons are included in the course.

  • 24 lessons divided into 6 chapters.
  • Total video time: 42 minutes.
  • Estimated time to take the course including quizzes: 2 hours.
  • Average duration per lesson: 1 minute and 45 seconds.
  • Personal shareable certificate after completing the course.

Choose what suits you best:

Power Query Essentials

  • Choose the course that suits your needs
  • Access to all material 24/7 for 12 months
  • Complete the course at your convenience
  • Repeat freely throughout the access period
  • The course is maintained and updated
  • Personal and digitally shareable diploma
  • Save your favorite lessons
  • Contact us and we will help you choose the right one!
249 kr / month 2988 kr billed yearly. VAT will be applied.
Take this course

Pay with card/Klarna or invoice (pay within 30 days) for larger groups.

All courses

  • Access to the entire course catalog
  • Access 24/7 for 12 months
  • Complete the courses at your convenience
  • Repeat freely throughout the access period
  • Courses that are maintained and updated
  • Personal and digitally shareable diploma by course
  • Save your favorite lessons
  • Take full courses or see only the lessons you need
  • Contact us and we will help you get started today!
599 kr / month
7188 kr billed yearly. VAT will be applied.
Take all courses

Pay with card/Klarna or invoice (pay within 30 days) for larger groups.

For teams

  • Personal Account Manager
  • Personal account for all users
  • Choose the courses that suits your needs
  • Multi-user discounts
  • Optional Kickoff at startup
  • Statistics via Data Insight
  • Technical support
  • Unique login domain
Offer

Prices excluding VAT

Deloitte Deloitte Deloitte