Description
A great many Excel® users do not realize how powerful and versatile formulas can be. Additionally, some are intimidated by formulas that do not behave as expected. In this session, we step through all the basic and then more complex formula conventions. We then review the function library and discuss details on how they are best used. Finally, we spend time reviewing some of the ways formulas can be helpful and time-saving. Users who want to learn how to “program” Excel should take this session!
Objective
Once participants have completed this session, they should be able to * Understand basic formula conventions such as identifying a formula and order of operation * Introduce functions from the Function Library * List important concepts related to function use * Show how to combine and nest multiple functions in a single formula
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 * Understanding formula conventions * Working with Functions * Some of the many uses of Excel formulas
Who Should Attend
Accounting and other business professionals who work in Excel® and who want to utilize the power of formulas
Required Knowledge
An understanding of Excel® formulas
Advanced Prep
None
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
Webinar
2022-11-11 13:00:002022-11-11 16:45:00 ET)Register >>
Webinar
2023-04-18 08:30:002023-04-18 12:15:00 ET)Register >>
Share This Event
Registration Fees
| Registration | Early Bird | Regular |
|---|---|---|
| NCACPA Member | N/A | $145.00 |
| Non-Member | N/A | $195.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.