Course description
The course provides a practical introduction to Power Query and demonstrates how the tool can be used to import, clean, transform and combine data from multiple sources. You learn how to build repeatable workflows that reduce manual work and improve accuracy in reporting and analysis. The course is based on realistic examples that reflect common tasks in finance and controlling roles. The content is delivered through pedagogical video lessons combined with hands on exercises that make it easy to apply the knowledge directly in your daily work. After completing the course, you will have a solid foundation in Power Query and be able to work in a more structured, efficient and reliable way with data used for financial analysis and reporting.
Information about the course
- Online course with access to the learning platform for 12 months
- Suitable for beginners and users who want to strengthen essential Power Query skills
- Video based learning combined with practical exercises
- Self-paced studies
- Certificate upon completion
- 2 Continuing professional education hours
Expenditure of time
The online course consists of approximately 24 short lessons, with a total of 42 minutes of video content. You will have access to the course for 12 months, allowing you to revisit and repeat the material whenever needed.
The purpose of the course is to provide you with fundamental knowledge of how Power Query is used to streamline data handling in Excel. The course shows how to structure and prepare data in a reliable way for analysis and reporting.
After completing the course, you will be able to independently use Power Query to import, process and combine data, as well as create reusable workflows. You will be able to reduce manual work and improve the quality of your reports and analyses.
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 work with data, reporting or analysis. The training is delivered fully online and can be completed at your own pace during the access period. The course is recorded using current versions of Excel and Power Query, and the content is adapted for practical use in a professional context. The course is continuously maintained and updated by Learnesy’s own course developers.
This course is also available in Swedish: Power BI - Grundkurs