Events Search
  Summary & Check Out (0)
Wednesday, November 8, 2017 Live

Excel PivotTables – Powerful and Not Hard to Use… Really! (E1711043)

8:30 AM - 4:30 PM EDT

Registration: 8:00 AM EDT

APA Hotel Woodbridge

120 Wood Avenue South
Iselin , NJ 08830

8 CPE Credits in CS

OVERVIEW

Excel users that regularly manipulate, analyze, or present data can improve their productivity substantially by utilizing PivotTables. Many users avoid PivotTables even though they know how powerful they are because they believe PivotTables are confusing to work with and hard to use. Additionally, many people know that they provide benefit but do not realize the depth of capabilities that the PivotTable reporting feature possesses. This session shows users that with a basic understanding of PivotTable conventions, the intimidation factor disappears. Additionally, it details the robust feature set built into PivotTables. This course also spends time providing information about Excel Tables, which are helpful as a stand-alone feature, but also can be used to enhance PivotTable use.

DESIGNED FOR

Accounting and other business professionals that work in Excel to analyze and report upon data who want to utilize the power of PivotTables.

BENEFITS

Once participants have completed this session they should be able to:
  • Understand the underlying concepts and conventions that drive PivotTable operation
  • List four important components used when creating and working with PivotTables
  • Understand the benefits of using Excel Tables, not only with PivotTables but as stand-alone objects
  • Explain ways to improve data presentation in PivotTables with:
    • Automatic and custom groups
    • PivotTable options
    • The Design tab of the PivotTable tools ribbon add-In
    • Formatting, sorting and filtering features in Excel
  • Understand calculations in PivotTables including Calculated Field and Calculated Items
  • Create and modify PivotCharts

HIGHLIGHTS

  • Introducing PivotTables
  • Working with Excel tables
  • Connecting PivotTables to external data
  • Extended PivotTable functionality
  • Creating calculations in PivotTables
  • Using PowerPivot and creating PivotCharts
  • All practice and demonstration files are available for download for a period of 30 days after the session is taught

COURSE LEVEL

Intermediate

PREREQUISITES

An understanding of Excel conventions.

ADVANCE PREPARATION

None

ADDITIONAL NOTES

This is "hands on optional" course: feel free to bring a laptop and download the work files OR if you can watch without doing (instructor completes every example on screen and explain the steps as he goes).

INSTRUCTOR

Karl Egnatoff

Karl W. Egnatoff, CPA, CITP

Phoenix Beach, LLC

Karl Egnatoff is a Certified Public Accountant (CPA) currently living in Myrtle Beach, South Carolina. During the past 22 years Mr. Egnatoff has worked as a consultant, trainer and as a software engineer while engaged on projects for business organization of all types. Prior to this, Karl worked in public accounting as well as in private sector accounting for a period of approximately six years. Before partnering with Pat Garverick to form Phoenix Beach in 2015, Karl presented and created material in association with other quality CPE organizations for approximately seven years. In addition to being a CPA, he is also a Certified Information Technology Professional (CITP). During the course of his career, Mr. Egnatoff has owned and operated a number of successful businesses. All of these provided services to other organizations in the business community. The experience he garnered while serving these organizations helps him now as he writes and presents continuing professional education through Phoenix Beach. Mr. Egnatoff is a member of the West Virginia Society of Certified Public Accountants, the American Institute of Certified Public Accountants, and the Information Technology Section of the American Institute of Certified Public Accountants. He has also achieved a number of technology certifications including Microsoft Certified Professional (MCP), Certified Software Engineer (CSE) and Certified Integration Developer (CID). Karl graduated from Marshall University with a Bachelor of Business Administration degree. During his time in college, he participated in division I Cross County competing on the varsity squad. He was also on Marshall’s Track team. Karl and his wife Lana have been married for twenty-seven years. They have two grown sons, Jordan and Steven.

PRICING

$399.00 - Nonmember

$299.00 - Member

Pre-Registration Closed

Online pre-registration for this event is now closed.

ADDITIONAL OPTIONS

Print a registration form

COURSE DEVELOPER

Phoenix Beach, LLC