Course description
Power Query Essentials is an online course for professionals who want to work more efficiently with data in Excel. You will learn how to use Power Query - also known as Get & Transform - to import, clean, transform, combine and load data from multiple sources.
The course takes you through the essential Power Query workflow, from retrieving data from Excel files, folders, web pages and other sources to preparing datasets for analysis and reporting. You will learn how to split and create columns, use formulas and functions, group data and combine tables with queries and joins.
A key benefit of Power Query is that the steps you create can be reused when source data changes. This makes it possible to reduce repetitive manual work and build more consistent workflows for recurring reporting and analysis.
Through short video lessons, quizzes and practical exercises, you develop skills that can be applied directly to data preparation tasks in Excel.
Information about the course
- Online course with access to the learning platform for 12 months
- 24 lessons divided into 6 chapters
- 42 minutes of video content
- Estimated completion time: approximately 2 hours including quizzes
- Short video lessons combined with quizzes and practical exercises
- Self-paced studies
- Personal and shareable certificate upon completion
- 2 Continuing Professional Education hours
Expenditure of time
The course consists of 24 short lessons divided into six chapters, with a total of approximately 42 minutes of video content. The estimated time to complete the course, including quizzes and exercises, is approximately 2 hours.
You have access to the course for 12 months, allowing you to study at your own pace and return to individual lessons whenever you need to repeat a specific Power Query technique.
After completing the course, you will be able to independently import, transform and combine data in Power Query and create repeatable workflows that reduce manual data preparation.
The online course is a collaboration between FAR and Learnesy.
Chapters
- Get Data
- Basic data transformation
- Functions in Power Query
- Grouping Queries
- Combining Queries
- How to perform JOINS on tables
Information
The course requires basic knowledge of Excel and is suitable for professionals who regularly work with data, reporting or analysis and want to make data preparation more efficient and reliable.
You will learn how to retrieve data from several sources and transform it into a format suitable for analysis. The course covers practical techniques such as filling values, splitting columns, creating custom and conditional columns, grouping data and combining tables.
You will also work with formulas and functions in Power Query and learn how different joins - including Inner Join, Full Outer Join, Left Outer Join and Anti Joins - can be used to combine datasets in different ways.
The course is delivered fully online and can be completed at your own pace during the 12-month access period. The content is continuously maintained and updated by Learnesy's course developers.
This course is also available in Swedish: Power BI - Grundkurs
Course scope
2 Continuing Professional Education hours