Instructor for this course
more

It's always frustrating to have your work interrupted by error prompts while working in Excel. In this presentation, Excel expert David Ringstrom, CPA, dives deep into the nuances of Excel to explain frequently encountered error prompts, as well as what to do to recover from or mitigate errors that trigger prompts.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 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.

Topics covered:

  • Removing memory-consuming add-ins that can compromise Excel.
  • Using range names to streamline formulas and bookmark key inputs within a workbook.
  • Utilizing the Error Checking command to locate cells that contain errors within a worksheet.
  • Learning the nuances of circular references in Excel.
  • Diagnosing formula errors, such as #VALUE!, #REF!, #N/A, and others.
  • Resolving the issue that prevents you from being able to insert rows or columns.
  • Learning the nuances of circular references in Excel.
  • Understanding how to launch Excel in Safe Mode to troubleshoot Excel issues.
  • Updating perpetually licensed versions of Excel by way of service packs.
  • Mastering the IFERROR function to display alternate values in lieu of a # sign error.
  • Understanding how to manage the Protected View prompt in Excel 2010 and later.
  • Identifying the various # sign errors Excel formulas can return.

Learning Objectives

  • Recognize the location of the menu command that allows you to determine categorically if a workbook contains links or not.
  • Recognize the location of the Enable Iterative Calculations setting within the Excel Options dialog box.
  • Identify which section of the Excel Options dialog box that allows you to manage the Protected View setting.
Last updated/reviewed: November 11, 2019

7 Reviews (19 ratings)Reviews

5
Member's Profile
Great review course on Error Prompts. Error handling is an important tool when tracking your formulas, and this course did a great job explaining best practices.
5
Anonymous Author
Great course. One thing that sets this instructor apart from the others is the supporting materials. Very thorough.
5
Anonymous Author
This is a very pragmatic Excel course. Much helpful information that is usable on a daily basis.
5
Member's Profile
Helpful information on those pesky error messages that we tend to live with rather than fix.
5
Anonymous Author
Explores how to correct Excel error messages and how to avoid them in the first place.
5
Member's Profile
Great job and thank you for the help on CPE. I learned a lot of excel tips.
4
Anonymous Author
Great course. Good tips and discussion on the topic.

Prerequisites

Course Complexity: Intermediate

Program Prerequisites: None

Advance Preparation: None

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  7:43Introduction to Excel Efficiency: Error Prompts Explained
  10:11Unable to Insert Rows/Columns
  10:00To Many Different Cell Formats Error
  7:05Types of Formula Errors
  6:25Manage Error Checking Prompts
  9:16Error Checking Command
  8:48Introduction to IFERROR
  5:29Missing Data Triggers #N/A in VLOOKUP
  7:36Extraneous Spaces Triggers #N/A in VLOOKUP Continued..
  10:28Circular References
  9:13Confirming If a File Has Links
  7:53Protected View Settings
  4:39Installing Microsoft Service Packs
CONTINUOUS PLAY
  1:44:44Excel Efficiency: Error Prompts Explained
SUPPORTING MATERIALS
  PDFSlides: Excel Efficiency: Error Prompts Explained
  PDFGlossary/Index: Excel Efficiency: Error Prompts Explained
  XLSXWorkbook: Excel Efficiency: Error Prompts Explained
  CSVFruit - Sales
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM