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

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

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

Dark Mode has its drawbacks. For example, the worksheet grid usually remains white. You can choose Black under Office Theme, which activates a Dark Mode toggle in the View tab of your Excel ribbon.

If Excel is not using threads efficiently, calculations may take a long time to complete. Learn how to speed up calculating threads in Excel.

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Samantha (Sam) Silberstein, CFP®, CSLP®, EA, ...

Julia Kagan is a financial/consumer journalist and former senior editor, personal finance, of Investopedia. Thomas J. Brock is a CFA and CPA with more than 20 years of experience in various areas ...