Internal Control Techniques for Microsoft Excel Spreadsheets - PowerPoint PPT Presentation

About This Presentation
Title:

Internal Control Techniques for Microsoft Excel Spreadsheets

Description:

Attend this webinar to learn about techniques that allow you to audit Microsoft Excel workbooks. In this session David teaches from Excel 2010 – PowerPoint PPT presentation

Number of Views:40

less

Transcript and Presenter's Notes

Title: Internal Control Techniques for Microsoft Excel Spreadsheets


1
  • Internal Control Techniques for Microsoft Excel
    Spreadsheets

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
2
  • Instructor Profile
  • David H. Ringstrom is a CPA
    and owner of Accounting Advisors, Inc., an
    Atlanta-based spreadsheet consulting firm that he
    started in 1991. David speaks at conferences and
    presents dozens of webinars annually on Excel and
    other topics. He has written numerous articles on
    spreadsheets, some of which have been published
    internationally.
  • He has served as the technical editor for
    other 30 books on accounting software, and is the
    Tech Editor-at-Large for Accounting WEB and Going
    Concern. David offers Excel training and
    consulting services nationwide.

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
3
  • Description
  • In this session Excel expert
    David Ringstrom, CPA shows you how to implement
    internal control features within your Excel
    spreadsheets. David shows various ways to control
    user's actions within an Excel spreadsheet, as
    well as protect worksheets and workbooks from
    unauthorized changes. The presentation will also
    demonstrate techniques that can help
    "future-proof" spreadsheets to minimize
    maintenance when changes are required.
  • In this session David teaches from Excel 2010.
    The techniques shown, work in the same fashion in
    Excel 2007 and 2013, and his handouts include
    alternate instructions for Excel 2003 where
    applicable. 

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
4
  • Objectives of the Presentation
  • Improve the integrity of spreadsheets with
    Excel's VLOOKUP function.
  • Compare and contrast IFNA, IFERROR, and ISERROR,
    and see which versions of Excel support each of
    these worksheet functions.
  • Create an in-cell list by way of Excel's Data
    Validation feature.
  • Restrict users to entering dates within a given
    range, or before/after a given date.
  • Minimize ongoing spreadsheet maintenance with
    Excel's Table feature.
  • Specify a range of whole numbers that a user can
    enter in a worksheet cell.
  • Make it harder for users to circumvent data
    validation, and easily identify when they attempt
    to do so.
  • Toggle the locked status of a worksheet cell on
    or off by way of a custom shortcut.

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
5
  • Why Should you Attend?
  • Attend this webinar to learn about
    techniques that allow you to audit Microsoft
    Excel workbooks. This webinar covers areas such
    as Excel's Data Validation feature, VLOOKUP
    function, Worksheet and Workbook protection,
    Excel's Very Hidden worksheet feature. 
  • Who can Benefit?
  • Accountants
  • Finance specialists
  • CFOs
  • Controllers

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
6
  • Live Session - How it works?
  • Username and Password will be sent to you 24
    hours prior to the webinar
  • Presentation handouts in pdf format will be
    mailed to you
  • Login to the session using the username and
    password provided to you
  • Get answer to your queries through interactive
    QA sessions via chat
  • Get certification of attendance.
  • Recorded Session - How it works?
  • A link will be provided to you upon purchase of
    the recorded session
  • Please click on the link to access the session
  • Presentation handouts in pdf format will be
    mailed to you
  • Get certification of attendance.

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
7
  • Get Connected With Us

www.onlinecompliancepanel.com
www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
Write a Comment
User Comments (0)
About PowerShow.com