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
How to Find Hardcoded Numbers in Excel Formulas
Go To Special won’t find numbers hidden inside formulas. Use FORMULATEXT with REGEXTEST and conditional formatting to highlight them.
AI Prompts for Excel Data Analysis: How to Get Results You Can Trust
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.
Introduction to Pivot Tables
Python in Excel Foundations
Python in Excel Foundations – Special Offer
Thank You – PQ Challenge Pack
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.
3 Python in Excel Tricks That Save Hours of Manual Work
Messy dates, data stuck in the wrong columns, and analysis that eats your afternoon. Three Python in Excel tricks that fix each in about 30 seconds. Free workbook included.
Email Excel Sheets as PDF Automatically with Office Scripts
Learn how to use Office Scripts to convert Excel sheets to PDF and send them by email automatically. No VBA, no Power Automate. Works in Excel Online and desktop. Free workbook included.
TRIMRANGE in Excel: How to Remove Blank Cells from Spilled Ranges
Stop spilled formulas from showing zeros and blank cells. Learn the new TRIMRANGE function and the dot shortcut that clean up your ranges automatically.
Thank You – Intro to Pivot Tables Special Offer