Print Page   |   Your Cart   |   Sign In   |   Join
(2551408) Excel PivotTables – Part II
View Registrations Tell a Friend About This EventTell a Friend
 

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 PivotTabl

4/6/2020
When: 04/06/2020
12:00 PM
Where: Webcast
CPE
2551408
United States
Presenter: K2 Enterprises


Online registration is closed.
« Go to Upcoming Event List  

Acronym 2551408
CPE 4
Vendor ACPEN
Category
Accounting - Technical = 2, Computer Software & Applications - Non-technical = 2
Level Intermediate
Yellow Book? No
Registration Fees
Members* $129
Non-Members $159

*The Member rate applies to UACPA members and reciprocal state society members. To register online, use the ‘Register’ button above. To register by phone, call the UACPA at 801-466-8022, Monday through Friday, 8am to 4pm.

Course 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

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

Prerequisite: Fundamental knowledge of Microsoft Excel PivotTables

Note: Login instructions will be provided by the webcast vendor.

Membership Management Software Powered by YourMembership  ::  Legal