Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Here, we show you how to create a pivot table in Excel to take advantage of one of the application’s most powerful tools. Before we start, just what exactly are pivot tables good for?