Excel Power Tips: Useful Techniques for Excel Lists, Drop Downs and Data Validation
// Recommended Excel Courses //
1. Launch Excel Macros & VBA School: https://go.launchexcel.com/macros-vba...
2. Excel Campus Elevate Program: https://go.launchexcel.com/excel-camp...
3. My Online Training Hub Dashboards: https://go.launchexcel.com/moth-dashb...
4. Coursera Excel Specialisation: https://go.launchexcel.com/coursera-e...
5. Coursera Everyday Excel: https://go.launchexcel.com/coursera-e...
6. Coursera Excel Data Visualisation: https://go.launchexcel.com/coursera-d...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
https://go.launchexcel.com/simple-she...
// Show Notes //
In this 20 minute episode we'll look at lists, drop downs and data validation. These are very important areas of Excel that you should master if you want to take your Excel skills to the next level.
Read the accompanying article and download the sample workbook at www.launchexcel.com:
http://www.launchexcel.com/excel-drop...
Video Highlights:
-- Excel Built-in Lists --
0:10 Excel's Built-in Lists (Days of week, Months of year)
-- Excel Custom Lists --
1:06 Three use cases for Custom Lists
3:57 How to create a Custom List (instructions for Excel 2010)
-- Dependent Drop-down Lists (Country, City) --
5:08 Drop Downs for Data Entry
6:47 How to create Dependent Drop Downs with Data Validation and Named Ranges
9:38 TIP: How to define multiple Named Ranges
10:02 The "Slow" Way using the Name Manager
11:24 The "Fast" Way using CTRL + SHIFT + F3
14:09 Why do we need "Helper" columns?
-- Data Validation (E-mail, Date of Birth) --
15:40 Data Validation of Email addresses
18:20 Data Validation of Date of Birth (you must be at least 15 years old)
19:48 Warning: Data validation can be easily overwritten by Copy ➜ Paste and what to do about this