Print Page   |   Contact Us   |   Sign In   |   Join
Excel - Everything You Wanted to Know About Using Excel Pivot Tables (4 CPE Credits) (3352)
Tell a Friend About This EventTell a Friend
 

This intermediate Excel course will provide an overview of using pivot tables to analyze your data. Practical examples and various techniques will be utilized to demonstrate the value of pivot tables for data analysis. Topics reviewed in this course include: pivot table advantages, creating pivot tables, connecting to external databases, and pivot table charts. It is highly recommended that you attend the session: Excel - Preparing Your Source Data for Analysis (or have equivalent Excel knowle

8/13/2015
When: 08/13/2015
10:00 AM - 2:00 PM
Where: Webcast/Webinar
Presenter: John Higgins, CPA.CITP or Bryan Smith, CPA.CITP, CISA
Contact: April Deneault
801-834-6634

« Go to Upcoming Event List  

This intermediate Excel course will provide an overview of using pivot tables to analyze your data.  Practical examples and various techniques will be utilized to demonstrate the value of pivot tables for data analysis.  Topics reviewed in this course include: pivot table advantages, creating pivot tables, connecting to external databases, and pivot table charts. It is highly recommended that you attend the session: Excel - Preparing Your Source Data for Analysis (or have equivalent Excel knowledge) before you attend this session.
 

Objectives:

After completing this course you will have the ability to... Define and understand the advantages of using pivot tables to analyze data from multiple dimensions. Create a pivot table using a step-by-step process that will analyze accounting data to benefit sales planning and trial balance analysis. Demonstrate all pivot table options to maximize your data analysis. Connect to external databases for maximum efficiency and flexibility while analyzing your data. Create pivot table charts to present your data graphically for the most effective analysis.

 

Major Subjects:

The major topics that will be covered in this course include:

 Pivot table advantages

 Creating pivot tables

 Connecting to external databases

 Pivot table charts
  

 

Designed For:

Professionals who want to learn Excel intermediate features/functions

 

Prerequisite: 

Basic working knowledge of Excel features/functions

 

Advanced Prep:

None

  

Speaker:  John Higgins, CPA.CITP or Bryan Smith, CPA.CITP, CISA

Vendor:  CPA Crossings, LLC

Field of Study: Info Tech

Level: Intermediate

CPE Credit:         4 Hours

Acronym: EX041W

 

Registration Fees:

$ 158

  

Register here


Membership Management Software Powered by YourMembership.com®  ::  Legal