Study Learn Grow
Excel Power Query Crash Course

Excel Power Query Crash Course


In this crash course, you will learn how to find Power Query, load data into it, begin the process of transforming your redundant tasks (one last time!), and then how to Save and Load the Query to Excel to finish your reports.

Overview

About this Course
When the daunting task of 'cleaning up data' comes across your desk, are you using the amazing features of Excel's Power Query? This is a somewhat new feature, it first made its entrance in Excel 2010, and now is a standard part of Excel 2016 and 2019. In this crash course, you will learn how to find Power Query, load data into it, begin the process of transforming your redundant tasks (one last time!), and then how to Save and Load the Query to Excel to finish your reports.

Basic knowledge
This is an advanced level course for Excel users that find themselves repeating data-clean-up tasks

Course Information

This is an advanced level course for Excel users that find themselves repeating data-clean-up tasks

What you will learn
How to begin a Power Query
How to Extract data from your Source files into the Power Query
How to Transform the data (clean it up)
View a few examples of the Transform process
Learn the power of the Query Settings and the Advanced Editor
How to Load the data and Save the Excel file
And finally, how to re-open and edit the Power Query Settings

Any Excel user who is tasked with preparing data for further analysis and charts

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs