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
Try some lessons in this course for free
Fill in your e-mail address and telephone and we will give you 7 days free access to some lessons in this course.
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.
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.
One course (Power Query Essentials)
249 kr / user / month
2988 kr billed yearly. VAT will be applied.
Educate yourself further with an online course in Excel, Power BI, SQL or Python – to name a few. Learney's concept is based on short lessons, quizzes and practice tasks. Learnesy's platform includes several smart features to facilitate your learning. For example, the ability to plan your learning, ask questions in our forum and favorite lessons for quick access. When buying a course, you currently get our course in Microsoft Copilot with the purchase!
All courses
599 kr / user / month
7188 kr billed yearly. VAT will be applied.
When you buy All courses, you get one year's unlimited access to the entire range of courses. This includes, among other things, 11 Excel courses and courses in Power BI, SQL, Copilot, PowerPoint and much more. The courses are completely online, which means you can study at your own pace and repeat the material as often as you like. After completing the course, you will receive a personal, shareable diploma. Here there is something for everyone and a lot for those interested in Excel and data analysis.
or
Read moreEducational scheme
- Access to all material 24/7 for 12 months
- Complete the course at your convenience
- Repeat freely during the access period
- Courses that are maintained and updated
- Personal and digitally shareable diploma per course
- Schedule and set goals for your learning
- Save your favorite lessons
- Ask your questions in our forum
- Tech Support
- Track and test your knowledge
- Admin features for your team
- LMS integration
- Discounts for multiple users
Business groups
With our platform, we focus on improving your company's skills through customized course content, flexible learning times, and tracking tools to track and test employee progress. We offer courses in several languages
- Personal Account manager
- Personal User Accounts
- Select courses
- Quantity discount
- Statistics
- Unique login domain
- Prior knowledge and follow-up test
- Compare progress with the group
Prices excluding VAT
Related courses
