How-To Geek on MSN

Forget XLOOKUP: Why FILTER is better for extracting Excel data

The FILTER function extracts every matching record while XLOOKUP only returns the first result.

Put Excel into Easy Mode by Implementing First Normal Form (1NF)

Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.
How-To Geek on MSN

How to use formula by example in Excel to generate complex formulas

I traded the static results of Flash Fill for dynamic formulas that update automatically.

15 Modern Excel Functions Worth Knowing in 2026 That Outclass Clunky Workflows

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...

This NotebookLM feature saved me hours — and it's way easier than any spreadsheet I've ever made

It cut hours out of my research workflow ...