Online handout: https://tinyurl.com/ycxmumb9

Use the QR code to access the online version:

Pivot Tables with Microsoft Excel

Topic: Using tools for data analysis.

PIVOT TABLES

PivotTables are used to summarize, analyze, explore and compare data.

Examples of uses of Pivot Tables: comparing sales of different products, showing product sales as a percentage of total sales, aggregating duplicate data, getting an employee headcount for separate departments, and analyzing sports data.

A Pivot Table can be created from an existing database, worksheet data, or an Excel table. However, there are required conditions for creating a PivotTable:

• The worksheet data must contain column headings.
• If you are using a table, the headers must be displayed.
• The table cannot have any blank rows.

Insert a Pivot Table

1. Select a table or range in your spreadsheet, and then select Insert > Tables Group >PivotTable or Recommended Tables.

   The Insert PivotTable pane displays the Data Source and the Destination where the Pivot Table will be inserted.

2. Verify that the Table/Range is correct

3. Choose the location of the Pivot Table

4. Click OK

Look for the In the PivotTable Fields area on the right of the Worksheet.

1. Select the check box for any field you want to add to your Pivot Table.
2. By default, non-numeric fields are added to the Rows area, date and time fields are added to the Columns area, and numeric fields are added to the Values area.
3. Being able to rearrange Field items is one of the Pivot Table features that makes it so easy to quickly change its appearance.

To Edit the Pivot Table