Excel Data Validation & Drop-Down Lists | Beginner Tutorial

This lesson shows you how to use Data Validation in Excel to control what users can enter into a spreadsheet and help keep your data accurate. You’ll learn how to create validation rules, add helpful input messages and error alerts, build drop-down lists, and remove validation when it’s no longer needed. In this lesson we cover: • What Data Validation is • Setting up Data Validation • Input messages and error alerts • Creating drop-down lists • Removing Data Validation • Practice activity and answers 📥 Download the Excel practice file: https://1drv.ms/x/c/826cb64d3a87ec14/... This video is part of my Excel for Beginners course. 📘 Full Excel for Beginners course:    • Microsoft Excel for Beginners – Full Free ...   ➡️ Next lesson: Using Pivot Tables    • Excel Pivot Tables for Beginners | Create,...