0
Author: |
David Ringstrom, CPA |
Course Length: |
Pages: 3 ||| Review Questions: 6 ||| Final Exam Questions: 10 |
CPE Credits: |
2.0 |
IRS Credits: |
0 |
Price: |
$29.95 |
Passing Score: |
70% |
Course Type: |
Video |
Technical Designation: |
NonTechnical |
Field Of Study: |
Computer Software & Applications |
Approved Audience: |
NASBA QAS - NASBA Registry |
Key Takeaways: |
This course addresses common Excel formula and error handling challenges, including merged cell errors, circular references, and version compatibility concerns.
|
Frequently Asked Questions: |
|
Description: |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide you through a comprehensive exploration of Excel's formula and error-handling capabilities. You'll gain invaluable insights into tackling common spreadsheet challenges, starting with understanding and resolving merged cell errors and various types of formula errors. David will delve into the evolution of worksheet functions and demonstrate techniques for checking worksheet function compatibility across different Excel versions. Explore the latest Excel 2021 and Excel for Microsoft 365 functions, including the powerful FILTER Function and see how to handle new errors like #SPILL! and #CALC!. Discover the art of using the Error Checking and Trace Error commands, and master using the IFERROR function to minimize intermittent errors. David will also reveal how extraneous spaces can trigger #N/A errors in VLOOKUP and XLOOKUP. You'll also learn how to locate pesky circular references. Don't miss this opportunity to learn disaster recovery and prevention techniques, such as repairing damaged workbooks and deleting temporary files. Join us for this illuminating webinar and enhance your Excel expertise. David is the author of “Microsoft Excel 365 for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and has written or co-authored six other books. He demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Excel for Microsoft 365. David draws your attention to any differences in Excel 2021, 2019 or 2016 during the presentation and in his detailed handouts. The handouts include an Excel workbook with most of the examples he uses during his demonstrations. Excel for Microsoft 365 is a subscription-based product that receives periodic feature updates. Conversely, perpetually licensed versions have year numbers in their names and do not receive any feature updates. |
Usage Rank: |
15000 |
Release: |
2025 |
Version: |
1.0 |
Prerequisites: |
None. |
Experience Level: |
Overview |
Additional Contents: |
Complete, no additional material needed. |
Additional Links: |
External: The Importance of Excel in Business
Internal: Excel CPE Courses For CPAs
Internal: Excel Error Prompts Video course
External: Excel Error Prompts (Video) on NASBA Registry
|
Advance Preparation: |
None. |
Delivery Method: |
QAS Self Study |
Intended Participants: |
Anyone needing Continuing Professional Education (CPE). |
Revision Date: |
14-Jul-2025 |
NASBA Course Declaration: |
Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam. |
Keywords: |
Excel Error Prompts (Video) - CPE course for CPAs |
Learning Objectives: |
Course Learning Objectives Upon completion of this course, participants will be able to do the following:
|
Course Contents: |
Chapter 1 - Excel Error Prompts Chapter 1 Review Questions Key Terms |
Login/Register