So, select any cell in your formatted Excel table, and in the Insert Tab on the ribbon, click the top half of the split ...

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

The figures are formatted in USD by default, but it’s easy to switch. Just select the cells (hold the Ctrl key to grab multiple at once) and expand the Number group on the Home tab. From there, choose ...