Description
In this course, we will focus on debugging and troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn methods to resolve issues when you receive errors. Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using Excel’s built-in formulas? Then this class is for you!
This session will also discuss Excel’s nine built-in error-checking options and then demonstrate different approaches to error resolution. We will also review techniques to resolve rounding errors.
This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel.
Required Knowledge: None
Advanced Preparation: None
Who Should Attend: Anyone who wants to become an expert in using and troubleshooting Excel functions and formulas in spreadsheets
- On Demand
Registration Fees
| Registration | Type | Price |
|---|---|---|
| Member | Member | $100 |
| Non Member | Non Member | $225 |
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.