Data Validation - Digital Bytes

This bite-sized session will show you how to take control of your spreadsheets with smart, user-friendly data validation techniques. Whether you're creating dropdowns, limiting inputs, or guiding users with helpful messages, this session will help you build cleaner, more reliable data entry sheets.

We'll look beyond just lists - diving into multiple types of validation rules, including numbers, dates, text length, and custom formulas. And yes, we’ll also explore the magic of dynamic data validation using the UNIQUE function so your dropdowns update automatically as your data changes.

Here’s what we’ll cover:
✅ How to set up and customise validation rules (lists, numbers, text length, dates)
✅ Creating input and error messages to guide users and reduce mistakes
✅ Using the UNIQUE function to build dynamic, self-updating dropdowns
✅ Managing data validation inside Excel Tables
✅ Circling invalid data so you can easily identify rogue cells.

If you've ever struggled with inconsistent data, typos, or users 'going rogue' with inputs - this session is for you. We’ll work through clear, practical examples together so you can see exactly how it works in action. This one is not to be missed!