🎒 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/ 📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
Thank you, Kevin, a bit late with this video, if you only posted this 2 weeks ago that would have been a lifesaver ! I had a project to work on with the exact same things presented in your video. Took me a while until I've figured it out. Another cool trick is to hide and lock the other sheet where the data is so no one else has access to it in case you are the manager who allocates different things on the project.
You're absolutely right! Locking and hiding the sheet is a great idea, especially if multiple people are working on the project. It helps ensure that only authorized users can access or modify the data while keeping everything organized and secure. Thanks for sharing that tip! 🚀
If your table is on the same sheet as your cell, you don't need the named range. Another option of creating a dynamic list is by using the UNIQUE function. Let's say you have a list of your products and you want people to choose one. If your UNIQUE is in say T2 then you type T2# in the source. New items will show up. For that method it doesn't matter where the UNIQUE cell is.
True! If the table is on the same sheet as the cell, there's no need for a named range. And great tip on using the UNIQUE function! That’s a super handy way to create a dynamic list that updates automatically when new items are added. Thanks for sharing! 🚀
That’s awesome to hear! 🎉 I’m really glad my videos have helped simplify Excel for you, and it’s even more amazing that you’re now teaching it to others. Keep up the great work, and happy learning!
@KevinStratvert could do more on presentations i really need that too, i'm comfortable with word primarily even designed a phone in it. Anywayd as the trends are in 2025 an update on power point could be great
Thank you, Kevin. I created a table, which I will be changing month to month. How do I change the header/title of the table when I want to re-enter new data? Thank you!
a 9m video for something you could literally learn in 30 seconds. unsubscribed for stretching the sht out of every video you have done in the last 3 month or so .
I share these videos on our company intranet and they are very popular with users who are not very tech savvy but would like to learn how to better use office apps. This content is not for everyone. But lots of people still find it useful/helpful.
I cover how to make a simple drop-down in the first 1.5 minutes for those who just need the basics. The rest of the video dives into more advanced scenarios, like referencing cells for a drop-down and making it update automatically based on table values. When I cover a topic, I prefer to provide an in-depth overview so viewers can fully understand the feature rather than just a surface-level explanation. I appreciate the feedback and understand that different people prefer different video lengths!
🎒 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
Thank you, Kevin, a bit late with this video, if you only posted this 2 weeks ago that would have been a lifesaver ! I had a project to work on with the exact same things presented in your video. Took me a while until I've figured it out. Another cool trick is to hide and lock the other sheet where the data is so no one else has access to it in case you are the manager who allocates different things on the project.
You're absolutely right! Locking and hiding the sheet is a great idea, especially if multiple people are working on the project. It helps ensure that only authorized users can access or modify the data while keeping everything organized and secure. Thanks for sharing that tip! 🚀
Nice video about drop-down lists.
Your videos are great. I recommend them (and this one specifically) to my coworkers.
Thank you Kevin for your very clear teaching method. ❤
This is so good, Kevin. Thank you.
Very useful presentation. Thank you.
Can you make one on how to automate sending email from a excel sheet list using Outlook or Power automate ?
Thank you! I needed to fix a list and didn’t know how. Now I do🎉
If your table is on the same sheet as your cell, you don't need the named range. Another option of creating a dynamic list is by using the UNIQUE function. Let's say you have a list of your products and you want people to choose one. If your UNIQUE is in say T2 then you type T2# in the source. New items will show up. For that method it doesn't matter where the UNIQUE cell is.
True! If the table is on the same sheet as the cell, there's no need for a named range. And great tip on using the UNIQUE function! That’s a super handy way to create a dynamic list that updates automatically when new items are added. Thanks for sharing! 🚀
Thanks kevin, excel has been tough for me but u simplified it for me and now i teach it to my fellows.
Thanks
That’s awesome to hear! 🎉 I’m really glad my videos have helped simplify Excel for you, and it’s even more amazing that you’re now teaching it to others. Keep up the great work, and happy learning!
@KevinStratvert could do more on presentations i really need that too, i'm comfortable with word primarily even designed a phone in it. Anywayd as the trends are in 2025 an update on power point could be great
Spot on Kevin. Thanks.
Very thorough and very well explained, thank you! 👏 👏
Thank you, Kevin.
I created a table, which I will be changing month to month.
How do I change the header/title of the table when I want to re-enter new data?
Thank you!
This is really basic. (:
True, but it's a good reminder if you've not done it for a while. :)
a 9m video for something you could literally learn in 30 seconds. unsubscribed for stretching the sht out of every video you have done in the last 3 month or so .
I share these videos on our company intranet and they are very popular with users who are not very tech savvy but would like to learn how to better use office apps. This content is not for everyone. But lots of people still find it useful/helpful.
I cover how to make a simple drop-down in the first 1.5 minutes for those who just need the basics. The rest of the video dives into more advanced scenarios, like referencing cells for a drop-down and making it update automatically based on table values. When I cover a topic, I prefer to provide an in-depth overview so viewers can fully understand the feature rather than just a surface-level explanation. I appreciate the feedback and understand that different people prefer different video lengths!