Excel Tips & Tricks: Data Validation

Excel's Data Validation tool is a great way to maintain data consistency and accuracy in a spreadsheet. As an example, with online ordering, you typically enter an address in a free-form box, but then select a state from a dropdown list of values. Capturing data based on prescribed options helps eliminate erroneous entries (MA vs Mass., Massachusetts, Massachusetts, MS, etc).