Excel for Beginners: Easy Steps to Get Started - Quickly Create Multiple Dependent Drop-Down Lists in Microsoft Excel

5.0 (3)

22 learners

What you'll learn

This course includes

14.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

data validation drop down list excel Quickly Create a Multiple Dependent Drop-Down Lists in Microsoft Excel dependent drop down list in excel multiple dependent drop-down list in excel indirect function excel drop down list in excel with multiple selections teacher's tech tutorials jamie keet named ranges in excel microsoft excel tutorial for beginners

Full Transcript

In this video tutorial, I will show you how to create multiple dependent drop-down lists in Microsoft Excel. Using data validation and the INDIRECT function in Microsoft Excel allows you to create drop-down lists from named ranges. This makes a simple and quick way to make a dependent drop-down list but it’s not without limitations. I will go over these issues and explain why you may not want to use this method for dependent drop-down lists. Excel Practice Sheet: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERTMA9dpMd1JsRtAiZb7nxYBgNq3C7sx96psF_rCn3vZrw?e=5qF8ud More Excel Function Tutorials: https://youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

30-Day Beginner Guitar Challenge for New Players

Master the Guitar in 30 Days: Your Ultimate Beginner Challenge! Unleash your inner guitarist with step-by-step lessons designed to transform you from novice to confident player. Join Your Guitar Academy and kickstart your musical journey today!

⭐ 4.3

36 ratings

7 hours