Популярное

Музыка Кино и Анимация Автомобили Животные Спорт Путешествия Игры Юмор

Интересные видео

2025 Сериалы Трейлеры Новости Как сделать Видеоуроки Diy своими руками

Топ запросов

смотреть а4 schoolboy runaway турецкий сериал смотреть мультфильмы эдисон
dTub
Скачать

How to Create a Dependent Drop Down List in Excel (Step-by-Step Tutorial)

Автор: Kevin Stratvert

Загружено: 2024-06-13

Просмотров: 335056

Описание:

In this step-by-step tutorial, learn how to create dependent dropdown lists in Excel. This feature allows you to select a value in one dropdown list that influences the available options in subsequent dropdown lists. It's an incredibly useful tool for creating dynamic and interactive forms, and I'll show you just how easy it is to set up.

In this tutorial, we'll create an order form for the Kevin Cookie Company, where the items in one dropdown list will filter the options available in another. For instance, if a customer selects "cookie," they'll see all our delicious cookie options, and if they choose "drink," they'll see all our refreshing drink options. We'll also set up additional dropdowns for more specific selections, like coffee types or smoothie flavors.

What You'll Learn:
How to create named ranges in Excel.
Setting up the first dropdown list.
Creating dependent dropdown lists using the INDIRECT function.
Troubleshooting common issues with named ranges.
Making your forms more dynamic and user-friendly.

Host: Kevin Stratvert

📚 RESOURCES
Workbook Download: Follow along with the exact same workbook I'm using by downloading it here: https://1drv.ms/x/s!AmxrofZZlZ-whdt5C...

⌚ TIMESTAMPS
00:00 Introduction
00:19 Download the workbook
00:31 Background
01:07 Set up a named range
02:57 Set up first dropdown list
04:22 Create dependent dropdown lists
09:04 Troubleshoot named ranges
10:29 Testing the Dropdowns
10:49 Copy dropdowns to multiple rows
11:24 Wrap up

📺 RELATED VIDEOS
Playlist with all my videos on Excel:    • ❎ How to use Excel  

📩 NEWSLETTER
Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
Official website: http://www.kevinstratvert.com
LinkedIn:   / kevinstratvert  
Discord: https://bit.ly/KevinStratvertDiscord
Twitter:   / kevstrat  
Facebook:   / kevin-stratvert-101912218227818  
TikTok:   / kevinstratvert  
Instagram:   / kevinstratvert  

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 📹 CapCut | https://bit.ly/installcapcut
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?...

🙌 SUPPORT THE CHANNEL
Hit the THANKS button in any video!
Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #excel

How to Create a Dependent Drop Down List in Excel (Step-by-Step Tutorial)

Поделиться в:

Доступные форматы для скачивания:

Скачать видео mp4

  • Информация по загрузке:

Скачать аудио mp3

Похожие видео

array(10) { [0]=> object(stdClass)#7313 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "vh2jdOQ5VLs" ["related_video_title"]=> string(42) "Dependent Drop Down List in Excel Tutorial" ["posted_time"]=> string(21) "3 года назад" ["channelName"]=> string(15) "Kevin Stratvert" } [1]=> object(stdClass)#7286 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "Pz4iCvr3gHc" ["related_video_title"]=> string(62) "How to Create a Barcode in Excel – Step-by-Step Tutorial" ["posted_time"]=> string(28) "11 месяцев назад" ["channelName"]=> string(15) "Kevin Stratvert" } [2]=> object(stdClass)#7311 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "CaD4-5UAK0I" ["related_video_title"]=> string(55) "How to Create a Drop-Down List in Excel (2025 Tutorial)" ["posted_time"]=> string(25) "4 месяца назад" ["channelName"]=> string(15) "Kevin Stratvert" } [3]=> object(stdClass)#7318 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "F92BOYiJF4o" ["related_video_title"]=> string(77) "Creating Multi-Level Dependent Drop Down Lists in Excel - New and Better Way!" ["posted_time"]=> string(27) "6 месяцев назад" ["channelName"]=> string(10) "TrumpExcel" } [4]=> object(stdClass)#7297 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "nn36TcVt-QU" ["related_video_title"]=> string(64) "How to Select Multiple Items in Excel Drop-Down (No Duplicates!)" ["posted_time"]=> string(25) "3 недели назад" ["channelName"]=> string(19) "Easy Click Learning" } [5]=> object(stdClass)#7315 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "h3RFPALHcOc" ["related_video_title"]=> string(115) "8 инструментов в Excel, которыми каждый должен уметь пользоваться" ["posted_time"]=> string(21) "3 года назад" ["channelName"]=> string(47) "Билял Хасенов – Excel, VBA & More" } [6]=> object(stdClass)#7310 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "a3-nkc_VUF0" ["related_video_title"]=> string(123) "Эти ОШИБКИ совершает КАЖДЫЙ новичок в Excel. Избавься от них НАВСЕГДА!" ["posted_time"]=> string(21) "8 дней назад" ["channelName"]=> string(54) "Эксперт ЭКСЕЛЬ и ГУГЛ-ТАБЛИЦЫ" } [7]=> object(stdClass)#7320 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "y0-l54dm-uc" ["related_video_title"]=> string(109) "Функция ВПР в Excel ➤ Как пользоваться функцией ВПР (VLOOKUP) в Excel" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> string(23) "Андрей Сухов" } [8]=> object(stdClass)#7296 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "s5Q3I5JvzzI" ["related_video_title"]=> string(96) "Dependent Drop Down list in excel | Dependent dropdown list using Indirect formula in excel (CC)" ["posted_time"]=> string(19) "5 лет назад" ["channelName"]=> string(20) "Computer Gyan Guruji" } [9]=> object(stdClass)#7314 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "qABzZRI4mEY" ["related_video_title"]=> string(73) "How to Make an Automated Data Entry Form in Excel (Step-by-Step Tutorial)" ["posted_time"]=> string(25) "4 месяца назад" ["channelName"]=> string(15) "Kevin Stratvert" } }
Dependent Drop Down List in Excel Tutorial

Dependent Drop Down List in Excel Tutorial

How to Create a Barcode in Excel – Step-by-Step Tutorial

How to Create a Barcode in Excel – Step-by-Step Tutorial

How to Create a Drop-Down List in Excel (2025 Tutorial)

How to Create a Drop-Down List in Excel (2025 Tutorial)

Creating Multi-Level Dependent Drop Down Lists in Excel - New and Better Way!

Creating Multi-Level Dependent Drop Down Lists in Excel - New and Better Way!

How to Select Multiple Items in Excel Drop-Down (No Duplicates!)

How to Select Multiple Items in Excel Drop-Down (No Duplicates!)

8 инструментов в Excel, которыми каждый должен уметь пользоваться

8 инструментов в Excel, которыми каждый должен уметь пользоваться

Эти ОШИБКИ совершает КАЖДЫЙ новичок в Excel. Избавься от них НАВСЕГДА!

Эти ОШИБКИ совершает КАЖДЫЙ новичок в Excel. Избавься от них НАВСЕГДА!

Функция ВПР в Excel ➤ Как пользоваться функцией ВПР (VLOOKUP) в Excel

Функция ВПР в Excel ➤ Как пользоваться функцией ВПР (VLOOKUP) в Excel

Dependent Drop Down list in excel | Dependent dropdown list using Indirect formula in excel (CC)

Dependent Drop Down list in excel | Dependent dropdown list using Indirect formula in excel (CC)

How to Make an Automated Data Entry Form in Excel (Step-by-Step Tutorial)

How to Make an Automated Data Entry Form in Excel (Step-by-Step Tutorial)

© 2025 dtub. Все права защищены.



  • Контакты
  • О нас
  • Политика конфиденциальности



Контакты для правообладателей: [email protected]