Webcast: Getting Past Your Sticking Point with PivotTables (XCGPPPW17)
Register Tell a Friend About This EventTell a Friend
 

A great many Excel users avoid PivotTables even though they know how powerful they are because they are intimidated by the complexities of working with them. In reality, PivotTables are fairly easy to use and can be mastered by anyone that takes a bit of time to understand the way they work. This session is designed to show users that a basic understanding of PivotTable conventions will make the intimidation factor disappear. Additionally, it details the robust feature set built into PivotTables

 Export to Your Calendar 6/9/2017
When: 06/09/2017
8:30 AM until 12:00 PM
Where: Webcast
CALCPA
4173383Y
United States
Presenter: Karl Egnatoff, CPA


Online registration is available until: 6/7/2017
« Go to Upcoming Event List  

AcronymXCGPPPW17
CPE4 hours
VendorCalCPA
Category
Management
LevelBeginning
PrerequisiteNone
Adv PrepNone
Yellow Book?No
Designed forAccounting and other business professionals that work in Excel who want to utilize the power of PivotTables.
Registration
Member$120
CPA Non-Member$188

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

Course Description

 A great many Excel users avoid PivotTables even though they know how powerful they are because they are intimidated by the complexities of working with them. In reality, PivotTables are fairly easy to use and can be mastered by anyone that takes a bit of time to understand the way they work. This session is designed to show users that a basic understanding of PivotTable conventions will make the intimidation factor disappear. Additionally, it details the robust feature set built into PivotTables.

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
  • Explain ways to improve data presentation in PivotTables with:
  • Automatic and custom groups
  • PivotTable options
  • The Design tab of the PivotTable tools ribbon add-In

Major Topics

  •   Understanding PivotTable conventions
  •   How to build an Excel PivotTable
  •   PivotTable options and grouping tools