Excel 365 users have access to powerful new functions—and XLOOKUP is at the top of the list. It simplifies lookups, supports exact matches by default, and replaces the need for VLOOKUP, HLOOKUP, and even INDEX/MATCH in most cases. In this post, we explore real-world scenarios where XLOOKUP shines and makes your formulas cleaner and more robust.
If you haven’t yet upgraded your formulas, now’s the time.
If you’re still using SUM and IF separately to crunch numbers in Excel, it’s time to level up. SUMIFS is one of Excel’s most powerful functions for analysing data — and it’s surprisingly eas...
Read More
Excel dashboards can be incredibly powerful — but let’s face it, not everyone is a designer. The good news? You don’t need a design degree to create dashboards that look clean, work beautifully,...
Read More
Power Query is one of Excel’s best-kept secrets — and if you’re not using it yet, you’re probably spending too much time cleaning, reshaping, or merging data manually.
Whether you're a beginn...
Read More
When it comes to working efficiently in Excel, keyboard shortcuts aren’t just time-savers — they’re game-changers.
As a trainer, I use dozens of shortcuts, but there are three that I rely on ev...
Read More
If you’ve been using Excel for years, you’ve probably tangled with VLOOKUP, wrestled with HLOOKUP, and maybe even constructed the occasional INDEX/MATCH combo when things got serious. But now, Mic...
Read More
