Microsoft Excel: Data Validationin Microsoft Excel Essentials
What 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.