Microsoft Excel - Pivot Table in pdf

Objectives:

• Learn how to set up your data in Excel in a format that you can use for a pivot table.
• Create a pivot table with that data
• Filter pivot table reports
• Change the summary function used in the pivot table
• Format a pivot table and change pivot table options.
• Change the pivot table report to reflect different views on the same data.
• Create a PivotChart with your pivot table

ABOUT PIVOT TABLES

• Analyze and summarize data without disturbing the original data set
• Sort to look up data in chronological order
• Filter to limit scope to certain values you specify.
• Place the pivot table on its own worksheet.
• Use pivot tables to produce pivot charts to present the information in a graphical way.