For me, this is excellent. I just had a programmer use a drop down menu for me for an Excel application for managing personal finances for retired people. Now I can see how to do it myself next time. Thanks. Helpful information. Clear presentation.
man u r really good, some people make glamorous you-tube videos but does not provide proper and in-depth information, u r really helpful, keep it up, can u please up-lode more videos related excel which would be important in job place, thank u
Hie sir..... just found your channel Literary helped me a lot, What if I want my add a colour to my drop down list, like for example if I select Outdoor ( the box will be green) , if I select indoor( the box will be red)🙏
Thank you for your videos which are really well explained. I wish to ask if you have any advice for beginners on Data Consolidation? I have watched the video on data validation which was very good, just wandering if you had anything on Data Consolidation. Thank you again. James Shutlar From London UK
I have found your videos excellent and very helpful as i am still a beginner. I watched your video on drop down menus which was helpful but i would also like to know if i can do a multi column drop down. What i want to do is use a product list with prices beside them to use as a drop down list so that i choose a product and price to add to a quote sheet, instead of having to go backwards and forwards each time to get the information. Or is there an easier way to link these two items of information to make it all work?
Love your tutorials. Really easy to pick up thanks to your way of teaching. Do you have any tutorials on quantity surveying for the construction industry by any chance?
Thank You - all Your Video's are excellent - Love Your teaching methods - keeping it simple to understand - How would one add a color to cells automatically - and a $ value - as an example - suppose you had 5 houses (sq ft/$ value is $50 sq ft) - Your House is a 1000 sq ft & No Garage - comparable house 1 - 950 sq ft & a single garage (value$10,000) - house 2 -1100 sq ft 2 car garage (value$20,000)- house 3 is 1200 sq ft & No garage (same as Yours )- house #4 is 1400 sq ft & single garage & house #5 is 800 sq ft & double garage -Could You show an example of how to do those adjustments - Thanks again & Stay Safe
Is there a possibility to always show the dropdown icon, wich appears after selecting the cell. This is possible when using filters but not when using dropdowns.
Hi sir, new subscriber here 😊 need your help regarding some excel logic, i have a logistics data which i need to find the percentage of share of business for each carrier, File includes Lanes( source to Destination), truck, and carrier. appreciate your help on this
Hi I want a permanent form where can have the cells permanent but I can still type on for each new customer and I don't lose the Integrity of the form each time?
Nice class, i will like to know how i can get my cells Secondly i am working on a data of about 900 names with various figures on a pay roll, i will like to know how to make this figures calculate itself automatically and give me a final answer as i input the various data.
I put the table in a separate sheet in the same workbook. But, when I add a value to the end of the table, it extends, but it does not reflect in the Drop down
Long shot as this is a 3 year old video.......if you see this comment I would like a tutorial for tables and list that show certain options Let's say you have sports teams and one column says team managers with 5 manager names the column beside it says player names. What I would like to happen is if I chose a certain manager from the first column then only the players on his team would show on the players drop down list for me to select. then if I chose a different manager the selection of his players would show in the list.
Excellent Teacher, I like the fact he doesn't rush through, and talk fast, I really liked this Tutorial!
Thanks for the great tutorials. It's no wonder a teacher would be best at these. Found yours the easiest to follow by far.
I NEVER KNEW about the Table option. I've been doing the dropdown the hard way. THANK YOU! 🙂
Excellent!! Great teacher
For me, this is excellent. I just had a programmer use a drop down menu for me for an Excel application for managing personal finances for retired people. Now I can see how to do it myself next time. Thanks. Helpful information. Clear presentation.
I’m glad the video could help you out!
Thanks you so much ! (french student!)
THANK YOU! You will be coming to work with me daily :)
Thank you. Very informative and quite helpful. I don't know why anyone would give this tutorial a thumbs down. Great job!
That is helpful. Thank you teacher
Thank you so much for sharing your knowledge as this is my refresher course. You're Awesome!
Really like your tutorials! Thank you!
You are so welcome!
wow this really helped thanks for the great tutorial :)
Excellent sessions. Learned so much in a short time! Jamie is an amazing teacher!!!!!
man u r really good, some people make glamorous you-tube videos but does not provide proper and in-depth information, u r really helpful, keep it up, can u please up-lode more videos related excel which would be important in job place, thank u
Thanks so much for this video and your expertise!! I learned how to do this in 5 minutes!! You're theeee best lol!!
Thank you!
Hie sir..... just found your channel
Literary helped me a lot,
What if I want my add a colour to my drop down list, like for example if I select Outdoor ( the box will be green) , if I select indoor( the box will be red)🙏
Very useful content. Thank you!
Great tutorials
Thank you for your videos which are really well explained. I wish to ask if you have any advice for beginners on Data Consolidation? I have watched the video on data validation which was very good, just wandering if you had anything on Data Consolidation. Thank you again.
James Shutlar
From London UK
I have found your videos excellent and very helpful as i am still a beginner. I watched your video on drop down menus which was helpful but i would also like to know if i can do a multi column drop down. What i want to do is use a product list with prices beside them to use as a drop down list so that i choose a product and price to add to a quote sheet, instead of having to go backwards and forwards each time to get the information. Or is there an easier way to link these two items of information to make it all work?
Thank you!!
You're welcome!
Love your tutorials. Really easy to pick up thanks to your way of teaching. Do you have any tutorials on quantity surveying for the construction industry by any chance?
GREAT TUTORIAL. HOW TO MAKE THE COLUMN NOT TO LEAVE IT BLANK?
Hello excuse me but I probably missed it but how did you take off that table? What Keys did you press?
Nice and very informative....
You make it so easyyyyy
Hello Jimmy,
Do you help professionally? Please let me know. Thank you!
Thanks for the great lessons! Being this is geared toward teachers. How about a lesson on making a grade book? I could really use that.
You’re welcome and that’s a great idea!
I want short cut keys to use for excel and also the settings for the short key...please
Thank Very Much
Thank You - all Your Video's are excellent - Love Your teaching methods - keeping it simple to understand - How would one add a color to cells automatically - and a $ value - as an example - suppose you had 5 houses (sq ft/$ value is $50 sq ft) - Your House is a 1000 sq ft & No Garage - comparable house 1 - 950 sq ft & a single garage (value$10,000) - house 2 -1100 sq ft 2 car garage (value$20,000)- house 3 is 1200 sq ft & No garage (same as Yours )- house #4 is 1400 sq ft & single garage & house #5 is 800 sq ft & double garage -Could You show an example of how to do those adjustments - Thanks again & Stay Safe
Great. Thanks.
Pls can you give us a tutorial on power query, please!
Is there a possibility to always show the dropdown icon, wich appears after selecting the cell. This is possible when using filters but not when using dropdowns.
Hi sir, new subscriber here 😊
need your help regarding some excel logic, i have a logistics data which i need to find the percentage of share of business for each carrier,
File includes Lanes( source to Destination), truck, and carrier. appreciate your help on this
Hi I want a permanent form where can have the cells permanent but I can still type on for each new customer and I don't lose the Integrity of the form each time?
Hi, please can we get a video showing how the other drop down options, except list, works. Thank you.
Nice class, i will like to know how i can get my cells
Secondly i am working on a data of about 900 names with various figures on a pay roll, i will like to know how to make this figures calculate itself automatically and give me a final answer as i input the various data.
When I insert table excel creates columns, it is not doing the same as in your tutorial.
How i can roll the drop down list with the help of mouse roller in excel. Please tell me.
I put the table in a separate sheet in the same workbook. But, when I add a value to the end of the table, it extends, but it does not reflect in the Drop down
How to edit (change) data already validated and I want to edit data in excel
?
I did everything as you but still all 3 sources are appearing when am making a choice, why is this? Please help, thanks!
same here
Please what if you don't have the data validation showing
Long shot as this is a 3 year old video.......if you see this comment I would like a tutorial for tables and list that show certain options
Let's say you have sports teams and one column says team managers with 5 manager names the column beside it says player names. What I would like to happen is if I chose a certain manager from the first column then only the players on his team would show on the players drop down list for me to select. then if I chose a different manager the selection of his players would show in the list.
Why are you determined that football could be an indoor sport?