Internal Control Techniques for Microsoft Excel Spreadsheets
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com
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@onlinecompliancepanel.com
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@onlinecompliancepanel.com
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@onlinecompliancepanel.com
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@onlinecompliancepanel.com
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 Q&A 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@onlinecompliancepanel.com
Get Connected With Us:
www.onlinecompliancepanel.com
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com