The Power Query Pro Course 
Save Hours and Eliminate Frustration by Automating

Data Cleanup in Excel

We Now Live in a World

Of Data

Just about every action we take in our daily lives is recorded. Activities like taking a walk with our Fitbit, checking Facebook, replying to emails, navigating with our phones, and shopping online all create an abundance of data.

The companies we work for also create tons and tons of data! We have data about customers, vendors, competitors, employees, finances, and so much more...

In fact, most businesses spend over 80% of their time on data preparation. Leaving little time for analysis and, more importantly, decision-making!

So, what do we do with all this data? And how can we prepare it more efficiently and consistently?

Power Query to the Rescue

Microsoft has created a tool to transform and prepare data more efficiently. This tool is called Power Query (also known as Get & Transform), and it's revolutionizing the way we prepare data.

Extract and import data 

From a range of external data sources (or Excel), including data of all sizes and shapes (without making changes to the source data).

Transform Data More Consistently

These transformations can be as simple as removing a column or filtering rows, or as common as using the first row as a table header. There are also more advanced transformation options such as merge, append, group by, pivot, and unpivot.

Cleanse and prepare data

As well as combine/stack (append) or join (merge) data sets, group & summarize (Pivot), and load data into your preferred storage option using data flows

Who is this course for?

This course is for the beginner to intermediate Power Query user that wants to learn new ways to get and transform data.

Power Query is an excellent way to cleanse data more efficiently.  If you are currently stuck in a process of preparing data manually, without consistency, then this course is for you. We start with a bunch of raw data and prepare it step-by-step, so you should be able to follow along regardless of your experience level.

Experience with Excel, Power BI, or Power Pivot is NOT required for this course.

A Data Analyst's Dream 

As Excel users, we are fortunate to be living through this revolution. Thousands of companies have already started adopting Power Query as their data transformation and preparation engine.  

The best part is that Power Query is included in your Office 365 Subscription or "free" for Excel 2010 and 2013 for Windows.

Step-by-step Power Query Training Made Easy

  • I use my simple step-by-step training method in this course to make it easy to learn and follow along. 
  • You will be able to watch the videos and build your own Power Query engine. 
  • This is an online course, so you can watch and re-watch the videos anytime you'd like, from any device with an internet connection. 
  • You can also download the videos for offline viewing.
  • The course is comprised of short video lessons that are each about 5 minutes in length. This makes it easy to watch a video on a single topic and practice what you learn.
  • Each video lesson page in the course contains a comments section, so you can ask questions about the lesson. 

The Ultimate Power Query Course

The course is comprised of 8 training modules. Each module contains 6 to 10 short videos on the topic:

1

1. Power Query Overview

In this module, we give you a detailed overview of Power Query including the "4 Steps to Power Query" and its benefits overall. 

2

2. Intro to Transformations 

In 7, step-by-step lessons we introduce you to Transformations in Power Query. 

3

3. Basic Transformations

Now that you're familiar with Transformations overall, you will learn the basic principles of Transformations and how to apply them. 

4

4. Combining Data 

In section 4 of our course, we cover combining data through appending and merging. 

5

5. Advanced Transformations 

Now that you've mastered Basic Transformations, you're ready to tackle Advanced Transformations in unit 5.

6

6. Data Sources

In this module, we'll look at raw and exported data sources and the differences between them (as well as how to work with them).

7

7. M-Code Formula Language

In our final module, you'll learn how to write formulas, if statements, and more. 

7

8. Settings & Parameters

Learn how to make your Excel files more user friendly by fine tuning the settings and parameters of your queries.

Bonuses

For just $49, you'll get lifetime access to our course content plus our awesome Excel Campus bonuses.

Bonus 1: Tips, Shortcuts, and Hacks

Get exclusive access to our Microsoft MVP tips, shortcuts, and hacks for Power Query. 

Bonus 2: Got the Data, Now What? Pivot Tables & Dashboards 

Learn how to use Pivot Tables and Dashboards to present your new data more effectively. 

Bonus 3: Case Studies & Advanced Techniques

Now that you're a Power Query Pro, learn advanced techniques and apply your knowledge to real-life case studies. 

Bonus 4: The Best Course Site

Complimentary use of our e-learning platform, which tracks your progress and awards certificates. 

What Others Have To Say About Excel Campus Training...


Kristen Corbler

IT Project Coordinator and Data Analyst

The training gave me the confidence I needed to get in there and start working...

And also the very specific skills that I needed to finish my project. I love that the training [lessons] are bite-sized so I can go in and learn what I need to know and stay on track with my deadlines.

Grant Bagby

Excel Hero

I am now the Excel expert in the office...

And have already increased my earnings well beyond the cost of my investment. Your trainings have helped me learn so much and cement the skills I’ve gained. 

Charlotte Goodenow

Data Analyst

You and Excel have brought me out of the shadows and are helping me get recognized for the problem solver I have always been.

I'm not just that analyst sitting in the corner crunching numbers anymore. I am, I have always been…a problem solver. 

About Your Instructor | Microsoft MVP

Hi, my name is Jon Acampora and I am your instructor for this course.
I have been using Excel for over 10 years as a financial analyst and systems developer. Over that time I have become passionate about learning Excel and finding the fastest and most efficient ways to accomplish a task.

I have been awarded the Microsoft MVP Award for my contributions to the Excel community and for helping others learn.

More than anything, I really enjoy teaching you these skills and techniques to help you work efficiently and get your job done faster! I am always happy to help answer questions, and I'm here to support you on your journey to learn Excel (and impress your boss).


The contents of this course are valued at over $1,500 but today you can get it for only $49.

There's no risk with my 30-day Money-Back Guarantee

My goal is to help you learn Power Query so you can use your time more productively (instead of wasting it on tedious data preparation). These skills will allow you to easily maximize efficiency at your organization, and help you gain exposure to top management.

I want you to love this course and use it as a resource for continued learning. If you take the course and are not satisfied with what you learned, you can get a full refund.

FAQ

Do I need to know Power BI and Power Pivot before starting this course?

No. 

If you haven't used the Power tools yet, then this course will be a great introduction.  You will also be able to apply the skills and techniques from the course to Excel.

How Do I Download Power Query?

The Power Query Desktop Add-in is a free download from Microsoft for Excel 2010/ 2013.  It is currently available for Windows and should work on any PC. For Excel 2016 or newer, Power Query capabilities are integrated within the Data tab.

Note: If you're on Mac you can use Parallels or Boot Camp to run Windows. 

Which version of Excel do I need?

You will need Excel 2010 or newer. Please note: Microsoft is no longer updating Power Query for Excel 2010/2013, however, we do our best to create content suited to all versions of Excel. 

How long is the course?

The course is just over 5 hours of video in total.  This is divided up into categories (modules) and lessons.  Each video lesson is short, about 5-10 minutes in length. 

You can come back and re-watch the videos any time. The course site tracks your progress.  It is accessible on any device (computer, tablet, phone) and is very easy to use.

You will get a Certificate of Completion at the end of the course that you can add to your LinkedIn profile, resume, or hang on your wall.

Become the MVP of Your Data-Driven Organization