Dynamic arrays are a game changer in Excel. Functions like SORT, FILTER, SEQUENCE, and UNIQUE now automatically “spill” results into multiple cells. This means no more copying formulas down manually!
We show how to use them to generate live, auto-updating lists, clean up duplicates, and even build dynamic dashboards. Once you understand the concept of the “spill range,” you’ll wonder how you ever lived without it.
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
