You'll not only learn how to control a user's actions, but you'll also learn how to make your spreadsheets as future-proof as possible. You'll also learn techniques that can significantly save you time when making a spreadsheet as "user-proof" as possible.
The session will lead off with a discussion of look-up formulas in Excel. Spreadsheet-based data is often dynamic, so functions such as VLOOKUP help spreadsheet stay resilient and minimize future maintenance. However, VLOOKUP can easily trigger errors such as #N/A or #REF!, so you’ll see how to contain these errors to avoid ripple effects through your entire workbook.
NetZealous - Compliance4All,
161 Mission Falls Lane, Suite 216,
Fremont, CA 94539, USA.
Event Link : http://bit.ly/Spreadsheet-Based-Internal-Controls