Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Apr 30, 2015
How to reduce spreadsheet risk.
Learn practical steps to reduce risks in Excel once for all in our webinar by Excel course author Simon Hurst!
- Avoid spreadsheets - The importance of design - Personnel issues – The dangers of gurus and macros, the importance of teams and peer review - Basic competence – Ensure all spreadsheet users have at least a minimum set of required skills - Basic formulae – Data and logic, absolute and relative references, - Tables - Functions – Use the right functions and make sure you know how they work [PMT(),VLOOKUP()] - Avoid formulae – Use features and techniques that avoid the need to use formulae - Audit and test – Formula auditing and Inquire. Third party tools