Loading...

Advanced Excel® Topics for Spreadsheet Power Users

8:30 am–4:15 pm ET

# of CPE Credits

8

Description

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!

Objective

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

Highlights

* 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® con

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

Webcast
Thursday, July 22, 2021 (8:30 am–4:15 pm ET)
Register >>
Webcast
Wednesday, September 8, 2021 (8:30 am–4:15 pm ET)
Register >>
Webcast
Friday, December 3, 2021 (8:30 am–4:15 pm ET)
Register >>
Webcast
Tuesday, January 18, 2022 (8:30 am–4:15 pm ET)
Register >>

Share This Event

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

Event Type:Webcast
NASBA Instructional Method:Group Internet Based
Event Code:W0025321

Registration Fees

RegistrationEarly BirdRegular
NCACPA MemberN/A$245.00
Non-MemberN/A$345.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.