Pivot Tables are one of the most powerful tools in Excel. They allow you to easily take a large amount of data and summarize or analyze that data in mere moments.

If you don't know how to use Pivot Tables yet, you need to learn them.

This guide will walk you through them step-by-step in an easy, clear, straight-forward manner.

The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, and 50 Useful Excel Functions. In that series, pivot tables are covered in Intermediate Excel.