Excel PivotTables - Part II

Course Details

Date

Thursday, October 22, 2020

8:00am – 12:00pm

Course Number

AC0427

CPE Credit

4.0 hours CPE credit

Level of Knowledge

Intermediate

Vendor

ACPEN

Prerequisites

Fundamental knowledge of Microsoft Excel PivotTables

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. 

Highlights

*Accounting
*Computer Software & Applications

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

Designed For

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

Registration for this course has passed.

Course Pricing

Member Fee

Applicable if you are a HSCPA member in good standing.

$129.00
Non-Member Fee

Applicable if you are not a HSCPA member.

$159.00
Your Price $159.00

CPE Choice

Learn more about CPE Choice.
This course does not qualify for CPE Choice.

View All Webcasts