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-800-223-8720
Live Webinar
60 minutes
Event Description
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

At the Q&A session following the live event, ask a question and get a direct response from our expert speaker.

About Our Speaker(s)

David Ringstrom, Excel ExpertDavid 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:
  •  
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Excel Know-How: Creating Error-Proof Spreadsheets
    Presenter(s): David Ringstrom, CPA

 
DMCA.com Protection Status