From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using validation tools

Using validation tools

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using validation tools

“

- Excel's data validation feature is different than a lot of other data management features in that it's mostly about data before it goes into a worksheet, not after. And we're looking at a sheet called DataValidation in our workbook called 12 Data Management Features. Let's imagine we're about to create a list here, we've got an ID number, Compensation, Status, Department, the ID numbers must be six characters, they might be all numbers, they could be all letters, they could be a combination of either. Let's say it's a combination of letter and numbers in our example here, let's select column A. Before using the data validation feature, highlight the cells where you want the rule to be in place. These are referred to as data validation rules. We go to the data tab in the ribbon and we have a choice called Data Validation. "Pick from a list of rules to limit the type "of data that can be entered in a cell". We're controlling data before it goes into a list. The Data Validation dialog…

Contents