200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi
I am studying bookeeping and I have this question that I have been struggling with.
I have to find " formula/function or method to ensure standardisation of input, security and accuracy of data"
I am thinking to ensure standardisation of input is to make sure users use same format, same way of entering dates etc.
Security would be to password protect, lock cells etc.
Accuracy would be to use trace dependants, error checking.
Any ideas would be much appreciated.
Basic features to use for this:
Trace dependents is something that you would do while troubleshooting or building the worksheet and it won't prevent a user from doing anything.
You have three big questions to which, I presume, you would like one easy answer which I can give in two words, "No way!" But I will answer your first question here and, if that satisfies you, I may answer another of your questions in another thread.
To ensure standardisation of input, Excel offers Data Validation. On the ribbon's Data tab, click on Data Validation in the Data Tools menu. There you can set rules, for each cell, which kind of data may be entered, such as a date, or a number (or a range of numbers) or one of a number of words or phrases to choose from etc. When the user enters something wrong an immediate error message is issued while the entry is rejected. You can specify which error message you want to be shown and even an instruction to be displayed before any entry is made.
