Free online excel 2007 tutorial
In the screenshot below, these contextual tabs are displayed and circled in yellow:Įxperiment with clicking in the Pivot Table area and away and take note of the options that appear and disappear when you do this.
The Pivot Table contextual tab containing Pivot Table Tools for Design and Options, will also only be available when the Pivot Table area is selected.
If you click away from the Pivot Table area, you will note the PivotTable Field list and other Pivot Table options, disappear. To access the PivotTable Options and Field list, you need to click in the Pivot Table area. Although this sounds intimidating, hang in there, these are really just dragging and dropping your column and row labels into specific areas of the PivotTable Field List.īefore any labels are selected, your Pivot Table worksheet display will be similar to the screenshot below:ĭepending on the data contained in the worksheet on which you are basing the Pivot Table, these labels will appear in the PivotTable Field list. The Pivot Area will be blank until data labels for columns, rows and filters are selected. The Pivot Table will be inserted on a new worksheet (based on the selections above). Study the screenshot below to ensure you are still on the right track: In the Create Pivot Table dialogue box, the Select a Table or Range and New Worksheet radio buttons should be selected by default. In the Tables group, click on Pivot Table and select Pivot Table from the list.ĥ. Select the data range (rows and columns) in the worksheet that you wish to analyze. So the first step would be to find or create a worksheet containing multiple labelled rows and columns of populated cells.Ģ. You cannot start a Pivot Table based on zero data. A Pivot Table is an analysis tool used to analyze existing data.
FREE ONLINE EXCEL 2007 TUTORIAL HOW TO
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.
FREE ONLINE EXCEL 2007 TUTORIAL FREE
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.