Create a semi-automatic Excel drop-down list
🚨 ALL THE INFO IN THE DESCRIPTION (CLICK "show more") 🚨
#ExcelTutorial #Excel #MSExcel
🙋 Join the Your Assistant Facebook group to share tips and tricks about #Word, #Excel, #Access, #PowerPoint, #VBA, #Photoshop, and #Illustrator: / votreassistante
⚠️ For better video quality, I recommend setting the video to HD by clicking the gear icon (bottom right of the video). ⚠️
📢 To be notified when new articles are published, subscribe to the newsletter and receive the checklist for designing a high-performing dashboard in Excel: https://formations.votreassistante.ne...
🚨 Subscribe to the channel by clicking "Subscribe" (just above ↑) and then the bell icon 🔔 next to it so you don't miss any videos 😉
Tutorial created with Excel 2013
Video tutorial to learn how to create a semi-automatic drop-down list in Excel. Use the OFFSET, COUNTA, COUNTIF, and IF formulas in Excel. How to manage names in Excel and how to create a named formula in Excel?
🔗 To access the text version of this tutorial, visit Your Assistant: https://www.votreassistante.net/creer...
☑️ Useful links:
https://www.votreassistante.net/creer...
https://www.votreassistante.net/valid...
https://www.votreassistante.net/creer...
https://www.votreassistante.net/creer...
🚀 To go further, join the Excel Master Club and become an expert on Excel formulas: https://www.votreassistante.net/forma...
🚀 To go further, discover the 7 steps to create pivot tables like a pro in Excel: https://www.votreassistante.net/forma...
🚀 To go further, discover the application Manage your quotes and invoices with Excel (with or without inventory): https://www.votreassistante.net/appli... or https://www.votreassistante.net/appli...