Microsoft Excel Power Query Course

Microsoft Excel Power Query Course

Categories: Data Analysis & BI
Wishlist Share
Share Course
Page Link
Share On Social Media

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.

Show More

What Will You 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

Course Content

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

Your Instructor

tayyab