Learn how to create a drop-down menu in Microsoft Excel, using the Data Validation tool in our two-minute video.
When you create a drop-down menu in a cell, it means that the user can only select one of the options from the menu – they are not able to enter their own data. This is a great way to save time during data entry, minimise the risk of typos and mistakes, as well as ensure that there is no invalid entries. It also makes it much easier to filter and analyse your data. In this two-minute video, Nicky explains how to create your own drop-down menu using Excel’s Data Validation tool.
Want to learn more?
Our Excel Core Level 3 course covers Data Validation as well as more advanced data analysis tools, such as using VLOOKUP and nesting the IF, AND, OR functions (using formulas inside a formula). Links to view the course outline and the upcoming public course dates at Happy's training centre in Aldgate, London, are below:
- Excel 2016 Core Level 3 - 8th April, 23rd April 2019
- Excel 2013 Core Level 3 - Please contact us to arrange booking a course
- Excel 2007/2010 Core Level 3 - 3rd June 2019, 2nd August 2019, 4th October 2019.
We can also hold private group courses just for your organisation at your workplace or at Happy's training centre - just contact our friendly team for details!