DISPOSABLE drop-down lists 🤯 in EXCEL.
👩💻 🤯 This video will change the way you see dropdown lists!
We'll learn how to create dropdown lists where data is automatically removed as it's used. For example, when assigning staff for the day, you won't end up assigning the same employee to two tasks, but rather seeing a list of those who are still available. 😲
✅ 00:00 INTRO
✅ 00:55 Step #1: Applying the COUNTIFS function
✅ 04:04 Step #2: Understanding the FILTER function
✅ 06:30 Step #3: Learning the FILTER function ✅ 10:08 Step #4: Applying the FILTER function to obtain the list of available nurses.
✅ 12:21 Step #5: Creating dynamic dropdown lists.
-----------------------------------------------------------
👀LINKS to the referenced videos:
▶ Video: The FILTER function.
• La NUEVA función FILTRAR de EXCEL (Como la...
▶ Video: Learn to create dropdown lists from scratch to expert in Excel.
• ✅ 5 maneras de crear LISTAS DESPLEGABLES e...
-----------------------------------------------------------
👨💻 If you'd like to download the video file to practice, you can download it at the following link:
https://smartprosoluciones.com/listas...
-----------------------------------------------------------
📒 Would you like to know your current Excel skill level? Take our free test:
https://maraton.smartprosoluciones.co...
-----------------------------------------------------------
✅🚀 MITOS
DO YOU WANT TO BOOST YOUR EXCEL SKILLS 👩🏻💻 👨🏻💻 and STAND OUT FROM THE CROWD OF PROFESSIONALS?
EXCELLENT! Visit my academy's website for more information about my training courses:
https://www.smartprosoluciones.com/
---------------------------------------------------------------------------------------------------------
👨👨👧 LET'S STAY CONNECTED! 😁:
Instagram and Facebook: @SMARTpro Academy
► Instagram: / smartproacademy
► Facebook: / smartproacademy
► TikTok: / smartproacademy
---------------------------------------------------------------------------------------------------------
💡💻 Get the Microsoft 365 version of Excel (Starting at $5.99 USD):
https://click.linksynergy.com/fs-bin/...
🎥💻 I use this program to produce and edit my videos: https://techsmith.z6rjha.net/c/273772...
#excel #microsoftexcel