Crescent Career Center
Career Training

Course Details

Excel - Data Analysis with PivotTables



 Being able to harness the power of advanced PivotTable features and create PivotCharts will help participants gain a competitive edge. Participants will not only be able to summarize data to analyze, but also organize the data in a way that can be meaningfully presented to others. 

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

Analyzing Data by Using PivotTables
Summarize PivotTable Data
Organize PivotTable Data
Filter PivotTable Data
Format a PivotTable
Refresh and Change PivotTable Data

Working with PivotCharts
Create a PivotChart
Manipulate PivotChart Data
Format a PivotChart