The Power Query Pro Course
Learn How to Transform & Prepare Data With One of Excel's Most Power Tools.
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
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. If you have multiple data sets that need to be copy/pasted together, then this module is for you. We also look at how to replace VLOOKUP/XLOOKUP with Power Query.
5
5. Advanced Transformations
Now that you've mastered Basic Transformations, you're ready to tackle Advanced Transformations.
This includes popular features like fill down, sorting, extracting, math, unpivot, splitting into rows, conditional columns and a lot more.
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
This section covers Power Query's formula language and includes writing simple formulas, if statements, tips for IntelliSense, and the advanced editor. You will learn about lists, records, and tables.
The section also compares Power Query and VBA, highlighting their differences, pros, and cons.
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 $397, 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 $397.
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
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.
You will need Excel 2010 or newer for Windows or M365 for Mac.
The Mac version of Excel is a bit more limited on features but Microsoft is working on rolling more features. If you're on Mac you can also use Parallels or Boot Camp to run Windows.
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.
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.