How to Improve Your Excel Spreadsheets With Data Validation

In: BlogDate: Sep 30, 2019By: Claire Lickman

Have you ever seen an Excel spreadsheet with a dropdown list in it and wondered how it was done? In this two-minute video, Nicky shows you how to set up a Data Validation dropdown list.

Hi, we are Happy

We are leading a movement to create happy, empowered and productive workplaces.

How can we help you and your people to find joy in at least 80% of your work?

More about Happy

Improve Your Excel Spreadsheets With Data Validation


Data Validation improves the data in your spreadsheets. It makes reporting much easier as there is no risk of typos and no risk of an entry not fitting into your criteria. How could you use Data Validation to improve the data in your spreadsheets?

Claire Lickman

Claire is Digital Marketing Coordinator at Happy. She has worked at Happy since 2016, and is responsible for Happy's marketing strategy, website, social media and more. Claire first heard about Happy in 2012 when she attended a mix of IT and personal development courses. These courses were life-changing and she has been a fan of Happy ever since.

More by Claire

Improve your productivity in Excel with happy

Happy has high-quality, learner-focused Excel training courses for all skill levels, designed to improve your confidence and productivity.

Our learners tell us that they save an average of 32 minutes a day with our Excel training courses. How much time could you save with us?

Learn more about Happy's Excel courses