Excel Data Analysis with PivotTables

Excel Data Analysis with PivotTables

1 Day

About:  In this one-day course, students will learn how to prepare data for PivotTable reporting, create PivotTables from various data sources, analyze data using PivotTables, and work with PivotCharts.

Audience Profile: Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.

Prerequisites: To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.

Module 1: Preparing Data and Creating PivotTables

· Prepare Data
· Create a PivotTable from a Local Data Source
· Create a PivotTable from Multiple Local Data Sources
· Create a PivotTable from an External Data Source

Module 2: Analyzing Data Using PivotTables

· Summarize PivotTable Data
· Organize PivotTable Data
· Filter PivotTable Data
· Format a PivotTable
· Refresh and Change PivotTable Data

Module 3: Working with PivotCharts

· Create a PivotChart
· Manipulate PivotChart Data
· Format a PivotChart