Overview
-
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.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- Whole number vs decimal limitations
- Using the Input Message box
- Using the Error Alert tab
- Creating drop-down lists
- List location and order
- Multitiered lists
- Date limitations with basic controls
- Date limitations using formulas
- Time limitations with basic controls
- Time limitations using formulas
- Text length limitations with basic controls
- Text length limitations using formulas
- Requiring entries to be unique
- Locating cells with data validation rules
- Identifying cells that violate data validation rules
- Data validation shortcomings
- Goodbye
