Excel errors can be stressful, confusing, and difficult to solve on your own. In this course, you’ll learn some of the reasons why errors are encountered and how to quickly and confidently solve them.
Publication Date: August 2018
Designed For
Practitioners seeking to use Excel more effectively by understanding and mitigating Excel error prompts.
Topics Covered
- Understanding how to manage the Protected View prompt in Excel 2010 and later.
- Identifying the various # sign errors Excel formulas can return.
- Making sense of the Enable Content prompt related to macros in Excel.
- Using range names to streamline formulas and bookmark key inputs within a workbook.
- Updating perpetually licensed versions of Excel by way of service packs.
- Utilizing the Error Checking command to locate cells that contain errors within a worksheet.
- Learning what steps to take if you can't open a damaged workbook.
- Discovering how to avoid wasting time when saving workbooks as .XLS files by dispatching the Compatibility Checker.
- Using a simple macro to eliminate redundant prompts that appear when you save a file in text or .CSV format.
- Understanding how to launch Excel in Safe Mode to troubleshoot Excel issues.
- Mastering the IFERROR function to display alternate values in lieu of a # sign error.
Learning Objectives
- Identify the worksheet function that eliminates extraneous spaces from text within a worksheet.
- Recall which versions of Excel offer the FORMULATEXT function.
- Identify which section of the Excel Options dialog box that allows you to manage the Protected View setting.
Level
Basic
Instructional Method
Self-Study
NASBA Field of Study
Computer Software & Applications (2 hours)
Program Prerequisites
None
Advance Preparation
None
Instructor
David H. Ringstrom
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches over 200 webinars each year. His Excel courses are based on over 30 years of consulting and teaching experience. David’s catchphrase is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. He's currently writing a book titled "Exploring Excel's Hidden Treasures". To learn more about David, you can view his
LinkedIn profile and follow him on
Facebook or
Twitter (@excelwriter).