The Onramp to Understading Excel pivotables

Course Description:

Just about everyone has heard about PivotTables and most realize that they can be very beneficial. Unfortunately, many can’t quite get started with using this powerful Excel® feature. This session shows users that with a basic understanding of PivotTable conventions, the intimidation factor disappears. It is a two hour introduction to PivotTables that shows how easy they are to use, ways to avoid common PivotTable pitfalls, and how timesaving they can be. If you want to get started with PivotTables and benefit from the features of this wonderful Excel® tool – this session is for you!

Learning Objectives:

Once participants have completed this session they should be able to:

• Understand the underlying concepts and conventions that drive PivotTable operation
• List four important components used when creating and working with PivotTables
• Understand how to create and drive the operation of PivotTables of all types.

Course Highlights:

This session is taught using a Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor for a greatly improved learning experience. The Excel topics discussed in this session include:

• Introducing PivotTables
• PivotTable functionality
• Making PivotTables work for you

Who Should Attend?

Accounting and other business professionals that work in Excel® to analyze and report upon data who want to utilize the power of PivotTables. 

Area of Study:

Computer Software and Applications

Level:

Basic

Credit:

2 hours

Prerequisites:

None