Print Course information
Email me when offered
Return to Course Catalog

Workshops > Microsoft Office 2016

Data Analysis with PivotTables   

Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

This workshop is a blended training experience that includes instructor-led classroom time plus these online components available to you on any mobile device.

  • E-Book – an electronic version of your printed book, readable on any computer or mobile device
  • Files – the practice files used in the instructor-led class
  • Assessments – Detailed evaluations based on course content
  • Learn To – Short video tutorials reinforcing and expanding key concepts of the course
  • Checklist – Quick reference material and step-by-step instructions for tasks covered in the class in an easy-to-find format

Topics Covered
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 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

Download Class Files


No sections are currently available for this workshop. Click here to continue searching for workshops.

The Professional Development Institute
Illinois Central College Peoria Campus
5407 N. University St. Peoria, IL. 61635

© Illinois Central College. All Rights Reserved.