YouTube Subscriber Special Offer
You downloaded the practice files.
Now get the complete Power Query training at special one-time pricing.
$299
Regular price
$179
Save $120
Plus Get Quick Wins with ChatGPT Course FREE ($99 value)
Use AI to write M code and troubleshoot Power Query faster.
Discount automatically applied. Price excludes local tax.
One payment. Lifetime access.
Save Hours Every Week with Power Query
Students save 10+ hours monthly on recurring tasks.
Some cut reports from 7 days to 2 hours with this Power Query course.
Stop Rebuilding the Same Excel Reports Over & Over
There’s a feature in Excel that can eliminate most of your manual work.
- No more copying and pasting between files.
- No more fixing messy data row by row.
- No more rebuilding the same reports every month.
It’s called Power Query, and it’s already sitting in your Excel right now.
You might be like: “If it’s that good, why doesn’t everyone use it?”
Simple: most people don’t know it exists, and the few who do think it’s only for data experts.
It’s not.
It’s actually easier than most Excel formulas.
Trusted by data professionals at:
This course helped me reduce my time updating my monthly report from 7 days to 2 hours.
After taking this course, I can set up a report template for a year in one day and click refresh for each of the 11 months after that, and the report will be automatically updated in 15 minutes.
I am now the only “spreadsheet expert” in my division.
The Excel Reality Check
With Power Query,
You’ll…
Turn 3-day reports into 15-minute tasks
Combine files from multiple sources in seconds
Build report templates once and reuse them forever
Click “Refresh” and watch messy data clean itself automatically
Become the go-to Excel expert everyone relies on
Without Power Query,
You’re Stuck…
Spending hours cleaning the same messy data over and over
Manually copying and pasting data between files every month
Rebuilding reports from scratch each time you get new data
Writing complex formulas that break when data changes
Being the office Excel janitor instead of the Excel hero
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.
— Amrita O’Sullivan, Business Intelligence Developer
I’ve cut down the time to generate my monthly reports from 3-4 days to 2-3 hours. That’s an order of magnitude, I’d say. Improvement is exponential.
— Gustavo Jaramillo, Senior Economic Analyst
Works for Everyone
From Complete Beginners to Excel Experts
Never Used Power Query Before?
Of all of the Power Query tutorials I watched, Leila’s was the easiest to understand and friendly for first-time users like me.
I started the course barely knowing anything about it, but completed the course being able to understand the M language behind it. I can read the M scripts and modify them, and I have no background in programming at all!
Already an Excel Expert?
After programming for over 40 years, I was a bit cautious about how useful Excel Power Query could really be. But it turned out to be so much more than I ever anticipated!
If you’re truly dedicated to mastering Excel and boosting your business skills, this course is just the right fit for you.
This Course is Actually 4 Training Programs in One
Most Power Query courses teach basics. This takes you from manual work to true expertise.
Course 1
Power Query Essentials
Stop wasting time on manual Excel work
- Master data import, cleaning, and basic automation
- Turn repetitive tasks into one-click solutions
(Value: $199)
Course 2
Advanced Power Query
Handle complex data like a consultant
- Combine multiple sources and create professional reports
- Build dashboards that update automatically
(Value: $249)
Course 3
Power Query Mastery
Solve problems others can’t
- Pro-level troubleshooting for complex scenarios
- Master Power Query’s most powerful function
(Value: $229)
Extra Projects
3 Real-World Projects
Apply skills to actual business scenarios
- HR Data Analysis Report
- Executive Dashboard Creation (mimics a real-business project)
- Power BI Integration Project
(Value: $179)
Total Course Value: $856
Regular Price: $299
Your Investment: $179
Plus Get Quick Wins with ChatGPT Course FREE ($99 value)
Local tax will apply
Plus These Bonus Resources
01 🎁
Power Query Reference Book
(222 pages – Value: $79)
02 🎁
Power Query Solutions Book
(107 pages – Value: $47)
Worth every penny; it is a truly practical course where, from lesson one, you could apply the knowledge to the job. I have already created:
1) a financial reporting tool from Trial Balance to full Financial Statements, MD&A, Tax Working papers, and monthly reporting;
2) Sales Commission Model that includes several levels and manual inputs;
3) many, many day-to-date queries to extract data.
Sometimes I just need to refresh; it’s so easy that months pass and then I realize how much work was saved.
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.
Today, these students and thousands more are saving hours each day thanks to Power Query.
This course was excellent. I ended up applying the skills I learned from the beginning of the course directly into my work immediately.
After finishing this course, I’ve been able to take the manual spreadsheet work that I previously had and synthesize dynamic Power Query solutions for it. I wouldn’t have even thought this was possible before.
This course has saved me many late nights during my team’s monthly accounting close periods. Where I would spend long hours juggling spreadsheets, I am now able to complete the work in dramatically less time.
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.
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.
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.
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?
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!
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?
Master Excel Power Query – Beginner to Pro (Limited Offer)
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
Section 1: Introduction
Section 2: Power Query Essentials
Section 3: The Power of Power Query
Section 4: Important Power Query Tips & Tricks
Section 5: Helpful Power Query Transformations
Section 6: Powerful Power Query Transformations
Section 7: Date & Time Transformations
Section 8: Custom Column & Basic M Manipulation
Section 9: Power Query Data Sources (Online)
Section 10: Combining / Appending Data
Section 11: PROJECT – Report on HR Data
Section 12: All Merge Options – Join Kind Options Explained
Section 13: When to Use Power Pivot & Load to Data Model
Section 14: Power Query Advanced to Pro
Section 15: Solving Complex Data Analysis Problems with Merge
Section 16: Advanced Problem Solving using the Power Query Interface
Section 17: PROJECT – Create a Modern Excel Dashboard with Power Query & Pivot Tables
Section 18: Understanding M Formula Language (Let, Lists, Records & Improving Performance)
Section 19: Working With List & Table Functions
Section 20: Creating & Invoking Custom Functions
Section 21: Flexible Importing of Data with the Help of M Functions
Section 22: PROJECT – Power Query and Power BI
Section 23: Final Words
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.
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.
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.
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.
🆕 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.
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.”
Power Query Course: $299
Your Investment: $179
Plus Get Quick Wins with ChatGPT Course FREE ($99 value)
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’!
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.
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.
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.
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.
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.
Your Next Steps?
You downloaded the practice files from YouTube. You’ve seen what’s possible. Now get the complete training at special YouTube subscriber investment pricing.
Power Query Course: $299
Your Investment: $179
Plus Get Quick Wins with ChatGPT Course FREE ($99 value)
This one-time offer expires when the timer runs out and cannot be accessed again.
You’ll get:
- Access to our entire 25-module Excel Power Query training (18+ hours of video tutorials)
- Quick Wins with ChatGPT Course FREE ($99 value)
- 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
You can be watching the first lesson in less than five minutes.
This offer expires when the timer runs out. After that, you’ll pay regular member pricing ($299). This pricing cannot be extended or accessed again.
❓Frequently Asked Questions
Why is this price lower than your regular pricing?
This is YouTube subscriber investment pricing. You found us on YouTube, downloaded the practice files, and took action. This one-time pricing is only available for your first purchase from XelPlus and expires when the timer runs out.
After that, you’ll see regular member pricing ($299). This pricing cannot be extended or accessed again. Future courses will be at full member pricing.
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.