How-To Geek on MSN

Forget INDIRECT: The modern way to create cascading drop-down lists in Excel

Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.
How-To Geek on MSN

How to use the LAMBDA helper functions in Microsoft Excel

Replace legacy formulas with MAP, BYROW, BYCOL, SCAN, and REDUCE to build secure, scalable, and automated spreadsheets.

Excel Tables: Structured References Work Better by Name

Excel table formulas shift from cell positions to named columns with #All-style tags, keeping calculations readable when layouts change.

Top 10 Most Powerful Microsoft Excel Functions for Data Analysts

Microsoft Excel includes quick stats via Analysis ToolPak; mean, median, and standard deviation are generated for selected ...
Computerworld

Microsoft cheat sheets: Dive into Windows and Office apps

These guides will help you find your way around several generations of Microsoft’s Office apps for Windows — and Windows itself. Need to get up to speed on the latest features in Excel? Wrestling with ...