How to create 3-level cascading drop-down lists in Excel?
ฝัง
- เผยแพร่เมื่อ 6 ก.ย. 2024
- 🚨 ALL INFORMATION IN DESCRIPTION (CLICK ON "MORE") 🚨
#TutoExcel #Excel #MSExcel
🔴 To access the Master Club Excel, go here: www.votreassis...
🙋 Join the Votre Assistante Facebook group to share tips and tricks around #Word, #Excel, #Access, #PowerPoint, #VBA, #Photoshop and #Illustrator software: / votreassistante
⚠️ To better view the video, I advise you to set the quality of the video to HD by clicking on the toothed wheel (↓ at the bottom right → of the video). ⚠️
📢 To be informed of the publication of the next articles, subscribe to the newsletter and receive the checklist to design a powerful dashboard on Excel: formations.vot...
🚨 Subscribe to the channel by clicking on Subscribe (just above ↑) then on the 🔔 next to not miss any video 😉
Tutorial made with Excel Microsoft 365
Video tutorial to learn how to create 3-level cascading drop-down lists in Excel. How to create a filtered list in Excel?
🔗 To access the text version of this tutorial, go to Votre Assistante: www.votreassis...
☑️ Useful links:
- www.votreassis...
- www.votreassis...
- www.votreassis...
- www.votreassis...
- formations.vot...
📖 Summary:
00:00 Introduction
01:30 1. Presentation of the data used
02:35 2. Naming cell ranges
04:33 3. Creating cascading drop-down lists in Excel - 3.1. Creation of the drop-down list for continents
05:18 3.2. Creation of the drop-down list for countries
06:37 3.3. Creation of the drop-down list for cities
07:30 4. Case of list items with dashes or spaces
11:12 5. Case of an omitted previous choice
11:47 5.1. Creating drop-down list items
12:33 5.2. Editing cascading drop-down list formulas
16:16 6. Update of the data feeding the lists
🚀 To go further, join the Excel Master Club and become an expert on Excel formulas: www.votreassis...
🚀 To go further, find out how to get started on Excel from scratch: www.votreassis...
🚀 To go further, discover the application Gérez vos devis et factures avec Excel (with or without stock): www.votreassis... or www.votreassis...