• Microsoft Office Courses
• Upgrading to Microsoft Office 2019
• Introduction to Microsoft Access 2019
• Advanced Microsoft Access 2019
• Introduction to Microsoft Excel 2019 Training
• Intermediate Microsoft Excel 2019 Training
• Advanced Microsoft Excel 2019 Training
• Introduction to Microsoft Outlook 2019
• Advanced Microsoft Outlook 2019
• Introduction to Microsoft PowerPoint 2019 Training
• Advanced Microsoft PowerPoint 2019 Training
• Introduction to Microsoft Word 2019 Training
• Intermediate Microsoft Word 2019 Training
• Advanced Microsoft Word 2019 Training
• Microsoft Publisher 2019
• Excel 2019 Programming with VBA
• MOC 10997 - Office 365 Administration and Troubleshooting
• Microsoft Teams Training
• Introduction to Visual Basic for Applications (VBA)
• Advanced Visual Basic for Applications (VBA)
• MOC 20347 - Enabling and Managing Office 365
• Using Office 365
• InfoPath 2013 Training
• More Courses

• Microsoft Office Courses
• Upgrading to Microsoft Office 2019
• Introduction to Microsoft Access 2019
• Advanced Microsoft Access 2019
• Introduction to Microsoft Excel 2019 Training
• Intermediate Microsoft Excel 2019 Training
• Advanced Microsoft Excel 2019 Training
• Introduction to Microsoft Outlook 2019
• Advanced Microsoft Outlook 2019
• Introduction to Microsoft PowerPoint 2019 Training
• Advanced Microsoft PowerPoint 2019 Training
• Introduction to Microsoft Word 2019 Training
• Intermediate Microsoft Word 2019 Training
• Advanced Microsoft Word 2019 Training
• Microsoft Publisher 2019
• Excel 2019 Programming with VBA
• MOC 10997 - Office 365 Administration and Troubleshooting
• Microsoft Teams Training
• Introduction to Visual Basic for Applications (VBA)
• Advanced Visual Basic for Applications (VBA)
• MOC 20347 - Enabling and Managing Office 365
• Using Office 365
• InfoPath 2013 Training
• More Courses

Microsoft Office Excel 2016: Data Analysis with PivotTables

Print  

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

Goals

1. Prepare data for PivotTable reporting and create PivotTables from various data sources.
2. Analyze Data Using PivotTables.
3. Work with PivotCharts.

Outline

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
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
3. Working with PivotCharts
   1. Create a PivotChart
   2. Manipulate PivotChart Data
   3. Format a PivotChart

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Office class:

• Experience working with Excel 2016 and PivotTables.
• Understanding of spreadsheet concepts and comfort creating basic PivotTables.

---

Training for your Team

Length: 1 Day

• Private Class for your Team
• Online or On-location
• Customizable
• Expert Instructors

Request Pricing