Uploaded June 2026 | Updated September 2026, 2 weeks ago

---

🔥 Free Copilot Cheat Sheet ➡️ davidpba.myflodesk.com/dcvh5tisb4
🎓 Copilot Masterclass ➡️ learncopilot.ai/masterclass

Dependent drop down lists used to mean messy formulas and helper columns by hand. Not anymore. In this Short I show how to create dependent drop down lists in Excel with Microsoft Copilot — pick a work location in the first dropdown and the second only shows the training that applies. Copilot builds the helper columns, sets up the data validation, and explains exactly what it did. Add a new option and both lists update automatically.

📚 Resources Mentioned in this video

Copilot Essentials Course:
➡️ learncopilot.ai/masterclass

🟩 Copilot Essentials - Training for your organization
➡️ teamtraining.learncopilot.ai

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

📨 Subscribe to Copilot Coffee Break newsletter to stay on top of Copilot tips & tricks: davidpba.myflodesk.com/coffee-break

➡️ Become a channel member to get additional perks: youtube.com/channel/UCEJoO7Zkfv45zIjuALuJLTQ/join

🤝 Work with me
🤖 Copilot Essentials On-Demand Course 👉 learncopilot.ai/masterclass
🔗 Microsoft Copilot Courses for busy professionals 👉 learncopilot.ai
💼 LinkedIn 👉 linkedin.com/in/david-fortin-cpa-816b20b5
📧 Business Inquiry 👉 davidfortincpa@davidpba.com

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Corporate Training, want to train your whole team on the Microsoft Copilot Topic?
🟩 teamtraining.learncopilot.ai

#DependentDropDownLists #CopilotInExcel #ExcelCopilot