IMPLEMENT INTERNAL CONTROLS WITHIN YOUR EXCEL SPRE 2017 - Enforcing Internal Controls within Excel Spreadsheets - By Compliance Global Inc

Website http://www.complianceglobal.us/product/700598/DavidRingstrom/enforcing-internal-controls-within-exce | Edit Freely

Category Accountants;Banking and Financial Managers

Deadline: January 04, 2017 | Date: January 04, 2017

Venue/Country: Online, U.S.A

Updated: 2016-11-25 15:40:38 (GMT+9)

Call For Papers - CFP

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: supportcomplianceglobal.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.