Excel 2016 Data Analysis with PivotTables - Half Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Upon successful completion of this course, students will be able to:

  • Prepare Data for PivotTable reporting and create PivotTables from various data sources
  • Analyze Data Using PivotTables
  • Work with PivotCharts

Class Content

Lesson 1: Preparing Data and Creating PivotTables

  1. Prepare Data
  2. Create a PivotTable from a Local Data Source
  3. Create a PivotTable from Multiple Local Data Sources 
  4. Create a PivotTable from an External Data Source 

Lesson 2: Analyzing Data Using PivotTables

  1. Summarize PivotTable Data
  2. Organize PivotTable Data
  3. Filter PivotTable Data 
  4. Format a PivotTable
  5. Refresh and Change PivotTable Data

Lesson 3: Working with PivotCharts

  1. Create a PivotChart
  2. Manipulate PivotChart Data
  3. Format a PivotChart

If you would like to customize this class please call us at (888) 572-1200 

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!