Conversation between Manager and Executive
Executive: Team members are filling data in irregular formatting
Manager: So you must have tough time create the report
Executive: Yes L
Manager: So why don’t you use Data Validation to restrict your user for filling irregular data. Read the section below to know more on this…
Data validation in Excel helps you to restrict others to enter the value in the way you want them to enter. For example, you want that the user should only fill value from 1 to 100. If the user fills a value more than 100 then Data validation will restrict the user to fill the same. Simultaneously you can restrict user to update date as per the format you have decided. You can even allow “custom” in the data validation option by including some kind of formulas in it.
Youtube Video Teaching - Data Validation List
Youtube Video Teaching - Data Validation List
For more details you can buy my ebook available in Amazon
Only @ Rs.139/-
Visit Other MS Excel Tips and Tricks
Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
-----------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316
https://www.facebook.com/Samrat.Biswas
