.png)
Microsoft Excel: Data Validation
in Microsoft Excel EssentialsWhat you will learn?
Apply drop-down lists to save time and ensure consistency.
Create numeric, date and decimal number restrictions
How to customize error alerts and input messages
How to use formulas to prevent duplicate entries
About this course
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.
In this course, we will explore how the data validation tools in Excel can be used to set dropdown lists and control numeric, text, date, and avoid duplicate entries.
Comments (0)
Download the data used in the video to follow along and practice on your own.
.png){kind=small}
.png){kind=small}
.png)