Master excel power query
Beginner to Pro


Become the Excel hero with Power Query

Discover the smarter, faster way to handle data with our Power Query course. You’ll be able to turn every data task into a chance to stand out. Become the go-to Excel problem-solver at work with this essential skill.

This course is for everyone, no matter what job you do. We’ll start from scratch and before you know it, you’ll become a Power Query expert.

Think of this course as your all-in-one solution. While you might find snippets of Power Query knowledge on YouTube, they fall short. Ours is comprehensive, covering niche, real-world topics that free content usually doesn’t touch. It’s about making your work life not only easier but also more enjoyable.


What you’ll achieve with our Power Query Course

Effortless Efficiency!

Yes, efficiency can be effortless once you discover a new way of handling your data. The only regret? Not discovering this sooner – which is what we hear the most from our members. But remember the saying: The best time to get started was yesterday. The second best time is today.

Become the Office Star

Even if you prefer to stay low-key, your newfound Power Query skills will speak volumes. You’ll naturally become known as the go-to problem-solver in your office, a reliable expert whom colleagues admire and turn to for solutions.

Master Problem-Solving Techniques

Start using outside-the-box techniques to tackle Excel challenges. Whether it’s combining data from various sources, importing from PDFs or the web, or tidying up messy data filled with spaces, blank cells or messed up columns, this course will teach you smarter techniques, saving you time and energy.


Leila has changed the course of my career. I used to direct live news. I am now a Business Analyst and manage reporting requirements for my company. This is the best money I ever spent on my education.
Leila and her team crafted a structured & thorough course on Power Query that will undoubtedly give your career an incredible boost.

How Power Query Can Change Your Life

Make Your Excel Life Easier with this Power Query Training

Inside your Microsoft Excel window sits a magic button.

It’s not called “Power Query” – instead it’s called “Get Data” (in the Data tab).

Your data could be ANYWHERE. It could be sitting right there on the sheet you’re on. It could be in another Excel file, in a text file, on the web or in a PDF document.

The instant you click this button, a new world opens up, helping you to quickly complete tasks – whether it’s cleaning up mixed-up rows or messy columns, combining data with other files or anything else you need done.

Once you know your way a round – even just a little bit – you get to do things that only Excel gurus used to be able to do.

Now these advanced techniques are just a “click” away for you.

They can save you from pulling your hair out as you clean data.

You can replace hours and hours of manual labor.

And you can ship reports to your boss and colleagues faster – winning you praise and promotions.

The best part: Power Query remembers your steps!

Next time you need to do the same thing, you just open your file and click “Refresh” – then sit back and enjoy the show (i.e. watch the magic happen as your data updates automatically).

Let me give you more details – let’s visit a typical day in the life of an Excel user.

“Here’s Your Data Dump. Enjoy!”

Ugh 😒

Is there anything that spikes your blood pressure more than being sent a massive data file you’ll need hours to clean?

You reply to your colleague through gritted teeth:

Thanks! Will have you those reports asap!

You stare at the file the same way you stare at that closet you haven’t cleaned in seven years.

I’m afraid to even touch it.

Yet, you must. So, you open the file…

My gosh, it’s even worse than I thought.

You’re staring at a crime scene.

It is indeed a great course that gave me tons of practical knowledge on how to process data. Had I known those techniques, my life would have been way easier.

“I’ll try copy & pasting…”

Is copying and pasting your method of choice? It makes sense.

After all, a quick Ctrl-C and Ctrl-V and voilà! Everything is perfect, right?

In our dreams.

Copying and pasting is fraught with problems:

  • It’s frustrating, especially if you’re dealing with multiple sheets and workbooks
  • It’s too easy to make a mistake and leave data behind (Repeat after me: “No data left behind!”)
  • Each time you receive new data you must repeat the copy/paste over and over and over and over…
  • What if the data is in a text file which has more data rows than Excel can handle?

Get my point?

But Let’s Say You’re Able To Get The Data Into Excel.

Off to the races? 🏇

Hardly!

It’s one thing to have data in Excel, it’s another to have clean data in Excel.

Oh, how we wish all data could be delivered to us on a silver platter. We’d give our colleague a warm, “Thank you!” and maybe even a hug.

Instead, we groan…

You put the data in a PDF? Really?!

Or…

Why the heck would you put the customer ID and the customer’s name in the same freaking column!?

Or…

Why does your SAP export have leading spaces?

But you push your frustration down deep, check how many days are left til’ Friday, and soldier on…

I underwrite value on mobile home parks and RV’s.

99% of the time, the books and records come to me as PDF documents. If it wasn’t for Power Query, I would spend more time converting than actually doing my core job of underwriting.

James W.

“Let Me Add A Helper Column”

You get to work cleaning and shaping the data 💪

It’s like ironing a crumpled suit you found in the back of that long-neglected closet.

You need a tool.

“I’ll add a helper column,” you say to yourself. “That will help me remove these dang spaces.”

You add a helper column. Then another, and another.

Next, you start adding complex formulas. You’re hoping they will do the heavy lifting and iron out your messy data.

They do, but at a cost.

After lunch, you sit back down at your desk and re-launch your Excel file.

“Uh-oh.”

Excel freezes for a split-second, and then finally, your file opens.

“It’s slowing down.”

All those lengthy formulas and helper columns bloated your file.

“If I send my boss this 40MB file, she’ll kill me.”

You look down at your coffee mug and decide it needs refilling.

Your Excel Life Doesn’t Need To Be This Way!

If you regularly import data into Excel, please, let me make your life easier 🙏

I have two words for you: Power Query

Often overlooked because Microsoft tucked it away inside the “Data” tab back in 2016, Excel users worldwide are finally waking up to the gift that is Power Query.

Because you’re not alone in your struggles to add and clean data in Excel. Not by a long shot.

Before graduating from our Excel Power Query training, our students felt the same way.

Many times we receive our data in less than pristine condition. This course is filled with tools and techniques that will allow us to solve these problems with much less effort. Tasks that we would not undertake due to complexity and effort are now enjoyably achievable.

Stephen Azzarello, Senior Project Manager

Today, these students and thousands more are saving hours each day thanks to Power Query.

This is the best money I ever spent on my education. Leila has changed the course of my career. Her teaching skills are unmatched. I used to direct live news and have a master’s in communication. I am now a Business Analyst and manage reporting requirements for my company.

Amrita O’Sullivan, Business Intelligence Developer

I swear, using Power Query must be the same feeling people had 100 years ago when they drove a car for the first time. It lets you go fast 🚀

In that spirit, it’s time for you to trade in your horse & buggy and enter the Excel fast lane.

Data To Dashboard in 60 Seconds

Need to send a dashboard to your boss or colleague?

Ah, we finally return to that magic refresh button. Because do you want to know the best part of Power Query?

  • It’s not that it can connect to almost any data source, even data sitting on a webpage.
  • It’s not Power Query’s ability to clean data with a flick of its wrist.
  • It’s not how Power Query eliminates complex formulas, liberating you from having to become Severus Snape, Excel potions master.

Yes, those are all wonderful benefits provided by Power Query. But its best feature?

It’s this: Power Query remembers.

Yes, you can record the steps you take to import and clean your data. That way, when a new batch of data arrives, all you need to do is click “Refresh.”

Instantly, your data is imported, cleaned, and beautifully presented.

No more copy & paste. No more helper columns. No more mixing together complex formulas.

You simply click that magic button. That’s how you go from data to dashboard in 60 seconds.

This has saved me quite some time which I used to spend doing things manually.

I have prepared some other reports by combining data from multiple files in a folder. Any time a new file was added to the folder, I would see the latest numbers in my report.

I helped a colleague with a CAPEX report using Power Query, and she told me that I saved her one whole day of work.

In the words of José Carlos (a student of ours) – “Can we call that magic :)?”

🆕 Certified Achievement Badge

Earn Your Digital Badge Powered by Credly

After completing the course, you’ll receive a digital badge. It shows potential employers that you have mastered Excel Power Query, gaining essential skills in data manipulation and automation.

This credential showcases not just proficiency in Excel Power Query, but a real-world capability to impact corporate decision-making and efficiency.

Our Digital Badges can easily be shared. You can add them to your LinkedIn profile, include them in your resume, or spread the word across your social networks – all it takes is a simple click.

Stand out to employers by clearly displaying your skills with a digital badge from XelPlus.

Wave “Goodbye” To Manual Work Inside Excel.

Enroll today and make your Excel life faster & easier.

How Many Hours Are You Losing By Not Fully Harnessing Power Query?

If you regularly import data into Excel, it’s a no-brainer.

Your time is too precious to not use Power Query. But in my experience, even most daily Power Query users are only scratching the surface of what’s possible.

For example, they don’t realize Power Query allows them to:

  • Connect directly to websites and fetch data
  • Remove duplicates in an intelligent way
  • Hunt down errors inside columns (for example, when different date formats are used in the same column – don’t you love that?)
  • Combine data from multiple Excel workbooks into a single Table (or Pivot Table)
  • Consolidate data from all files in a folder (and make exceptions as you need)
  • Connect your Excel workbook to Microsoft Outlook

Not to mention the file-shrinking wonders Power Query provides. Look at this experiment I ran…

Without using Power Query, the size of this Excel file was a whopping 41MB. After Power Query?

The file size shrank to 5MB!

Would you rather send a 41MB or a 5MB file to your boss?

Data management without using Excel Power Query
Without Power Query
Data management - reduce file size with Excel Power Query
With Power Query

I was still going through the course when my wife, who is a consultant, received an assignment from a client to help them recover the data about their P&L after virus compromised their data.

She had to reconcile the current data with some older extracts and the files were huge and not easy to reconcile with normal look-ups due to multiple instances of the same account.

Her colleagues tried to do the job for some time and failed so they asked her to try to solve the issue. I managed to help her using Power Query with some of the techniques from this course, I finished the task in a couple of hours (since I am not yet familiar with PQ and it took me some time to troubleshoot some issues, otherwise would have been minutes).

And my file ended up only at 1.5 MB, very fast to open and work with. The previous attempt was about 45 MB, full of formulae, heavy to open and work with and also it caused occasional Excel crashes… I can’t believe how easy this was really!

Dragan Yordanov, Controller

I Avoided Excel Power Query For A Long Time

If you’re new around here, I’m Leila Gharani, founder of XelPlus.

I avoided Power Query for a long time. I had watched multiple videos and I thought,

“This is a Power Tool. I don’t work with millions of rows of data. I don’t need this.”

But then in 2018, the Microsoft Team presented some updates they’d implemented in Power Query. And I realized, I had watched the wrong videos. There was an easy side to Power Query and an advanced side. I’d jumped right in with advanced techniques. No wonder I tried to avoid it.

You see, as a Microsoft MVP, I get invited to Redmond, Washington each year for the Global MVP Summit. In between the yearly visits, we have monthly sessions where the Microsoft Excel team gives us updates on the latest features (yes, it’s pretty cool).

It was on one of these calls where I saw the easy side of Power Query in action for the first time. My initial reaction was, “Wow! That is incredible.”

I also realized my mistake. You see, at first, the name Power Query fooled me.

Judging by the name, I thought it was a tool for power users. When actually, it’s a power tool – for everyone.

Power Query is not reserved for Excel masters. Rather, it’s a powerful tool that can benefit even the Excel beginner. At the end of the day, Power Query is nothing more than a series of clicks.

After that meeting with the Microsoft team, I knew I must teach it to our XelPlus audience. That’s when I started working on our online Excel Power Query training.

Today, I’m excited to invite you to become a student in that course. It’s now helped thousands of Excel users shave hours off their workday tasks, and it can help you too.

Here’s Your Learning Journey

Leila Gharani introduces you step-by-step to Excel’s biggest time-savings feature.

You’ll be up and running with Power Query in just an hour. You can view the detailed curriculum below.

See anything that jumps out? Which lesson do you think you’d begin with?

Power Query Course

Master Excel Power Query – Beginner to Pro

Start using Excel in the Power Mode. Just by finishing the FIRST hour, you’ll be amazed at what you can achieve with Power Query. It will give you tons of ideas on how to make your work easier.

This Excel Power Query training includes:

Over 18 hours of video content

Downloadable Workbooks and Templates

Challenges & Quizzes to test your skills

LIFETIME Access so you never feel rushed

Comment sections to ask questions and get answers from our friendly teaching assistants

CPD Accredited Certificate of Completion

English Closed Captions

BONUS Quick Reference eBook

BONUS Solutions Book

BONUS Training to Become PRO in Power Query

Section 1: Introduction

Applications of Power Query
Preview
Important: Excel Versions, Expectations & Course Pathways
Preview
(For older Excel versions) Workaround for Loading as Pivot Table
DOWNLOAD ALL Files & How to Use Them
Quick Check-in

Section 2: Power Query Essentials

What You Can Achieve by the End
What is a Proper Data Set?
(In case you need to) Links to Brush up Your Excel)

Section 3: The Power of Power Query

Analyze Large Data Quickly! Pivot Table or Power Query?
Preview
Power Query Overview: Import Large Data from Another File
Power Query Editor & Basic Transformation
Quick Insights on Data Quality & Distribution (Hidden Feature)
Formula Bar, Applied Steps & M Code
Close & Load Destinations (How to Change Them)
Refresh Data & PQ Refresh Options
Import CSV File & Extract Text Based on Pattern
Merge Data with Another File (Pivot Table from Multiple Files)
Old School Method: What if There Was NO Power Query?
Activity: Get Familiar with PQ

Section 4: Important Power Query Tips & Tricks

Uploading Data From Excel
The Hidden Table Method (Hidden Feature)
Handling Changes to Source
Data Types
Data Types vs. Formatting & Null Values
Power Query Navigation Shortcuts (Become Pro)
Finding & Correcting Errors in Data
More Data Views: Duplicate OR Reference Query?
Keeping an Eye on Query Dependencies
Delete, Manage, Copy Queries & Backup Results (Become Pro)
CHALLENGE – Find and Correct the Mistake
QUIZ – Power Query Tips & Tricks
Best Practice for Power Query

Section 5: Helpful Power Query Transformations

Text Transformations (Format, Extract & more)
Preview
Merging Columns & What to Watch Out For
Fill & Replace Values to Create Proper Datasets
Sort Data including Multiple Levels
Remove Duplicates including Multiple Columns
Number Transformations & What to Watch Out For
Working with Filter (AND & OR Conditions)
CHALLENGE – Can you Find the Mistake? Problem with Filter
Change Type & Remove Columns Trap
Key Takeaways – Helpful Power Query Transformations

Section 6: Powerful Power Query Transformations

Column From Examples – Extract Patterns Quickly
Allocate Data to Groups or Buckets (Become Pro)
Conditional Columns in Power Query
Aggregating (Grouping) Data on Multiple Levels
Group By for All Rows (Become Pro)
Unpivot Columns – Basics
Unpivot & How to Overcome Common Errors
Pivot Columns – Basics
Problem with Split by Delimiter (that’s easy to miss)
Split Column by Rows instead of Columns
CHALLENGE – Summarize Sales By State
Solution: Summarize Sales By State (Bonus Map Chart Included)

Section 7: Date & Time Transformations

Date Transformations (Extract Age, Weekday etc.)
Creating Dates from Text or Columns (Become Pro)
Time Transformations (Calculating Hours worked)
Date & Number Errors When Importing Data (Locale)
CHALLENGE – Pivot Table for Hours Worked by Month & Week Number
Solution: Pivot Table for Hours Worked by Month & Week Number
QUIZ – Date & Time Transformations

Section 8: Custom Column & Basic M Manipulation

Important Basic Power Query M Logic
Why Use Custom Columns
Introduction to “Add Custom Column”
Custom Columns Type Compatibility & Intrinsic Functions
Skipping Steps in Power Query (Become Pro)
Adjusting FILTER & Conditional Columns to Reference a Dynamic Variable
Drill-Down in Power Query
Custom Formulas for Template Creation (Hidden Tip)
QUIZ – Custom Columns and Basic M
Key Takeaways – M Basics

Section 9: Power Query Data Sources (Online)

Connecting to different Sources
Import Data from a Website
Automatically Connect to Files on Websites (Hidden Feature)
Import Data from ODATA
Get Google Sheet Data with Power Query
Connect to Outlook Online (Microsoft Exchange)
Connect to SharePoint or OneDrive for Business
Pro Tip: How to Change Source from Local to SharePoint
CHALLENGE – Google Sheets Survey “Your Dinner Plans”
BONUS FREE LIBRARY & NEW Custom Data Types

Section 10: Combining / Appending Data

Why Append Data? The Difference Between Merge & Append
Combine / Append Data from Multiple Workbooks
Combine All Files in a Folder (with Excel Tables)
Combine All Files in a Folder (Without Excel Tables)
How to Adjust Folder Path from Local to SharePoint Drive
Combine All Sheets in a File (Pivot Table from Multiple Sheets)
Overcome Potential Errors when Combining Sheets (Become Pro)
Consolidate Data from Multiple Sheets in the Current Workbook
CHALLENGE – Consolidate Data from Folder (with a twist)
Solution: Consolidate Data from Folder (with a twist)
Tips & Key Takeaways When Appending in Power Query

Section 11: PROJECT – Report on HR Data

Test Your PQ Knowledge by Completing This Project
Calculate Years Worked in Each Position
Calculate Years Worked in the Company
Split First, Last & Middle Names to Separate Columns
Key Takeaways – Data Analysis & Preparation with Power Query

Section 12: All Merge Options – Join Kind Options Explained

Overview of Merge Options and Join Kinds
Left Outer Join & Right Outer Join
Merge Based on Multiple Columns (Become Pro)
Can You Find the Mistake? Merging Text Columns
Merge Data to Get Multiple Match Results & Bonus Tip
Inner & Full Join in Power Query
Left & Right Anti Join when Merging in Power Query
How to Use Fuzzy Match in Power Query
Fuzzy Match with Transformation Table (Hidden Feature)
CHALLENGE – Someone Hacked the Salary File – Find Mismatches in Data
Preview
Solution: Someone Hacked the Salary File – Find Mismatches in Data
Key Takeaways – Power Query Merge Kinds

Section 13: When to Use Power Pivot & Load to Data Model

When to Load Data to the Data Model
Availability of Power Pivot
Pivot Table from Multiple Excel Tables
Power Pivot Table with Data Model & Power Query
Create a Calendar Table in Power Pivot
Pivot Slicers & TimeLine with Power Pivot & Power Query (Become Pro)
Key Takeaways – Data Model & Power Query

Section 14: Power Query Advanced to Pro

What You Can Achieve as an Advanced Power Query User
You’ve Come So Far!

Section 15: Solving Complex Data Analysis Problems with Merge

Learning Objectives for this Section
Messy Data from Multiple Rows to One Row (Create Proper Data Set)
Search and Replace Bulk Values
Calculate Value Difference to Previous Row
Approximate Match Lookup with Merge
CHALLENGE: Create a Report based on Multiple Parameters
Solution: Create a Report based on Multiple Parameters

Section 16: Advanced Problem Solving using the Power Query Interface

Learning Objectives for this Section
Assign Unique Number to Group
Advanced Unpivot Techniques
Advanced Pivot Techniques
Incremental Data Load & Self Referencing Query (Hidden Tip)
Key Takeaways: Advanced Problem Solving

Section 17: PROJECT – Create a Modern Excel Dashboard with Power Query & Pivot Tables

Excel Dashboard Project Overview
Prepare a Draft of the Dashboard
Import Master data from External Workbook with Power Query
Import Data from Text File with Power Query
Create the Data Model & Define Relationships in Power Pivot
Create Logic for Latest and Previous Month in Power Query
Setup Calculations with Pivot Tables for Latest Month
Link Excel Shapes to Data & Linked Picture Trick
Top 3 Sales Managers & Numbers (Sorted Excel Pivot Table)
Linked Table for Sales by Product Category
Excel Pivot Chart for Monthly Sales
Pivot Slicer Connected to Multiple Pivot Tables
Finalize the Excel Dashboard
Key Takeaways: Excel Dashboard Project

Section 18: Understanding M Formula Language (Let, Lists, Records & Improving Performance)

M Language – How M Thinks (let Expression & Values)
Defining & Invoking Custom M Functions
Reference Guide for Standard M Functions
Lists & Records and how to Reference a Specific Cell in a Table
Summarizing Brackets & Lookup Operators in M code
Creating Lists and Tables inside Power Query
Understand Each Keyword & the Purpose of _ (underscore)
Using Power Query Parameters
IF Then & Lookup Operators to Lookup Values in Previous Row
Error Handling – Bulk Replace Lookup with Try Otherwise
Speed up Queries: Table.Buffer & How to Test Impact (Hidden Tip)
Query Folding – Improve Performance for Relational Databases
QUIZ: Test Your Knowledge – Understanding M
Key Takeaways & Power Query M Formula Language Specifications

Section 19: Working With List & Table Functions

What You Learn in this Section
Create a Calendar Table From Start to End Date
Power Query Text Functions (Text.Contains, Text.Replace)
How to Use List Functions in Custom Column
Merge Values from Rows into One Cell

Section 20: Creating & Invoking Custom Functions

What You Learn in this Section
Unpivot & Consolidate Data From Multiple Sheets (with Custom Function)
Rank by Group (Nested Rank) with Power Query
Running totals by Month (Invoking functions)
How Far You’ve Come!

Section 21: Flexible Importing of Data with the Help of M Functions

What You Learn in this Section
Better Collaboration: File Path as Parameter in Power Query
Better Collaboration: File Path from a Cell (Formula.Firewall Error)
Import from Folder: Mixed Letter Case Headers & Trailing Spaces
Import All Sheets BUT Data Starts from Different Rows
CHALLENGE: Combine Sheets & Get Name from Cell Value
Solution: Combine Sheets & Get Name from Cell Value

Section 22: PROJECT – Power Query and Power BI

Project Overview of Power BI Dashboard
Install Power BI Desktop & Quick Overview
Upload & Transform Data with Power Query in Power BI
Setup Data Model & Create Relationships in Power BI
Create Your Dashboard & Reports within Minutes
Publish Dashboard to Power BI Service
Key Takeaways – Power Query & Power BI

Section 23: Final Words

Wrapping up & What’s Next
What You’ve Achieved!
This is the definitive course for Power Query. It’s a fun, engaging way to learn with a perfect amount of theory and practice.

Yes, it’s a BIG course. Which means it has everything you need for Power Query.

But it might also be intimidating, too. Don’t worry. You don’t need to go through every single lesson before seeing benefits. In fact, go through just 5% of the course and you’ll save hours of time in Excel.

Plus whatever you learn in this course you can apply 1-to-1 to Power BI as well.

In addition to the main course, we also have a few excellent bonuses. I want you to have as few “Excel headaches” as possible, and these bonuses are like an Excel aspirin.

Bonus 1: Power Query – Quick Reference Guide

When you have a tight deadline and the pressure’s on, you don’t always have time to log into an online course and go through lessons.

That’s why I’m giving you this 222-page quick reference guide as a bonus.

Excel Power Query training - Bonus reference guide
Power Query Reference Guide

Bonus 2: Power Query – Solutions Book

Excel is a problem-solving tool. Well, the way you solve problems is with good solutions, right?

That’s what this second bonus gives you.

It contains 107 pages of common Excel problems – and good Power Query solutions.

Excel Power Query training - Bonus solutions book
Power Query Solutions Book

You’ll find solutions to problems like:

  • Combining data from multiple workbooks and sheets
  • Creating buckets for your data
  • Finding mismatches in your data
  • Searching and replacing bulk values
  • Unpivoting data with multiple headers

And much more.

Excel Power Query training - Bonus solutions book
Sample Page – Solutions Book

Bonus 3: PRO Excel Power Query Training

Are you already familiar with Power Query? Maybe even an expert at it? This bonus is for you, the Power Query Ninja.

You’re at the point where you’re ready for the advanced techniques. This third bonus will give them to you.

60 days after you enroll in the course, this Pro section will appear inside your account. Inside, you’ll find those advanced techniques.

Such as:

  • How to create a mapping table for column headers when combining files from a folder
  • Tackling complex pivot issues.
  • Add validation reports to make sure business rules are met
  • Dynamically keep and replace column names based on a master table
  • Split columns by multiple delimiters instead of just one

Not to mention the powerful List.Accumulate function. With this function, you can “loop” through a list and adjust the values as you go.

This way, you can achieve tasks that are otherwise not possible or might require a lot of steps.

It’s not an easy function to understand, and there isn’t much documentation online, either. But we’ve got you covered.

You’ll find an entire section on List.Accumulate in your course area.

Armed with these three bonuses plus our main curriculum, you’re all set to make Power Query your best friend.

I am already using what I have learned to pull holiday information from my employer’s website to calculate future business dates.

I tried to do the same thing in the past, but could not get my head around Power Query.

Now with just the first few lessons, Power Query is making a lot of sense, and is already helping me at my job.

Michael Johnson

🆕 Earn CPD Credits

I’m excited to announce this Excel Power Query training is CPD certified. The Continuing Professional Development is a top global accreditation, trusted by companies and industries worldwide.

When you complete this course, you’ll get a special certificate with the official CPD stamp. You will earn 18 CPD hours with the course.

If CPD credits can help in your career, this is not a course to skip.

XelPlus CPD accreditation
XelPlus CPD Provider No 22369

Get Access Now and Master Power Query

Stop being the Excel janitor, always cleaning up messes.

Shrink those file sizes and stop freaking out about “the freeze.”

I’m working in an hospital, and my data is coming mainly from our digital patients record and from our administrative patients records. Prior to this classes, I had to ask our informatic engineer on top of his job, to create the reports I needed.

Leila takes you from the very beginning to the maximum possible of Power Query. Not only does she teach, but the program offers you many add-ons. Imagine, in January I didn’t even know about the words ‘Power Query’!

Philippe Courvoisier, Head of Clinical Quality Office

It doesn’t matter if you’re a beginner, either..

  • You don’t need to be an advanced Excel user
  • You don’t need to understand “M Logic”
  • You don’t need to be working with BIG data
  • You don’t need to invest hours of learning Power Query before reaping the benefits

In fact, I give you this challenge…

Go through just a couple modules. Pick whichever ones jump out at you. Then, test your new skills at work. Give it an honest effort.

I promise your eyes will open to all the hours you’ve been wasting.

If you’re not impressed? We have a 14-day refund policy and will gladly return your enrollment fee.

But I don’t think that will happen, because once you get the hang of Power Query, you’ll never look back. Nobody does.

If you want to enter the Excel fast lane, click the button below and enroll today.

I never explored Power Query or even knew it existed. I became aware of it with the introduction in the Excel Essentials Course.

This course really shows the user a lot of tools to manage and present data with less effort and time than the old way of excel formulas and referencing other workbooks or sheets.

I like that I can reduce the amount of requests to IT regarding report formatting and I can organize the data the way I need it.

Mike Hoffman

At this point, you might be asking, “Do I have the time to go through this Excel Power Query training?”

First, here’s the question you should really be asking yourself: “Do I have the time not to?”

Because if you’re tight on time, Power Query is your answer. Yes, you need to invest the time up front to learn it. But the ROI will show up in less than a month. In many cases, the first week.

But I get it – online courses take time. That’s why we’re rolling out this new time-savings feature to all our courses, including this one.

We call it: The Topic Transporter:

Beam Me Up, Scotty!
Jump into the Topic You Need – Fast

As a Star Trek fan, I was always in awe of the transporter technology.

It blew my mind how Captain Kirk could spot a nearby planet, then instantly transport his team to that exact location.

I want your experience inside our course to be just as instantaneous.

Thanks to a new tool we created here in our XelPlus “laboratory,” now, when you want to find a topic, you can do so instantly.

We’ve gone through every second of every lesson and pulled out the key words & topics. Then, we created an interactive agenda which allows you to quickly locate exactly what you’re looking for.

Once you find your topic, it’s simply a matter of saying “Beam me up!” (not actually required). Click the link and you’ll instantly be transported to the correct lesson and timestamp.

Easily find a specific topic in the course

No more wasting hours searching. Find what you need, then get back to work.

📃 Get a Certificate of Completion

When you finish this Excel Power Query training, you’ll get a certificate of completion. You can send it to your boss, upload to LinkedIn, or just add it to your own person library of learning achievements.

CPD Accredited Course Certificate from XelPlus

I have been a sales data analyst from 1999 to 2005. After I left the company, I moved out of data analysis. Now I find myself heading back into this field, and the data analysis tools have changed significantly!

Leila and her team have crafted a structured, thorough, and professional course on Power Query that will undoubtedly give your career an incredible boost. The course has been excellent and I’m excited to apply these new skills in my work and volunteer activities.

Derek Capitaine, Office Assistant

Your Next Steps?

Click the button below to get started. Excel Power Query will give your career an incredible boost.

The investment for this course is only $179 (excl taxes). What would it be worth to you to have this time-saving Excel skill in your skillset?

You’ll get:

  • Access to our entire 23-module Excel Power Query training (18+ hours of video tutorials)
  • Lifetime access, so you’re never in a rush to complete a lesson
  • The “Beam Me Up Scotty” topic transporter to quickly find what you need
  • 200+ Practice Workbooks (both START and SOLUTION files)
  • A comment section to get your questions answered by our staff (how awesome is that?)
  • Credits for CPD
  • English Captions so you can easily follow along each video
  • Quizzes to track how well you understand the concepts
  • Challenges to acquire your Power Query skills fast
  • Bonus Quick Reference Detailed eBook
  • Bonus Solution Book to quickly find answers to your data analysis challenges
  • Bonus Pro Section covering topics only a few Power Query Pros know

You can be watching the first lesson in less than five minutes.

Hope to see you inside.

Wave “Goodbye” To Manual Work Inside Excel.

Enroll today and make your Excel life faster & easier.

Frequently Asked Questions

When does the Excel Power Query training start and finish?

You’ll take this course in your own time. It is a completely self-paced online course – so you decide when you start and when you finish.

How long do I have access to the course?

How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like – across any and all devices you own.

What if I am unhappy with the course?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us at info@xelplus.com in the first 14 days and we will give you a full refund.

What if I have questions about the lessons? Can I get those answered?

Yes! Most online courses leave you on your own, but not here at XelPlus.

We have a team of helpful teaching assistants (TA’s) ready to answer your questions about each lesson. Below each lesson, you’ll find a comment section where you can ask a question about the topic. Our TA’s will chime in and do their best to help you.

What are the course requirements?

This course is designed for Excel on Windows. Power Query is currently NOT fully available in native Mac.


You’ll need Microsoft Excel 2019 or Microsoft 365. General functionality is also available in Excel 2016, but some Power Query features require newer versions.

Who can I contact if I have questions not addressed?

You can contact us at info@xelplus.com.

Leila consistently provides great education and training value in her courses. They are thorough and extensive. Leila uncovers key points that I overlooked. I gain useful information and examples that further my understanding. The documentation is thorough and easy to follow and helps me find answers when I get stuck. I look forward to her next course.

Rusch Mauzy, Chief Administrative Officer

Get started now!


Save with a Bundle!

You’d like to improve in more than one aspect? Pick a package now. Learn anytime that suits your schedule.

Power Query Course

Master Excel Power Query – Beginner to Pro

$199 excl. VAT

Start using Excel in the Power Mode. Just by finishing the FIRST hour, you’ll be amazed at what you can achieve with Power Query. It will give you tons of ideas on how to make your work easier.

Power Excel Bundle course cover

POWER Excel Bundle

$299
$398
Save $99 with a bundle!

Getting data into Excel and preparing it for analysis becomes easy once you discover the power side of Excel. This Power Bundle includes two top selling courses so you can become unstoppable in Excel (Plus what you learn applies to Power BI as well).

Courses included

This means you get

  • Over 32 hours of video content (CPD Credits)
  • Certificate of Completion for individual courses
  • 100+ Workbooks and Templates
  • 40+ Challenges & Quizzes to test your skills
  • LIFETIME Access so you never feel rushed
  • Comment sections to ask questions and get answers from our friendly teaching assistants
Excel Black Belt course cover

Black Belt Excel Package

$679
$1,131
Save $452 with a bundle!

Our Black Belt Package is your gateway to becoming an Excel Grand Master. With this package you get exclusive access to courses not available as stand-alone. Our step-by-step guidance makes learning easy, so you can say goodbye to confusion and frustration and hello to mastery.

Courses included

This means you get

  • Over 100 hours of video content (CPD Credits)
  • Certificate of Completion for individual courses
  • 600+ Workbooks and Templates
  • 200+ Challenges & Quizzes to test your skills
  • LIFETIME Access so you never feel rushed
  • Comment sections to ask questions and get answers from our friendly teaching assistants