Many people give up on using Pivot Tables far too early and it is worth investing time in practicing how to insert a Pivot Table.ġ. Working with Pivot Tables may appear daunting when you start as it takes a little while to adjust to the different functions and analysis tools. To carry out the functions which are built into Pivot Tables, will require several regular Excel worksheets and multiple formulas, to recreate. In essence, Pivot Tables turn your static data into dynamic data that can be manipulated to provide an analysis of information from every possible angle. In the screenshot below, by changing one setting, the report is now displaying values for each product as percentages of the total sales of all products: The greatest benefit of using Pivot Tables is that you can quickly change how data is analyzed and what information is displayed.

On the left-hand side of the image, the PivotTable Field List contains the tools that can be used to manipulate which data is analyzed and how it is displayed. The data area is the data that has been organized into a table. Study the screenshot below for an image of a Pivot Table: In Excel, the Pivot Table function has numerous add-on options for quickly creating data sets and reports with literally numerous variations. Pivot tables are highly manipulatable and quick to create. Test your Excel skills with the corresponding FREE Online Multiple ChoiceĪ Pivot Table is a fancy name for a data analysis tool that allows you to create a summary or report based on an information source. Free Excel Tutorial – Pivot Tables – Excel 2010 Pivot Tables Excel Tutorialįree Online Microsoft Excel Tutorial * What is a Pivot Table?īy moving the data Pivot Tables let you organize, analyze and summarize large amounts of data in lots of different ways.

Excel 2010 pivot charts tutorial