Excel 2016: Data Validation in Depth

Learn how to use the data validation tools in Excel 2016 to control how users input data into workbooks and ensure data is entered consistently and accurately.

Introduction

• Welcome
• Using the exercise files

1. Controlling the Limits of Numeric Data

• Whole number vs decimal limitations
• Using the Input Message box
• Using the Error Alert tab

2. Setting Up Drop-Down Lists

• Creating drop-down lists
• List location and order
• Multitiered lists

3. Date Controls

• Date limitations with basic controls
• Date limitations using formulas

4. Time Controls

• Time limitations with basic controls
• Time limitations using formulas

5. Text Length Controls

• Text length limitations with basic controls
• Text length limitations using formulas

6. Specialized Custom Formula Controls

• Requiring entries to be unique
• Locating cells with data validation rules
• Identifying cells that violate data validation rules
• Data validation shortcomings

Conclusion

• Goodbye