Excel 2016: Data Validation in Depth
Excel 2016: Data Validation in Depth
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 1h 34m | 251 MB
Instructor: Dennis Taylor
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 1h 34m | 251 MB
Instructor: Dennis Taylor
With Excel's data validation tools, you can control how users enter data into workbooks, ensuring that data is consistent and accurate. You can control dates, times, even the length of the text they enter, or simply provide a list of acceptable choices to eliminate any possible mistakes. Here, Dennis Taylor explores how the data validation tools in Excel 2016 can be used to set dropdown lists and control numeric, text, date, and time entries.
Learning objectives
- Explain the difference between an error alert and an input message.
- Apply drop-down lists to save time and ensure consistency.
- Explore different ways to manage data with multitiered lists.
- Name the function that allows the placement of multiple restrictions within the same data validation.
- Review the steps necessary to create time limitations.
Excel 2016: Data Validation in Depth
