In this valuable session, Excel expert David Ringstrom, CPA, shows you how to implement internal control features within your Excel spreadsheets. Using a simple invoice form as a teaching aid, David demonstrates several ways you can control users’ actions within your spreadsheets and protect worksheets and workbooks from unauthorized changes. David explains the benefits of using the VLOOKUP function, the Data Validation feature, the Conditional Formatting feature, and more.
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.