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

PivotTables are the most powerful feature of Excel, yet few business professionals use them in their day-to-day activities. For some, PivotTables are too intimidating; for others, PivotTables are a foreign concept. With a little information, guidance, and demonstration from your instructor, you will be ready to take advantage of PivotTables to perform routine data analysis and reporting more quickly and more effectively than ever. In this session, you will learn the nuts-and-bolts of PivotTables

7/13/2020
When: 07/13/2020
8:00 AM
Where: Webcast
CPE
2551366
United States
Presenter: K2 Enterprises


Online registration is closed.
« Go to Upcoming Event List  

Acronym 2551366
CPE 4
Vendor ACPEN
Category
Accounting - Technical = 2, Computer Software & Applications - Non-technical = 2
Level Intermediate
Yellow Book?
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

PivotTables are the most powerful feature of Excel, yet few business professionals use them in their day-to-day activities. For some, PivotTables are too intimidating; for others, PivotTables are a foreign concept. With a little information, guidance, and demonstration from your instructor, you will be ready to take advantage of PivotTables to perform routine data analysis and reporting more quickly and more effectively than ever. In this session, you will learn the nuts-and-bolts of PivotTables, setting the stage for greater productivity than perhaps you can even imagine!

Objectives

*Identify and define the six main elements of a PivotTable report *Create PivotTables that summarize large volumes of data *Apply specific formatting techniques to PivotTables *Create a PivotTable that links data from an external data source, such as an accounting database *Consolidate multiple ranges of data quickly and easily using PivotTables

Major Topics

*Accounting *Computer Software Applications

Designed For: Accounting, financial, and other business professionals who want to use the power of Excel PivotTables to analyze and summarize data

Prerequisite: Fundamental knowledge of Microsoft Excel

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

Membership Management Software Powered by YourMembership  ::  Legal