Simplify data analysis with Excel PivotTables. Learn how to replace formulas, uncover trends, and create dynamic reports in minutes.

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...