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?