Avoid PivotTable failures caused by merged cells, blank columns, and subtotals, with Power Query steps to clean the source data.

Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern 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, ...

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. CAGR measures an investment's average annual growth ...