Excel 2016: Data Validation in Depth

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