Excel PivotTables: Part I (Webinar)

Code: WA482341

Space is available, but online registration has closed. Please call 952-831-2707 to register.

Date Monday, July 16, 2018
Time 9:00 AM - 1:00 PM
Central Time
Location Online
CPE credits CPE 4.0
Field(s)
of study
Accounting - Technical (2.0)
Computer Software & Applications - Non-Technical (2.0)
Instructor Thomas Stephens, CPA, CITP, CGMA
K2 Enterprises
Fees
Standard member fee $129.00
checkmarkStandard nonmember fee $129.00

Members: Please log in to receive member fee.

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!

Who should take this program?

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

Major subjects

  • Accounting
  • Computer Software & Applications

Learning objective(s)

  • 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

Notes:

Course code Code WA482341
Sponsor Business Professionals' Network, Inc.
NASBA ID#: 107810
Level Intermediate
Format Group Internet Based
Prerequisites Prereq. Fundamental knowledge of Microsoft Excel
Advance
prep
None