Elert & Associates Technology Training
Home About Services Delivery Methods Courseware Testimonials Contact Us
Student Links Register for a Class Course Catalog Student Resources

Excel Pivot Tables


Learn to summarize worksheet data using pivot tables and pivot charts.

Prerequisite Skills

Course Description

Do you need to analyze lists of data? Learn why and when you can use a pivot table or pivot chart to analyze and summarize data. This workout covers creating and modifying pivot tables, filtering and formatting data, customizing pivot table options, and creating pivot charts.

Attend this course if you want to:

  • Learn why and when you might want to use a pivot table or pivot chart.

  • Set up your data properly before creating the pivot table or chart.

  • Create a pivot table.

  • Modify and format a pivot table.

  • Filter and sort data in a pivot table.

  • Use slicers to filter data.

  • Use timelines to filter data by date.

  • Refresh a pivot table to reflect changes in the source data.

  • Chang the data source.

  • Group pivot table items.

  • Drill down to view details.

  • Create and modify a pivot chart.

  • Customize pivot table options.

Class Length

90 minutes

Delivery Options

  • Virtual classroom - public
    ($70 per student; check times and register here)

  • Virtual classroom - private (up to ten people from the same organization)
    ($480 per class; contact us for more details)

  • On-site instructor-led
    (Contact us for details)




   Print this page without top and side navigation

View a virtual classroom demo