My Shopping Cart
There are no items in your shopping cart.

Excel Know-How: Creating Error-Proof Spreadsheets (IME672L)

Presented by: David Ringstrom, CPA
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
60 minutes
Event Description
See the sneak peek before you buy!
1.0 CPE

Learn tricks and techniques to improve the integrity of your Excel spreadsheets

Microsoft Excel is an electronic spreadsheet. As with a paper spreadsheet, you can use Excel to organize your data into rows and columns and to perform mathematical calculations. Spreadsheets can be simple and complex at the same time. Depending on the needs of different individuals, there are some basic tasks that you can combine to create a robust spreadsheet that you require.

When you participate in this invaluable webcast presented by David Ringstrom, CPA, you’ll learn a variety of tricks and techniques you can implement to improve the integrity of your Excel spreadsheets as well as audit the spreadsheets created by others. Among other topics, David explains simple ways to prevent errors from being introduced into your Excel workbooks.

Session Highlights:

In this webcast, David will teach you how to:

  • Improve the integrity of your spreadsheets
  • Audit spreadsheets created by others
  • Apply Data Validation in order to document input cells and enforce data integrity
  • Hide and unhide multiple worksheets with a single command
  • Use free, prebuilt templates in Excel to get a jump start on spreadsheet projects
  • Use Conditional Formatting to identify unlocked cells into which data can be entered

Key Takeaways:

  • Demonstration of every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016
  • Get demonstration of techniques in a specific version of Excel upon request
  • David’s detailed handouts, with numbered steps, serve as reference tools participants can fall back on after participating in the webcast
  • Get an Excel workbook that includes a majority of the examples used during the session
  • How to use Conditional Formatting to color-code your data, identify duplicates, and apply icons
  • Discover techniques that automatically provide fallback positions in the event you need to see an earlier version of your spreadsheet
  • Use Conditional Formatting to identify unlocked cells into which data can be entered
  • Toggling the Locked status of a worksheet cell on or off by way of a custom shortcut
  • Learn a simple design technique that will greatly improve the integrity of Excel’s SUM function
  • Compare IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions
  • Get a jump start on spreadsheet projects by using free, prebuilt templates in Excel
  • Summing disparate sections of a spreadsheet quickly with the SUBTOTAL function
  • Preserve key formulas using hide and protect features

Who Should Attend?

  • Accountants
  • CPAs
  • CFOs
  • Controllers
  • Excel User
  • Income Tax Preparers
  • Enrolled Agents
  • Financial Consultants
  • IT Professionals
  • Auditors
  • Human Resource Personnel
  • Bookkeepers
  • Marketers
  • Government Personnel
About Our Speaker(s)

David Ringstrom | Microsoft Excel Courses  SpeakerDavid Ringstrom CPA
David H. Ringstrom, CPA, 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 shou... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Excel Know-How: Creating Error-Proof Spreadsheets
    Presenter(s): David Ringstrom, CPA

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team