Event Details

Excel PivotTables - Part II (ACEPPI02)

Date:	Monday, April 16, 2018
Time:	12:00PM - 4:00 PM (Registration at 11:30AM)
Facility:	Webcast or Webinar, Online
CPE Credit:	2.0 Accounting and Auditing 2.0 Technical Business
Instructor:	Thomas G. Stephens
Vendor:	ACPEN
Course Level:	Intermediate
Early Bird Price:	$129.00 FICPA Members, $159.00 Non-Members

Description:

If you are already using PivotTables and are looking to make your reports and analyses even more powerful, then this is the program for you! In this session, you will build upon your existing knowledge of basic PivotTables to make Excel's best feature even more powerful. More specifically, you will learn how perform such actions as creating user-defined calculation in your PivotTables, advanced data grouping techniques for PivotTable data, how to use Power Pivot to create more advanced PivotTables, and advanced PivotTable tips and techniques to speed the process of creating reports and analyzing data.

Objectives:

Create PivotTables and PivotCharts and add advanced elements to PivotTables, such as calculated fields and calculated items
Group PivotTable data based on user-defined fiscal reporting periods
Create enterprise-class PivotTables from large and complex data sets, using Microsoft’s Power Pivot tool
Utilize advanced sorting and filtering techniques, PivotCharts, and GETPIVOTDATA to analyze PivotTable data
Describe how to apply specific PivotTable techniques such as Show Report Filter Pages and VLOOKUPs to solve specific issues associated with PivotTables

Major Topics:

Accounting
Computer Software & Applications

Who Should Attend:

Accounting, financial, and other business professionals who want to build upon their existing knowledge of PivotTables to create more powerful reports and analyses

Prerequisite:

Fundamental knowledge of Microsoft Excel PivotTables

Advanced Preparation:

None

Session/Options

If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.

Back