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® conventions
Event Speaker(s)
Additional Event Information
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
Tuesday, September 20, 2022 (8:30 am–4:15 pm ET)Register >>
Monday, November 21, 2022 (8:30 am–4:15 pm ET)Register >>
Monday, January 30, 2023 (8:30 am–4:15 pm ET)Register >>
Friday, February 24, 2023 (8:30 am–4:15 pm ET)Register >>
Share This Event
Registration Fees
| Registration | Early Bird | Regular |
|---|---|---|
| NCACPA Member | N/A | $260.00 |
| Non-Member | N/A | $360.00 |
The 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.