Excel - Data Analysis with PivotTables
1 DAYS
Description:
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