Excel 2013 - Data Analysis with Pivot Tables
Analyzing data and gaining insight is important. You have experience creating PivotTables but Excel is capable of doing more. In this course, students will learn how to organize data in a way that can be meaningfully presented to others using PivotTables.
Who Should Attend
Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.
Upon successful completion of this course, you will be able to use Excel 2013 advanced PivotTable functionality to analyze your raw data. You will:
Prepare data for PivotTable reporting and create PivotTables from various data sources.
Analyze Data Using PivotTables.
Work with PivotCharts.
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
2 - Analyzing Data Using PivotTables
- Summarize PivotTable Data
- Organize PivotTable Data
- Filter PivotTable Data
- Format a PivotTable
- Refresh and Change PivotTable Data
3 - Working with PivotCharts
- Create a PivotChart
- Manipulate PivotChart Data
- Format a PivotChart
This is a 1-day class
GTR Guaranteed to Run
Class times are listed Eastern time. This class is available for Private Group Training
To sort by location or date, click the ‘When’ and ‘Where’ column headings.
Class dates not listed.
contact us for available
dates and times.