But this is not true! Microsoft has been refining the technology for many years, and in the modern versions of Excel, the summary reports are user-friendly are incredibly fast. Many people think that creating a Pivot Table is burdensome and time-consuming. And the steps below show how you can quickly create your own Pivot Table in all versions of Excel. The screenshots above demonstrate just a few of many possible layouts.

In just a few mouse clicks, you can get a resilient and easily customizable summary table that totals the numbers by any field you want.

However, if you want to compare several facts about each figure, using a Pivot Table is a far more efficient way. One possible way to sum this long list of numbers by one or several conditions is to use formulas as demonstrated in SUMIF and SUMIFS tutorials. Present concise and attractive online of your data or printed reports.įor example, you may have hundreds of entries in your worksheet with sales figures of local resellers:.Expand or collapse the levels of data and drill down to see the details behind any total.Subtotal and aggregate numeric data in the spreadsheet.

Rotate rows to columns or columns to rows (which is called 'pivoting') to view different summaries of the source data.Filter, group, sort and conditionally format different subsets of data so that you can focus on the most relevant information.Summarize data by categories and subcategories.Present large amounts of data in a user-friendly way.An Excel Pivot Table is a tool to explore and summarize large amounts of data, analyze related totals and present summary reports designed to:

Excel 2013 pivot table cheat sheet