Print Course information
E-mail to a friend
Return to Course Catalog

Workshops > From 0 to 60

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


Data Analysis with PivotTables
Item: ITOFF90125
1:00 PM - 4:30 PM Location: Hickory Hall, Hickory 128
Sessions: 1 M 5407 N. University Peoria, IL 61635
3/23/2020 - 3/23/2020 Fee: $80.00

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

© Illinois Central College. All Rights Reserved.