Go from Zero to Excel Hero
Save Time, Reduce Errors, and Boost Productivity with the Power Query Jumpstart Course
Is Data Cleanup Draining Your Time and Energy?
You're Not Alone.
- You’re tired of wasting your time collecting, organizing, and cleansing data.
- You're constantly prioritizing work that is not only boring, but also time consuming AND prone to errors.
- And if you dedicate even a few hours to calculating, visualizing, or presenting your findings...you inevitably come back to a mountain of new data.
-
You can never catch up, and it feels like you're drowning in data.
-
Stress is at an all-time high, and you're feeling overwhelmed.
This doesn’t leave much time for important tasks like analyzing and presenting data. Which are the most important steps in producing results that your employer cares about.
Every second spent on manual data preparation is a minute lost on valuable analysis and decision-making
The constant struggle with data can lead to burnout, low morale, and costly errors.
Your productivity and job satisfaction are at stake, and so are the potential savings for your company.
And While You May Feel...
Reluctant to make dramatic changes to your workflow.
Nervous about presenting changes to management and facing resistance.
You KNOW that you're desperate to avoid burnout
And you’re tired of sacrificing your evenings and weekends playing catch-up at work.
So, what if you could eliminate the grunt work and focus on meaningful data analysis?
What if there was a way to automate repetitive tasks, and free up valuable time for impactful decision-making instead?
How Power Query Made Me Irreplaceable in My Job
I spent years learning to write macros just to automate my data cleanup tasks.
It was a painstaking process that required a lot of coding knowledge and time. But then, I discovered Power Query.
With Power Query, I was able to automate all my data preparation tasks WITHOUT writing a single line of code.
Just by pushing buttons, I could streamline complex data tasks in a fraction of the time.
I went from disposable to irreplaceable, and I want to help you do the same.
It's Time to Jumpstart Your Excel Skills.
Like me, you can automate your way through countless promotions, and learn how to manage your data more efficiently than ever before.
We Saved Over $500K
By Mastering Power Query, You Will...
CUSTOM JAVASCRIPT / HTML
Most importantly, you’ll be happier.
Not only will you become the go-to Excel expert in your company — thereby making yourself utterly essential — you’ll also improve your future job prospects and chances for promotion.
If you want to grow in your career, boost your morale, and have a more efficient workday, it’s time to change your workflow with Power Query.
You're Invited to Join Power Query Jumpstart.
The Power Query masterclass you need to become a better data analyst.
With Power Query You Can…
Extract and Import Data
No more boring, repetitive tasks: using Power Query you can extract data from a range of external sources without making changes to the source data.
Transform Data More Consistently
Using transformations, you can perform both complex tasks and simple, such as removing columns or filtering rows.
Cleanse and Prepare Data
With Power Query, you can combine/stack (append) or join (merge) data sets, group & summarize (Pivot), and load data into storage with a few, quick clicks.
From Excel Zero to Excel Hero
CUSTOM JAVASCRIPT / HTML
If Our Other Students Can Achieve These Incredible Results
with Power Query, Then You Can Too.
So, What's Included?
Basic Transformations
In this lesson, we'll explore how to effectively manage data right from your worksheet, demystifying the Power Query window along the way.
Learn how to streamline your data by removing unnecessary columns, filling down, and effortlessly splitting text. Take your analysis further by performing calculations, and mastering the art of closing and loading your transformed data.
Combining Files
In this lesson, we cover how to seamlessly combine or stack data sets using the Append function in Power Query, a vital skill for any data professional.
Dive into the process of retrieving data from folders, cleaning it up with precision, and effortlessly outputting it to Excel for seamless analysis. But wait, there's more – discover how these techniques extend beyond Excel, as you explore integrations with various data sources and databases.
Replacing VLOOKUP
In this lesson, we'll explore how Merge, a powerful feature of Power Query, replaces the need for VLOOKUP by simplifying data matching without the need for complex formulas.
Discover the basics of joining data sets and witness the magic of Merge in action. But that's not all – we'll also look into more advanced techniques, such as anti-joins, and show you how Power Query can elevate your data merging game to a whole new level.
But Wait, There's More!
For just $27, you'll get lifetime access to our course content PLUS our awesome Excel Campus bonuses worth over $1,250.
$27
Lifetime Access
- Certificates of Completion
- Access to our moderated comment sections to get your questions answered by our team
- Free use of our online learning platform with offline viewing capabilities
-
Practice files and downloadable Excel sheets
-
Bonus training on Excel dashboards
-
Exclusive entry to our Excel Blueprint Training
- My bite-sized lessons are perfect for the busy professional who doesn't have time to waste on boring, expensive, in-person seminars.
- This course is self-paced and designed to take you from beginner to advanced Power Query user through simple, concise, and on-demand training.
- Each lesson is 5-15 minutes in length and can be watched from any device with internet connection (including our mobile app).
- Plus, you'll get exclusive access to lesson comment sections for questions and networking opportunities.
Bonus Training: Excel Dashboards Made Easy
Once you start implementing Power Query, you will have more time to focus on the next steps in the data analysis process - analyzing and visualizing your data.
So, we've included a bonus training that's a crash course on creating interactive dashboards in Excel.
You are going to learn how to quickly analyze your data to discover new insights that will impress your boss and help make a bigger impact in your organization.
The bonus includes the video lesson and the before & after
Excel files that you can use to follow along.
Get ready to create end-to-end, fully automated data solutions, that will help skyrocket your career.
Frequently Asked Questions
Which Version Of Excel Do I Need?
You will need Excel 2010 or newer for Windows or Microsoft365 for Mac.
Please note: Microsoft is no longer updating Power Query for older versions of Excel, however, we do our best to create content suited to all versions of Excel.
Do I need to be an Excel expert before starting this course?
No.
We designed this course to be suitable for Excel users at the beginner to intermediate level. Power Query is a feature of Excel that will save you a ton of time, and we created this program to help make it accessible to more users, regardless of your current skill level.
Yes.
There is a comments section at the bottom of each lesson page where you can ask questions. Our team of Excel experts here at Excel Campus will help answer your questions.
You will also be able to see questions (and answers) from other members of the program.
Our goal is to help you learn quickly and efficiently, and we encourage you to ask questions.
How Do I Download Power Query?
For Excel 2016 for Windows and later, and Microsoft 365 for Windows or Mac, Power Query is built into Excel and found on the Data tab. You do NOT need to download or install anything.
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. This program focuses on Power Query for Excel, but you will also be able to apply the skills and techniques you learn to Power BI in the future.
Think of this program as your steppingstone to more advanced data analysis skills and tools.
If you are unsatisfied with your purchase for any reason, contact us within 30 days of purchase to get a full refund. We want you to be fully satisfied, learn a ton, and produce amazing results!
How long will it take me to complete the course?
This course has been designed to get you up and running with Power Query in under 90 minutes. Our goal is to get you success with Power Query, quickly.
You will use the companion Excel files to follow along and get hands on experience with real world examples.
We made this course short and succinct so that you can start implementing Power Query in your work immediately, to help produce results that matter to your organization.
About Your Instructor, Microsoft MVP
My name is Jon Acampora and I am your instructor for this course.
I have been using Excel for over 15 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 the past 11 years in a row) for my contributions to the Excel community.
My mission help others learn and thrive with Excel.
My courses are trusted by thousands of organizations, including:
You Have My 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. But if they don't? You get your money back. No questions asked.
Join Us, For This Limited Time Offer
For just $27, you'll get lifetime access to our course content PLUS our awesome Excel Campus bonuses worth over $1,250.
$27
Lifetime Access
- Certificates of Completion
- Access to our moderated comment sections to get your questions answered by our team
- Free use of our online learning platform with offline viewing capabilities
-
Practice files and downloadable Excel sheets
-
Bonus training on Excel dashboards
-
Exclusive entry to our Excel Blueprint Training