Microsoft Excel Data Analysis with Pivot Tables

Microsoft® Excel’s advanced Pivot features will create Pivot Tables and Charts. Pivot Tables and Pivot Charts are tools you can use to analyze and summarize raw data.

COURSE CONTENT

PREPARING DATA AND CREATING PIVOT TABLES

• Prepare Data

• Create a Pivot Table from a Local Data Source

• Create a Pivot Table from Multiple Local Data Sources

• Create a Pivot Table from an External Data Source

ANALYZING DATA USING PIVOT TABLES

• Summarize Pivot Table Data

• Organize Pivot Table Data

• Filter Pivot Table Data

• Format a Pivot Table

• Refresh and Change Pivot Table Data

WORKING WITH PIVOT CHARTS

• Create a Pivot Chart

• Manipulate Pivot Chart Data

• Format a Pivot Chart