Creating a Pivot Table in Excel To best understand pivot tables, you need to work with them yourself. While pivot tables were created to summarize large groups of data, they can be used with ...

Step 1: Prepare your data. Perhaps the most important step in using Excel pivot tables is to carefully organize your data. The easiest way to do this is to use Excel tables, which let you add rows ...