Excel Accountant: Error Prompts

Welcome to myCPE

First Name

Last Name

Organization Name

Work Email Address

12 Months

$199 $499/User

Get 60% Off

24 Months

$359 $999 /User

Get 64% Off

36 Months

$499 $1499 /User

Get 67% Off

Number of Seats

Promo Code

Proceed to Pay

Name

John Smith

johnsmith@yahoo.com

Subscription

1 Year

Total Payment:

$597 for 3 Seats

Verification Code from Email

Card No.

Card Holder Name

Expiry Date

CVV

Address

By signing up, I accept the myCPE Terms and Conditions and Privacy Notice

Guaranteed safe & secure checkout

Pay $199

Excel Accountant: Error Prompts

Learning Objectives

To identify different errors in an Excel worksheet
To recognize how to manage error-checking prompts, error-checking commands, and tracing error command
To select and apply Excel’s Filter feature to scan a column for # sign errors
To recall how to improve the odds of Excel creating a backup copy of your work so you can recover easily from program crashes
To identify which section of the Excel Options dialog box allows you to the Protected View setting

Course Description

Error prompts even while working on a simple spreadsheet are one of the most irritating things, isn't it? We bring here a comprehensive course by eminent Excel Expert David Ringstrom, CPA, explaining the intricacies of Excel and the error prompts and how they can be encountered.

David demonstrates every technique at least twice in this online Excel CPE course: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel and draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Office 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Major topics covered in this course:

History Worksheet Name
Transpose Data
Types of Formula Errors
Evolution of Worksheet Function
Error Checking Command
SUMPRODUCT / ISERROR
Circular References
Data Security Prompts
Protected View
How to remove unnecessary Add-Ins

Overview

History Worksheet Name

2 mins
Transpose Data

22 mins
Types of Formula Errors

29 mins
Worksheet Function Evolution

33 mins
Error Checking Command

35 mins
SUMPRODUCT/ISERROR

50 mins
Circular References

72 mins
Data Security Prompts

87 mins
Protected View

90 mins
Remove Unnecessary Add-Ins

102 mins

Webinar Qualifies For

2 CPE Credit of Computer Software and Applications for Certified Public Accountants (CPA-US)
2 General Credit of Computer Software and Applications for Accountant/Bookkeeper/Tax Professionals
2 CPD Credit of Computer Software and Applications for CPA in Canada
2 CPE Credit of Computer Software and Applications for Certified Fraud Examiner (CFE)
2 CPD Credit for Association of Chartered Certified Accountants (ACCA)
2 CPE Credit of Information Technology for Certified Government Financial Manager (CGFM)
2 CPD Credit for Chartered Accountant - ICAEW
2 CE Credit of Information Technology (inc. Excel) for Certified FP&A Professional (FP&A)
2 CPD Credit for Chartered Accountants - Scotland
2 CPE Credit of Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA)
2 CPD Credit for Chartered Accountants - Ireland (CAI)
2 CPD Credit for CPA - Ireland
2 CPE Credit of Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA)
2 CPE Credit of Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA)

About Instructor

David Ringstrom, CPA (US)

President, EXCEL Accountant

I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:

Microsoft Excel
Microsoft Access
Sage 50/Peachtree Accounting
QuickBooks

Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:

National Association of Certified Valuators and Analysts
Institute of Real Estate Managers
Georgia Society of CPAs
South Carolina Society of CPAs
Georgia Government Finance Officers Association
Atlanta chapter, American Society of Women CPAs
Perimeter Chapter, Georgia Society of CPAs

I teach over 200 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.

I am the co-author of Idiot's Guide to Introductory Accounting. I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.

I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and more.

Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting

Additional Information

Duration

2 Hours

Course Level

Basic

Instructional Method

QAS Self Study

Pre-requisites

None

Advance Preparation

None

FAQ’s

Click Here to View

NASBA APPROVED

MY-CPE LLC, 1600 Highway 6 south, suite 250, sugar land, TX, 77478

MY-CPE LLC (Sponsor Id#: 143597) 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.

Ratings and Review

4.5

Excellent

Very Good

Average

Poor

Terrible

John Ouellette, CPA (US)

The self-study functionality is great with two kids under two years old. I like these Excel course because of how they promote learning by showing step by step screenshots and an actual example within the program.