Course Content
Getting Started with Microsoft Excel
Getting Started with Microsoft Excel
0/2
Basic Workbook Operations
Basic Workbook Operations
0/2
Formulas and Functions
Formulas and Functions
0/3
Data Analysis Tools
Data Analysis Tools
0/3
Creating Charts and Graphs
Creating Charts and Graphs
0/2
Advanced Excel Features
Advanced Excel Features
0/3
Collaborating and Sharing Workbooks
Collaborating and Sharing Workbooks
0/3
Microsoft Excel Course
About Lesson

Data Validation

  • Setting Data Validation Rules: Select the cells, click ‘Data Validation’ in the Data tab, choose a validation criterion (e.g., whole number, decimal, list), and set the conditions.
  • Creating Drop-Down Lists: Choose ‘List’ as the validation criterion, and enter the list of values.