Loading...

How To Reduce Spreadsheet Risk in Microsoft Excel [WEBINAR]

351 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

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

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...