Pragmatic Excel: Error Prompts

Do you often get stopped in your tracks by error prompts you receive while performing seemingly simple actions in your spreadsheets? If so, you’ll find this course extremely helpful. Excel expert David Ringstrom, CPA, delves into the intricacies of Excel to explain why error prompts can be ...

On demand, 2 hour(s)

$99 ($199)

()

Register Now


Course Description

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. 

 

Who Would Be Interested in This Course:

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

 

Format:

On-demand webcast

 

Instructional Method:

Self-study

 

Program Prerequisites:

None

 

Advance Preparation:

None

 

 


Course Walkthrough

  • Course: Pragmatic Excel - Error Prompts
  • CPD Quiz: Pragmatic Excel - Error Prompts
  • Slides: Pragmatic Excel - Error Prompts
  • Sample File: Pragmatic Excel - Error Prompts
  • Sample File: Fruit sales
  • Forum - Participant question and answers
  • Feedback / comments
  • CPD Certificate: Pragmatic Excel - Error Prompts

About the Instructor(s)