Create Excel Pivot Tables

A pivot table is a great tool that for sorting and summarizing the data in a spreadsheet or database file.

It can automatically sort, count, and total spreadsheet data and then create a second table to display the summarized data.

Once you have finished looking at the summarized data, you can quickly re-sort your data and look at it from a totally different perspective, and all of this can be done without using functions or formulas.

Despite being so useful, many people shy away from using them, on the belief that they are hard to use. They aren’t really, and once you get the hang of them, you’ll use them at every opportunity.

To find out more about this handy tool, watch the video on how to Create Excel Pivot Tables.

Related Articles

• Creating a Database File in Excel
• Excel VLOOKUP
• Excel HLOOKUP