For full functionality of this site it is necessary to enable JavaScript. Here are the instructions how to enable JavaScript in your web browser.

Excel Finesse: Dealing with Error Prompts

David H. Ringstrom, CPA Keynote Speaker at Ijona Skills. He is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David's mantra 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.

Read More

Overview

Excel users often are stopped in their tracks by error prompts they receive while performing seemingly simple actions in their spreadsheets. In this broad-reaching webcast, Excel expert David Ringstrom, CPA, delves into the intricacies of Excel to explain why error prompts can be encountered frequently, as well as what actions........

Why should you attend?

Practitioners seeking to use Microsoft Excel more effectively by understanding and mitigating Excel error 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.

Areas Covered in the Session:

  • Bringing Excel's green error-checking prompts under control by managing the underlying rules.
  • Determining at a glance whether a spreadsheet contains links to other workbooks.
  • Determining if a recent security patch has perhaps compromised your installation of Microsoft Office.
  • Diagnosing formula errors, such as #VALUE!, #REF!, #N/A, and others.
  • Discovering how to resolve the maddening "Too many different cell formats" error.
  • Discovering new worksheet functions available in Excel 2016.
  • Identifying situations where VLOOKUP may return #N/A instead of a value.
  • Identifying the various # sign errors Excel formulas can return.
  • Improving the integrity of spreadsheets with Excel's VLOOKUP function.
  • Improving the stability of Excel by deleting accumulations of temporary files in Windows.
  • Learning what steps to take if you can't open a damaged workbook.
  • Making sense of the Enable Content prompt related to macros in Excel.

Who can Benefit:

  • Accountants
  • CPAs
  • CFOs
  • Controllers
  • Excel User
  • Income Tax Preparers
  • Enrolled Agents
  • Financial Consultants
  • IT Professionals
  • Auditors
  • Human Resource Personnel
  • Bookkeepers
  • Marketers
  • Government Personnel

Webinar Id: ISSEDROO3

Duration: 90 mins

   

Refund Policy

Webinars of David H. Ringstrom
Excel Finesse: Macros
Presenter: David H. Ringstrom

View Anytime
Price: $167
Status: Archived

Excel Finesse: Macros - Part 1
Presenter: David H. Ringstrom

View Anytime
Price: $167
Status: Archived

Webinars of Soft Skills
Boost Your Leadership IQ: How to Successful...
Presenter: Mark Hordes

View Anytime
Price: $167
Status: Archived

Zap! You're a manager: getting off on the r...
Presenter: Rebecca Staton-Reinstein

View Anytime
Price: $167
Status: Archived


top