Excel 2016: Data Validation in Depth

Description

In this course, you will :

• Explore how to use the data validation tools in Excel 2016 to create dropdown lists and control numeric, text, date, and time entries.
• You can control how users enter data into workbooks using Excel's data validation tools, ensuring that data is consistent and accurate.
• You can control the dates, times, and even the length of the text they enter, or you can simply provide a list of acceptable options to eliminate any potential errors.

Syllabus :

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

Show more