Power Query - The Ultimate Data Transformation Program

Making Instant Consolidation Possible!

What you'll learn

Intermediate to Advanced Excel skills that will help you
- to ace your Excel skills,
- to find state-of-the art Excel functions,
- to make yourself the go-to-person in their office, or
- to be well positioned for your next promotion!

Requirements

Basic Excel knowledge
Example: be able to open one Excel file and add a new sheet, etc.

Description

If you find yourself taking forever to manually consolidate data from various sources and process them before feeding them into a report, or if you always need to copy and paste data ("data mover") from source file to the master file, multiple times, then this course is for you.

Join me in the course:

- to learn state-of-the art data transformation skills,
- to get exposed to the AI (Artificial Intelligence) that Power Query brings to us.
- to train Power Query how to process your data (machine learning)

It does not matter if you are an Excel novice, or an Excel Advanced user, everyone is sure to learn something new, I can guarantee you on that, as this happened to me time and time again when I tuned in to other master’s Excel lessons.

PS: Excel 2010 and newer is needed for this course.

Who this course is for:

Students (Secondary or post secondary), Office workers, Professionals, and Managers