Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)

Data is everywhere! Enhance your career and acquire new skills by taking a course on DataCamp! Click here to take the first chapter of any course for FREE: https://bit.ly/3e03pKO (you’ll be supporting my channel too!)

Drop Down Lists in Excel - Masterclass

This Excel Masterclass teaches the full range of drop down list techniques in Excel. It starts with the fundamentals about drop down lists in Excel and continues with more advanced concepts like dynamic drop down lists and conditional formatting with drop down lists.The second half of this Excel Masterclass teaches how to master the three most advanced drop down list techniques: Data extraction with Vlookup and drop down lists, multi-level dependent drop down lists, and searchable drop down lists.

Masterclass Outline

1. Drop Down List Fundamentals
2. Dynamic Drop Down Lists
3. Conditional Formatting with Drop Down Lists
4. Vlookup with Drop Down Lists
5. Multi-level Dependent Drop Down Lists
6. Searchable Drop Down Lists (for all Excel versions!)

Excel Functions Insights
OFFSET ► http://excelfind.com/excel-functions/excel-offset-function

🚀🚀🚀 Best Excel and PowerPoint Resources 🚀🚀🚀
My Excel Resources ► http://excelfind.com
My PowerPoint Resources ► https://slidefind.com

This video was sponsored by DataCamp

#excel #dropdownlists #masterclass

Видео Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists) канала The Office Lab