Creating Cascading Dynamic Drop Downs in Excel | Everyday Office 044

Can we build a drop-down sequence where one depends on another? With cascading drop-down menus, the selection you make in the first chooses the menu of options for the second. Additionally, if you create these lists as Tables, the references are dynamic, constantly growing and shrinking as you make changes. In this video tutorial, Neil Malek from Knack Training demonstrates how to use dynamic named ranges from Excel Tables, along with the INDIRECT function, to create a sequence of cascading drop-down menus.

Music: "solarplex" by Birocratic
http://birocreatic.lnk.to/allYL

Knack Training is a software and professional development training company from Orlando, FL. Neil Malek, principal at Knack Training, records software tutorials everyday through the series Everyday Office.

Knack Training is recording their entire library to provide lifetime value through KnackCourses.com - soup-to-nuts training in Excel, Outlook, and more.

Subscribe to my channel here: https://www.youtube.com/subscription_...

Subscribe to the quarterly tutorial ezine: http://knacktraining.com

http://knacktraining.com
http://knackcourses.com
Facebook: knacktraining
Twitter: neilmalek
Instagram: neilmalek

• #education
• #microsoft_excel_tutorial
• #excel_cascading_drop_down_menus
• #cascading_drop_down_tutorial
• #dynamic_named_ranges
• #dynamic_drop_down_menus_in_excel
• #cascading_dynamic_named_range_drop_down_menus