Print Course information
Email me when offered
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

 

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