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

When I learned how to use tables in Microsoft Excel, it totally transformed how I work with data. Even if you think you already know everything there is to know about Excel tables, hopefully, you'll ...

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

Brian Beers is a digital editor, writer, Emmy-nominated producer, and content expert with 15+ years of experience writing about corporate finance & accounting, fundamental analysis, and investing.