How to use Excel Data Validation to protect cells
Excel's Data Validation is one of the more underutilised and understated features in Microsoft's spreadsheet application. Surprisingly, it is underemployed even by many expert Excel and financial model users, as a means to restrict data inputs into cells and improve the viability of a financial spreadsheet.
Quite simply it is a great, VBA macro-free tool, in which to improve the internal controls and corporate governance surrounding the management of a financial model.
Read more at http://strategizefm.com/excel-data-va...
Watch video How to use Excel Data Validation to protect cells online without registration, duration hours minute second in high quality. This video was added by user Strategize Financial Modelling 13 March 2014, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,515 once and liked it 16 people.