Course description
Power Query or "get data and transform" is a self-service business intelligence for Excel which is used for discovering, combining, and refining data.
Power Query gives us access data from several different data sources. In this course, we will go through the basic functions of Power Query, and how we can apply them in different situations.
At this time, Power Query only exists on the Windows version of Excel.
Information about the course
- Full access to the course for 12 months
- 24 lessons
- Total video time: 42 minutes
- Average lesson duration: 1 min 45 sec
Expenditure of time
The online course consists of 24 short lessons, in total 42 minutes of video time. You will have access to the course for 12 months so you can go back and repeat whenever needed.
The purpose of the online course is to quickly become an advanced user of Excel. The course will make the program an important tool in your work that helps you save time and increase
After the course, Excel will be a more natural tool in your work. Among other things, you will have learned how to manage a database and analyse them by using Power Query. See the course chapters for further information.
The online course is a collaboration between FAR and Learnesy.
Chapters
- Get Data
- Data handling
- Functions
- Grouping
- Combine Queries
- Joining
Information
Requirements
Basic skills in Excel is required.
This course is also available in Swedish:
Grundkurs i Microsoft Power BI