Advanced Excel® Topics for Spreadsheet Power Users

2022-11-21 08:30:002022-11-21 16:15:00 ET

# of CPE Credits



Accountants and other business professionals who work in Excel® extensively become very strong with many aspects of the ubiquitous spreadsheet application. They, however, often do not have knowledge of the numerous advanced features available in Excel. In this session we highlight many of the powerful tools found in Excel and provide details as to how they are beneficial and how they are used. Topics include data connectivity, advanced functions available for formula creation, Excel Tables and PivotTables, and charting tools. Many proficient Excel users only utilize a limited percentage of the available functionality when they work with spreadsheets, which is like tying one’s hands behind his back. This session will help make participants “two-fisted” Excel users!


Once participants have completed this session, they should be able to * Work with the charting tools in Excel® and understand conditional formatting * Explain the benefits of using the Data ToolPak and such tools as descriptive statistics and regression analysis * Create complex powerful formulas using advance functions available from the Excel Function Library * List four benefits of using Excel tables and understand ways that tables are helpful * Work with PivotTables to summarize and present information and understand some of the many PivotTable features


* This session is taught using a Hands-On methodology * We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor for a greatly improved learning experience * The Excel® topics discussed in this session include * Using Excel for Graphical Output and Dashboard Reporting * Data Tools and the Data Analysis ToolPak * Advanced Functions and Complex Formulas * Working with Excel Tables and PivotTables * All practice and demonstration files are available for download for a period of 30 days after the session is taught

Who Should Attend

Accounting and other business professionals who work extensively with Excel® who want to become knowledgeable about the many powerful features it possesses

Required Knowledge

An understanding of Excel® conventions

Advanced Prep

An understanding of Excel® conventions

Event Speaker(s)

Karl Egnatoff, CPA, CITP ( Taymes, LLC, Myrtle Beach, SC ),

Additional Event Information

Technical Support
Contact NCACPA if you need assistance with your online program. For the quickest results, email the Online Learning Team at [email protected], and a team member will contact you shortly.

If you need assistance with internet access issues, browser capability, or when the NCACPA office is closed* please call Freestone Technical Support at 866-702-3278 or by email at [email protected] .

*NCACPA office hours are 9:00 am–5:00 pm ET. Online Learning Team members will be available via email 30 minutes prior to the start of a live online program.

Test Your System
You may test your system by clicking here. Please test your system to ensure you have the proper components installed.

Also Available As

2022-06-09 08:30:002022-06-09 16:15:00 ET)
Register >>
2022-09-20 08:30:002022-09-20 16:15:00 ET)
Register >>
2023-01-30 08:30:002023-01-30 16:15:00 ET)
Register >>
2023-02-24 08:30:002023-02-24 16:15:00 ET)
Register >>

Share This Event

Event Vendor:Taymes, LLC
Field of Study:Computer Software & Applications
Level: Intermediate/Adv

Event Type:Webinar
NASBA Instructional Method:Group Internet Based
Event Code:WB100122

Registration Fees

RegistrationEarly BirdRegular
NCACPA MemberN/A$260.00
CPE Sponsors LogoThe North Carolina Association of Certified Public Accountants is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org/.

For information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call 800-469-1352.