• 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
• Introduction to Microsoft Excel 2016 Training
• Intermediate Microsoft Excel 2016 Training
• Advanced Microsoft Excel 2016 Training
• Introduction to Microsoft Word 2016 Training
• Intermediate Microsoft Word 2016 Training
• Advanced Microsoft Word 2016 Training
• Introduction to Microsoft Access 2016
• MOC 10997 - Office 365 Administration and Troubleshooting
• Advanced Microsoft Access 2016
• Introduction to Microsoft PowerPoint 2016 Training
• Advanced Microsoft PowerPoint 2016 Training
• Introduction to Microsoft Outlook 2016
• Advanced Microsoft Outlook 2016
• Microsoft Publisher 2016
• Excel 2016 Programming with VBA
• 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
• Introduction to Microsoft Excel 2016 Training
• Intermediate Microsoft Excel 2016 Training
• Advanced Microsoft Excel 2016 Training
• Introduction to Microsoft Word 2016 Training
• Intermediate Microsoft Word 2016 Training
• Advanced Microsoft Word 2016 Training
• Introduction to Microsoft Access 2016
• MOC 10997 - Office 365 Administration and Troubleshooting
• Advanced Microsoft Access 2016
• Introduction to Microsoft PowerPoint 2016 Training
• Advanced Microsoft PowerPoint 2016 Training
• Introduction to Microsoft Outlook 2016
• Advanced Microsoft Outlook 2016
• Microsoft Publisher 2016
• Excel 2016 Programming with VBA
• 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  

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

---

Training for Yourself

$395.00 or 1 vouchers

Upcoming Live Online Classes

• Apr 4, 2019 1PM-5PM ET
• May 10, 2019 1PM-5PM ET
• Jun 28, 2019 1PM-5PM ET
Aug 8, 2019 1PM-5PM ET
Sep 27, 2019 1PM-5PM ET
Oct 31, 2019 1PM-5PM ET
Dec 12, 2019 1PM-5PM ET

See More Classes

Please select a class.

Register Now

• Live Online Training
• For Individuals
• Expert Instructors
• Guaranteed to Run
• 100% Free Re-take Option
• 1-minute Video