www.xelplus.com Open in urlscan Pro
35.244.153.44  Public Scan

Form analysis
1 forms found in the DOM

GET https://www.xelplus.com/

<form class="flex items-center border border-gray-300 rounded-full overflow-hidden" role="search" method="get" action="https://www.xelplus.com/"> <span
    class="icon icon-regular icon-magnifying-glass flex flex-none justify-center items-center bg-gray-50 border-r-gray-300 border-r w-12 h-12 text-gray-600"> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512">
      <path
        d="M504.1 471l-134-134C399.1 301.5 415.1 256.8 415.1 208c0-114.9-93.13-208-208-208S-.0002 93.13-.0002 208S93.12 416 207.1 416c48.79 0 93.55-16.91 129-45.04l134 134C475.7 509.7 481.9 512 488 512s12.28-2.344 16.97-7.031C514.3 495.6 514.3 480.4 504.1 471zM48 208c0-88.22 71.78-160 160-160s160 71.78 160 160s-71.78 160-160 160S48 296.2 48 208z">
      </path>
    </svg></span> <input type="search" class="bg-transparent px-4 py-0 h-12 border-none rounded-none shadow-none ring-0 focus:ring-0 text-lg placeholder-gray-500" placeholder="Search this site..."></form>

Text Content

We value your privacy

We use cookies to enhance your browsing experience, serve personalized ads or
content, and analyze our traffic. By clicking "Accept All", you consent to our
use of cookies.

Customize Reject All Accept All
Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions.
You will find detailed information about all cookies under each consent category
below.

The cookies that are categorized as "Necessary" are stored on your browser as
they are essential for enabling the basic functionalities of the site.... Show
more

NecessaryAlways Active

Necessary cookies are required to enable the basic features of this site, such
as providing secure log-in or adjusting your consent preferences. These cookies
do not store any personally identifiable data.

No cookies to display.

Functional

Functional cookies help perform certain functionalities like sharing the content
of the website on social media platforms, collecting feedback, and other
third-party features.

No cookies to display.

Analytics

Analytical cookies are used to understand how visitors interact with the
website. These cookies help provide information on metrics such as the number of
visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance

Performance cookies are used to understand and analyze the key performance
indexes of the website which helps in delivering a better user experience for
the visitors.

No cookies to display.

Advertisement

Advertisement cookies are used to provide visitors with customized
advertisements based on the pages you visited previously and to analyze the
effectiveness of the ad campaigns.

No cookies to display.

Reject All Save My Preferences Accept All
Powered by
 * Courses
   Automate With Power Query – Recipes to solve business data challenges
   Fast Track to Power BI
   Excel Essentials for the Real World
   View all Courses
 * For Business
 * Tutorials
   
   EXCEL
   
    * Power Excel
    * Formulas
    * Dashboards, Charts & Features
    * VBA & Scripts
   
   POWER BI
   
   POWER AUTOMATE
   
    * Cloud
    * Desktop
   
   ACCOUNTING & FINANCE
   
   POWERPOINT
   
   OUTLOOK
   
   GOOGLE SHEETS
   
   OTHER APPS

 * Resources
 * About

Login


Automate with Power Query – NEW COURSE IS NOW AVAILABLE. Get Recipes to Solve
Business Data Challenges GET ACCESS

Close Modal


AUTOMATE WITH POWER QUERY 🦾
RECIPES TO SOLVE BUSINESS DATA CHALLENGES

LOG IN
GET THE COURSE


--------------------------------------------------------------------------------




BECOME MORE CONFIDENT & CREATE RELIABLE SOLUTIONS

You’ve gone down the Power Query rabbit hole and finally setup a query that
worked… only to see it fail a few weeks later.

No more wasting time coming up with solutions.

This course gives you the practice you need to become more confident so you can
solve any new data challenges in a fraction of the time it used to take you.

You’ll also discover new automation options so you can automate an entire work
flow – not just a part of it.


GET ACCESS TODAY
Watch Video

Learn Power Query recipes to solve business challenges



Includes Ready to use Automation Recipes & Resource Guides



--------------------------------------------------------------------------------




WHAT YOU’LL ACHIEVE

Solution recipes you can apply to your own work

Learn automation techniques to solve problems with less effort

Discover new automation tools like Power Automate & Office Scripts

Make your working life easier and more enjoyable


OUR COURSES ARE POPULAR AMONG THESE COMPANIES



--------------------------------------------------------------------------------


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 have crafted a structured, thorough, and professional course
on Power Query that will undoubtedly give your career an incredible boost.




THE SECRET SAUCE FOR DATA ANALYSIS



Does This Sound Familiar?

 * You’ve started using Power Query at work, but you don’t feel confident
   enough.
 * You know the end result you want, but don’t know what the best approach is to
   get there. After all, each problem is different.
 * Maybe you have PDF files that go over multiple pages, and you just can’t find
   the right approach to bringing over the information properly into Excel.
 * Maybe you need to Unpivot or Pivot – but you’re not really sure how to use
   these properly.
 * Maybe you have a complex Lookup problem and you’re not sure if you need Power
   Query or formulas?
 * You’ve noticed other automation tools like Power Automate and Office Scripts
   and wondered if you can add these to your workflow. Maybe trigger a
   notification when a file becomes ready or split a file and create PDF
   versions, or take automatic backups of your files (couldn’t that come in
   handy?).

If you’ve experienced any of this then you are in the right place.

By going through this program, you’ll expand your toolkit so you can solve new
data challenges in a fraction of the time it used to take you. Plus you’ll
discover new automation options you hadn’t thought of before.




THIS COURSE IS BASED ON REAL-WORLD BUSINESS CHALLENGES

Data in the real world is messy.

Each lecture in this course is the result of a question our corporate members
had. We met with them, interviewed them, we created a list of their struggles,
collected tons of files and created this program.

That’s why we don’t waste time on examples with 3 rows of data. We focus on
actual challenges our clients struggled with at their work. In the course there
is a section called “real-world data transformation challenges solved.” In that
section you’ll discover the secret sauce to these common challenges. I call it
the Rubik’s-cube approach. And as our students will tell you, it’s pretty cool
to see your data projects fall together at the last second.

More than Power Query…

As you know, here at XelPlus, one of our core pillars is teaching the big
picture.

We want you to be able to combine different power tools together to automate an
entire process.

Power Query is just ONE automation tool.

It’s a great one but there are others you might be missing out on just because
you don’t know of them, or you haven’t dared explore them.

This course will shine a light on the other tools as well. You’ll get to
automate what comes before and after Power Query.

This will help you become creative which is one of the keys to success in this
fast-paced world.

Because Here’s The Thing…

Staying on top of the curve does not happen by accident. Nor is it about working
“harder” or “hustling more.”

The secret to overcoming today’s data challenges is knowing about other
automation options that are available to you.

So, next time you’re sitting in a business meeting talking about automation
you’ll be able to confidently discuss different possibilities.

Get my point?


“BUT LEILA, I DON’T HAVE TIME TO LEARN ALL THESE TOOLS”



Sure, I understand. I know you’re busy.

Instead of boring you with the theory of all these automation tools, I’ll give
you my unique Solution Recipes that you can apply right away: Let’s say you come
across a similar case that we cover at your work. You don’t have to go and watch
the entire video again. You just scroll down and grab the recipe right from
underneath the video.

You’ll love how much time these recipes will save you. Trust me, once you
automate the entire process, Power Query becomes far less of a time-drain.

Before you know it, you’ll find yourself looking forward to new assignments
instead of dreading them.




GET PRACTICE USING POWER QUERY ACROSS DOZENS OF REAL-WORLD EXAMPLES

Plus learn about the pitfalls to avoid.

Get Access for $99



WHAT TOP DOCTORS CAN TEACH YOU ABOUT
POWER QUERY…

What does it take for a doctor to become the best in their field?

Intelligence? That’s for sure.

A good work ethic? Definitely.

And also tons and tons of practice.

The top surgeons are ready for any scenario because they’ve seen it all.

And it’s the same thing regarding you and using Power Query. You’ll only master
Power Query once you’ve practiced many different scenarios.

Then, you’ll be ready for anything

❌ No more dreading new assignments.

❌ No more receiving a data dump that’s a total mess and spending hours trying to
clean it.

Instead, we’ll show you how to make quick work of anything.

Just like a doctor needs many cases to improve their skills, so do you.



Inside this new course, you’ll practice all sorts of Power Query scenarios,
ranging from easy to challenging. Then, you’ll get a “recipe” for efficiently
handling each scenario.

That way, when a new assignment hits your desk, you deploy one of these recipes.
Easy peasy.

Don’t wait until the most important project of your life hits your desk with a
24-hour turnaround.

Prepare for those emergencies. Learn these Power Query recipes and be ready.


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.

Feedback on our Power Query: Beginner to Pro Course



Get Access Today for $99



I AVOIDED 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 Power Query to
our XelPlus audience. That’s when I started working on our online course.

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 DETAILED CURRICULUM

This course is designed for busy professionals. You don’t need to go through it
lecture by lecture. We’ve made it easy for you to step in, grab what you need
and deploy it at your work.

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




AUTOMATE WITH POWER QUERY – RECIPES TO SOLVE BUSINESS DATA CHALLENGES

Power Query is an Essential tool for Data Analysis. In this course we’ll provide
recipes to solve real-life business data challenges.

Get Access


This Course includes:

Over 6 hours of video and written guides

Downloadable Workbooks and Templates

Challenges 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 (will be available by August 2023)

English Closed Captions

INTRODUCTION



Welcome & How to Get the Most Out of This Course

⚙️ How to Use the Platform for Best Learning Experience

🔍 Looking for a Specific Topic? Use the Transporter!

❗Important Power Query Editor Settings & Other Useful Info

One-Click Method to Change Source for Multiple Queries

MODULE 1: PDF TO EXCEL – CORRECTLY EXTRACT PDF DATA



Combine Multiple PDF Pages into One Table (Dynamic vs Static Approach)

Discover Powerful Features to Clean Messy PDF Data (Table of Contents)

Find and Extract Tables From PDFs No Matter Where They Are

Bulk Import Multiple PDF Files From Folder (The Method)

Bulk Combine PDFs and Extract Values From Different Locations

Bulk Combine PDF Payslips & Create a Dashboard (Messy PDFs)


MODULE 2: CREATE PIVOT TABLE FROM MULTIPLE SOURCES



Import Sheets Between Two Tabs: 3-D Reference Power Query

Create a Pivot Table From Multiple Tables in the Current File

Appending Vs Merging Vs Relationships – When to Use Which When Combining Data

How to Use Results of Pivot Tables in Reports (GETPIVOTDATA vs Direct Reference)

Professional Pivot Tables (Formatting Tips to Take Your Pivot Tables to Another
Level)

Split Pivot Tables to Multiple Categories (ONE Click Solution)


MODULE 3: ORGANIZING AND MANAGING POWER QUERY FILES



File & Folder Organization – Best Practice Guide

Important Refresh Settings in Excel (Automatic Refresh)

Add Last Refreshed Date & Time to Your Report

Copy Power Queries from one File to Another

Best Practice for Naming Steps When Working in Different Languages


MODULE 4: MANAGING SOURCE – ONLINE FILES (SHAREPOINT, ONEDRIVE, DROPBOX)



Connect to Local SharePoint Files the Right Way (Avoid Changing Source)

SharePoint / OneDrive Password Changed? Easily Re-authenticate

Connect to Files on Dropbox (The Proper Way)

📂 SharePoint Folder Connection Made Easy with These Tricks

🕒 Latest File as Source – Name Doesn’t Matter


MODULE 5: REAL WORLD DATA TRANSFORMATION CHALLENGES SOLVED



Power of UnPivot & Pivot – Learn the Basics for Success

Multi-Column Lookup (Amazon Barcodes) – UnPivot vs Formula Solution

Data Reconciliation – How to Compare Two Tables and Find Differences

Get the Latest File and Unpivot a Monthly Cash Flow Statement

Convert Multi-Line, Single Column File into Table (Pivot Data)

Keeping Leading Zeros Extracts from SAP, Oracle etc.


MODULE 6: DATA QUALITY MANAGEMENT CHALLENGES



Adding Comments to Results & Keeping Rows in the Right Order (Self-Referencing
Query)

How to Audit and Locate Excel Formula Errors with Power Query

Creating Master Data from One Large Fact Table with Power Query


MODULE 7: COMMON PITFALLS TO AVOID



When Power Query Goes Wrong – Pitfalls, Bugs, Errors and What’s Causing Them

Combine Tables, Expand Columns Pitfall & How Not to Hardcode Headers

Case Sensitivity & How to Ignore Letter Case

Filter Pitfall & How to Avoid Missing Data

Removing, Reordering, Renaming Columns Pitfall & How to Ignore Missing Headers

Changed Type Pitfall & Automatic Type Detection – On or Off?

Other Common Power Query Errors & How to Fix These


**** POWER QUERY & BEYOND: INTRODUCING OTHER AUTOMATION OPTIONS ****



🤖 Excel Automation Options 📚Relevant Resources


MODULE 8: MANAGING SOURCE AUTOMATIONS



Get a Teams Message when a New Source File is Added to Folder (Power Automate)

Automatically Copy Files from One SharePoint Folder to Another (Power Automate)

Automatically UnZip Files on SharePoint (Power Automate)


MODULE 9: BACKUPS AUTOMATION



Automatically Create Query-Free Backups (VBA)

Schedule Backup of Files with Power Automate


MODULE 10: AUTOMATIONS TO FORMAT & DISTRIBUTE FILES



Recording Actions with Office Scripts (OS)

Looping & Formatting Sheets with Office Scripts (OS)

Running Office Scripts with Power Automate (Schedule or Event Trigger)

Auto Convert Files to PDF (PA)

Automatically Save Each Sheet as a Separate File (VBA)

Automatically Send Emails With Attachments to People Based on Condition (PA)


COURSE WRAP-UP



Favorite Power Query Pro Tips

Final Words

Hide full outlineSee a full outline


Get Access Today for $99



🆕 EARN CPD CREDITS



I’m excited to announce this course will be 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.

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

(CPD credits will be available by August 2023)

XelPlus CPD Provider No 22369




TOPIC TRANSPORTER
JUMP INTO THE TOPIC YOU NEED – FAST

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 the course, 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.


Certificate from XelPlus




❓FREQUENTLY ASKED QUESTIONS




DO I NEED TO KNOW POWER QUERY?


This course assumes you know what Power Query is. You don’t need to have
advanced knowledge. It’s ok if you’re still learning and have recently started
using it at work. You just need to be familiar with the interface. If you’re
not, I recommend you start with this course. Complete the introduction sections
and then you’ll be ready to jump in this course. It will expose you to
real-world problems.


WHAT IF I’M ALREADY ENROLLED IN MASTER POWER QUERY: BEGINNER TO PRO COURSE? WILL
I LEARN ANYTHING NEW?


Yes. This course is the result of the most common questions we received from our
members who were enrolled in the other course. We decided to create a separate
course to address these issues as they were many. You don’t need to have
completed the other course to start with this one. It’s enough if you’ve gone
through the introduction sections.


WHEN DOES THE COURSE 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 30 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!


Get Access for $99


© 2023 XelPlus.com. All Rights Reserved

Privacy Policy
/
Impressum
Email LinkedIn YouTube Instagram