Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.

The introduction of dynamic arrays triggered the biggest change to how we work with Microsoft Excel formulas in years, if not decades. They allow a single formula to spill multiple results into ...

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

Excel automations cover auto-updating charts, deadline flags, and smart links; Ctrl+T table charts expand as new rows appear.

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 ...