Data Analysis & BI

Microsoft Excel Power Query Course

About Course

How to get Power Query in Excel, do you have any idea about it? We are offering an extensive range of Excel Power Query tutorials for our users who want to upgrade their skills.

If you have been wasting vast amounts of time at work trying to gather, fix and combine your Excel data before you’ve ever done any analysis and reporting, then let our resident Data expert show you how Power Query Excel can transform the way you work!

HOW POWER QUERY EXCEL CAN PREVENT TIME-WASTING?

Power Query in excel is the No.1 feature added in the last decade because it can help you get data from various sources, no matter what format it is, and clean it all up for you with nothing more than a few clicks! Specifically, there are two ways Power Query in excel saves you vast amounts of time:

1. ​If you have reports that are frequently updated, then you just create a ‘Query’ from a source of data then all you need to do is press refresh every time you need to update, and Power Query excel will carry out all the little steps needed to clean up your data

 2. ​If you work with messy or unstructured data that consumes a lot of your time to clean up, then Power Query excel has some functions that instantly fix your data, such as un pivoting, appending, joining, and transposing, to name a few

Power Query’s magic is in saving you from all the usual ways to clean up your Excel data that are far too time-consuming. But it’s not just Excel data you clean up; it’s any data from most Databases, SAP, Salesforce, SharePoint, and so on.

 HOW WILL THE POWER QUERY EXCEL COURSE HELP YOU?

We have Power Query tutorials in this course that are taught by our in-house Data expert Ross Hughes who has over 30 years of experience working with Data in senior technical roles within major companies. In a few short hours of self-paced training, Ross will have you going through the full cycle of ‘Getting, Transforming and Refreshing’ your data, after which it will be ready for quick analysis and report. Ross’ experience is priceless; he shows you what is power query, how to get power query in excel, and how to harness Power Query, and to have him teaching you ‘over his shoulder’ is more than worth the price of the course.

What Will I Learn?

  • Introduction to getting data from various sources and cleaning it up
  • Rapidly transpose, pivot, and un-pivot your data to make it useful
  • How you can quickly combine multiple data sets by appending and joining
  • Speed up your data queries with duplication and tweaking parameters
  • Troubleshoot your queries and set up auto-refreshing of your data

Curriculum

39 Lessons5h 21m

GETTING STARTED WITH POWER QUERY

Introduction to Power Query
Getting Familiar with the Power Query Editor
First Data Clean Up for a Pivot Table
Tweaking our Query until the data is correct
Rounding data
Altering Data Types
Filtering out data before we load it
Advanced Calculated Columns
Grouping Columns
Using Columns From Examples

TRANSPOSE, PIVOT AND UN-PIVOT

COMBINING DATA FROM TWO OR MORE DATA SETS

4.DUPLICATION AND PARAMETERS

STEPS, GROUPS AND DEPENDENCIES

Student Success!

A. Saleem

Excellent Courses

“This course is excellent. The Skills I have developed have given me the confidence to tackle advanced problems in an Investment Banking environment. Unlike other courses, the tutorials are practical, to the point and are relevant to professionals. I would highly recommend this course.”
A. Saleem
Investment Banking PMO, London
james

Game Changer

“Sohail’s courses have provided me with the guidance and traction to hugely grow my earnings – in fact trebled my income over the past few weeks upon completion. This was due to the fact there’s a formula that for me clarified core missing pieces. For me this has been a real game changer and a catalyst.”
James Barton-Ginger
Senior Project Manager, New Zealand
mike

100% Recommend

“The VBA course has been a game changer as the ability to automate was something I longed for in order to be more efficient and more effective as a professional. I also really liked the PowerPoint lesson and the Marketing Your Skills lesson. This course is the complete package, I would recommend this course 100%
Mike Doubek
Project Manager, US
kiran

Huge Help

“I applied many of the skills I learnt through your excel course to automate many aspects of my work and it has been a huge help. My next step is to improve my VBA skills!”
Kiran Arain
Senior Financial Analyst, Canada

Some Of The Companies Our Students Work At

Frequently Asked Questions (FAQs)

Once you have signed up, then we will send you an email with a link to access our training dashboard; you can access all of our courses from this dashboard. All courses consist of video lessons that can be viewed on your device of choice, and also, to truly enhance your learning, you will access lots of exercise files relevant to the lessons.
It depends on your level of commitment. Our students have seen incredible results from as little as 30 minutes a day. But remember, the magic is in applying the skills as much as learning them. Our courses are designed with this in mind. On the very practical end, we have students who squeeze in a few minutes here and there on their commute, and some do dedicate 2-3 hour weekend sessions. One of our most successful students, Jayne managed to get up at 4 am to learn! This paid off massively as it landed her a six-figure analyst job in a bank!
Yes, this is quite common since we focus on helping actual corporate employees. Note that for teams, we offer bulk discounts. However, this needs to be done with a corporate credit/debit card. We don’t accept transfers/remittances. Get in touch if you have any specific questions.
Yes, we do; we will dust it off if you need it because it rarely happens! You have 30 days to let us know that the training isn’t right for you and we will happily refund you.
You can either purchase access to one course or all of our courses, which are listed above. We have done in a post-COVID-19 world to keep our prices low to accommodate as many ambitious people from all over the world who are looking to upskill through our high-level courses without the burden of high expense.
We recognize that people prefer to pay in their own currencies, and especially when our main product is a recurring membership to all our courses, you can rest assured knowing that fluctuations in currency won’t affect your financial commitment.
Great question, well frankly we make the best courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and, more importantly, leave out what is unnecessary and thus a waste of your precious time.
Level
Expert
Duration
5h 21m
Subject
Data Analysis & BI
Enroll Now

Pricing

Lifetime Online Access​
$
199
Lifetime
  • Access this course online
  • Including exercise files & supporting material
  • Certificate of completion
  • Email Support for 12 months
  • Download the course
Sign Up
Copyright © 2022. All rights reserved.