Free Guide!
The ONE Critical Excel Skill You Need
This free Excel guide will help you to:
- Pinpoint the Excel skill you should work on now
- Understand how this skill can help you
- Find the optimal learning path to master this skill
Search Results
Search XelPlus
89 results for: power query
Keep the Latest Record in Power Query (Why Remove Duplicates Keeps the Wrong One)
Sort, remove duplicates, done? On large data, Power Query can quietly keep the wrong record and never warn you. Here’s why it happens and the one-line fix. Free workbook included.
Power Query Challenge Pack
You learned Power Query. Still get stuck?
Time for real practice.
Download Your Power Query Practice Toolkit
Stop wasting hours on manual cleanup. Master Power Query with this step-by-step tutorial. Download free practice files and automate your data today!
Master Excel Power Query – Beginner to Pro (Limited Offer)
With Power Query, you can quickly turn messy data into smart decisions – fast! Automate repetitive tasks and create reports in a fraction of the time.
You WON’T BELIEVE These 10 HIDDEN Features in Excel Power Query
Learn 10 of the most productivity increasing “hidden” features of Power Query to take your skills to the next level.
Automate Excel: Power Query & Power Automate Recipes
Work through real automation problems one at a time. SharePoint files, PDFs, approval emails. See how each one gets solved, so you can build systems that keep running without you.
Master Excel Power Query – Beginner to Pro
Power Query is the most underused tool in Excel. Build the monthly cleanup once, then just refresh. One member took a monthly report from 7 days down to 2 hours.
How to Repeat Table Values x Times Using Power Query
With this trick you can easily combine and repeat blocks of values together in Excel. You don’t need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.
How to Import Emails from Outlook to Excel with Power Query
Learn how to easily export your Outlook emails into Excel. No VBA or Add-ins are necessary. I’ll show you how to create a connection to any Outlook folder (or your full inbox) so you can easily import Outlook data to Excel.
How to Work with Time in Excel Power Query
Working with time in Excel – for example calculating hours worked or summing or subtracting time can get tricky with Excel formulas. Let me show you how Power Query can easily do these for you.
Create Excel Filled Map Charts with Power Query
Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.
Excel Power Query – What Is It and Why Should You Use It
What can Excel Power Query do for you? It can help you in more ways than you think. Not only can you import big data from different locations, but you can also replace complex formulas with a few clicks.