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
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!
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
- Access to all material 24/7 for 12 months
- Complete the course when it suits you
- Repeat freely during access
- Course maintained and updated continuously
- Personal and digitally shareable diploma by course
Take this course
All courses
- 24/7 access to all of Learnesys courses for 12 months
- Take full courses or see only the lessons you need
- Save your favorite lessons with the favorite feature
- Get ongoing updates in the courses
- Personal and digitally shareable diploma by course
Take all courses
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
Prices excluding VAT
Related courses
A selection of customers:
