Microsoft Excel pivot tables are a great way to reduce large amounts of data into an easily readable format. Using a drag-and-drop interface, you can combine columns from your spreadsheet into a "data view" that will automatically compile the data for you. Pivot tables are great for taking large amounts of data and creating an easy-to-read summary report.
Creating Microsoft Excel Pivot Tables
Although pivot tables seem complex, the process for creating them is straightforward: Select a data set and choose the data items you wish to display. The data items can be described as dimensions, and a successful pivot table needs at least two dimensions. For example, say you want to find out how many of your customers have the same ZIP Code. This requires two dimensions of information: customers and ZIP codes. To create a Microsoft Excel pivot table, follow these steps:
Spreadsheet software, a useful tool for financial and other types of calculations, is offered by a number of different software manufacturers, both as a part of application "suites" and as stand-alone programs.