Bottom Line: This Excel Masterclass teaches the full range of drop down list techniques in Excel, from the fundamentals up to searchable drop down lists.
Skill Level: Beginner to Advanced
Video Tutorial
Drop down lists are a powerful Excel feature that can add a lot of value to your worksheets if you know how to use them correctly. This masterclass explains all the fundamentals you need to understand drop down lists and get started with simple static drop down lists. After that, more advanced topics are explained step-by-step: Dynamic drop down lists, conditional formatting with drop down lists, lookup functions with drop down lists, dependent drop down lists, and searchable drop down lists.