Overview :
Learn from Excel expert David Ringstrom, CPA, how to implement internal control features within your Excel spreadsheets.
David typically teaches from Excel 2016, but he points out any differences in earlier versions of Excel. He’s also happy to demonstrate data validation techniques in a specific version of Excel upon request.
Why Should You Attend :
David’s detailed handouts serve as reference tools you can fall back on after participating in one of his webinars. In addition, he provides an Excel formulas workbook that includes a majority of the examples he uses during this webinar.
Areas Covered in this Webinar :
Compare and contrast IFNA, IFERROR, and ISERROR functions and learn which versions of Excel help support these worksheet functions
Create an in-cell list by way of Excel’s Data Validation feature
Go behind the scenes in a workbook to check for worksheets that can’t be viewed or hidden from Excel’s primary user interface
Improve the integrity of spreadsheets with Excel’s VLOOKUP function
Make it harder for a user to circumvent data validation and easy for you to identify when someone has attempted to do so
Preserve key formulas using the hide and protect features
Toggle the Locked status of an Excel worksheet cell on or off by way of a custom shortcut
Use Conditional Formatting to color code your data, identify duplicates, and apply icons
Learning Objectives :
Apply lookup formulas to find and access data automatically from lists
Apply Excel’s Table feature to future-proof elements of your spreadsheet
Define how to use Excel’s Data Validation feature to restrict data entry to a list of permissible choices
Who Will Benefit :
Accountants
CPAs
CFOs
Financial Consultants
Controllers
Practitioners who wish to learn how to implement internal control features within their Excel spreadsheets in order to prevent unauthorized changes from being made by other users
Level:
Intermediate
For more information, please visit : http://www.complianceglobal.us/product/700598/DavidRingstrom/enforcing-internal-controls-within-excel-spreadsheets/1
Email: support@complianceglobal.us
Toll Free: +1-844-746-4244
Tel: +1-516-900-5515
Speaker Profile :
David 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 webinars to thousands of attendees annually on Excel and other topics. He has written hundreds of freelance articles on spreadsheets, some of which have been published internationally. David's catch phrase is "Either you work Excel or it works you." His goal is to make you a smarter and more effective spreadsheet user.
Comments