For the individuals who are taking the Microsoft Office ProveIt Assessment (Outlook, Word, Excel, and PowerPoint), I highly encourage this video. I passed my tests with an overall score of 90.75. I made sure to add the video to my favorites so that if I am lacking in an area in the future, I can refer back to this video. Clear and concise instructions. The individual teaching this video is a great communicator in the sense that he does not bombard the viewers with confusing information.
I used to think creating such things as the drop downs were really advanced techniques, but you've shown how easy it is for even a beginner. Thank you for your videos.
Had totally forgotten how to use Excel. Doing a Master's degree and need to do a research log in Excel. Came upon your videos...you are a star!! It has all come back to me, thank you so much!!! You explain everything so well and clearly...and love the sense of humour!
This tutorial is AMAZING. Your way of explaining things is so clear and methodical and it is a pleasure to listen to you talk. I find your explanations so easy to follow. Have just learned this amazing data validation but only because you made it so very easy. Phenomenal. Once I have a bit more time I am going to look into your tutorials in more detail. For the time being, and to stop my team messing up the spreadsheet we work from by putting whatever they please in each cell, I needed desperately to learn how to do the dropdown lists to restrict their choices. So very grateful to you. Thank you
You have changed my life with your Excel videos. I feel that Excel is the hardest to understand conceptually at first, but with practice, other Microsoft programs make sense. Please never take these videos down. Thank you sir.
I am taking an Excel basic course in the company I work for. I didn't understand this topic at all. After watching your tutorial I am a lot more clear. Thank you very much. I have to say that the way you explain makes it also easier. Congratulations and blessings!
I absolutely love your videos. Excel is now fun and easy for me. I did a list of tv shows I'm watching, what seasons I'm missing, etc, lol, so it's been kind of similar and allowed me to practice. Just by watching the beginners, intermediate and now the advanced ones I went on to explore other functions, just figured how to do the genre's list throughout different sheets, etc... amazing!
I enjoy hearing you speak. You sound so clear, articulate and pleasant. Definitely makes the learning experience rewarding. Thanks for uploading all the videos that you have :-)
I am beginner in learning Computer Programmes, your all Videos are great to start and endup by learning clearly, Its such a great platform and you are the best Teacher with Excellent Articulation.
I got my Excel certification back in 2015 through my university, but didn't really get to use excel afterwards. I'm so glad i found this channel, i've been dying to refresh my memory on some of the important advanced functions that I had forgotten!
You speak very clearly with the right rhythm. So you made your videos very easy to follow. I learned a lot from them. They helped me to get started with my new job. Thank you very much.
Watched the main three tutorials and honestly I wanna take this time to appreciate that you made them because it truly will help me a lot. I start my first ever office job tomorrow, wish me luck☀️
I was looking for a teacher on advanced excel and I did not what to do as I got no time to go far.But now looking these videos has made me great Thanks
Wow! Your explanations are very clear and precise. As a non-english speaker, I understand everything very well. I'm starting to apply for my very first job soon and I find your tutorials very helpful and useful. Thankyou so much! All credits to you brother. Thanks for sharing your knowledge with us. God bless you.
Thank you so much for this. I took the same computer class in college twice because I failed the first time. We had labs but they never taught us excel. TheY taught us Word and a little Powerpoint. I had a project on excel. Imagine how it went the first time. The second time I ask a friend who knows excel to do this for me and then show me how did he do it. I paid 1.000 euros twice to learn Powerpoint (something I learned by myself. Not an expert but I felt it was a waste of time.) 4 month and didn't learn what I needed to. So thank you so much for this.
One video and I'm sold. U sir are a great inspiration 👏 I took 1 class and my non profit could no longer afford cont education. So I learn only own to help. Thank you. I will look into your video catalog to see where to start in case I missed anything... if you have any pointers on how to follow and progress. Let me know 🙏 pls. Thank you
Wow, this video is amazing. You explain everything clearly and concisely. I was truly afraid of excel, now I have been using it like crazy at work and making personal forms for my vast comic and music collections. You are a God- Send! Thank you, thank you!!!!
watching now May 2020 because im looking for a office job or virtual assistant and all your tutorial may helpful to my future endeavors thank you for this .
Your explanations are the best I've ever heard! Have tried many times to learn vlookup and pivot tables without success. BUT your voice, style, and explanations have helped me better than I ever thought I could learn! Thank you so much!!
I find these videos to be extremely helpful particularly when you follow the important one in sequential orders. Then, I look at other videos for extra knowledge. Thank you very much.
I currently am trying to get my degree in accounting. I started to look for entry level jobs and saw proficiency in excel was a requirement. I’ve learned so much in these videos! To be certified in excel how much more would I need to learn?
I had a problem with my excel data, I did not find anyone to help me. after watching this video, I know how to do well. thank you so much. your fun from Afghanistan.
Good video Sir, There is 1 more thing that I expectedin this video is the change in value in the next coloumn. E.G Lets say you rent a video dvd and any one want to know the rent of dvd by the category so moment he/she select the category like "Romance" then the rent amt in corresponding cell should automatically change, If he select "Horror" then the rent on the corresponding should automatically change ... So on so forth
Couldn't Princess Bride👰 be considered romance as well as fantasy? Your videos 📼 are good for those of us just getting familiar with Excel. I have found them helpful
Another good idea to not affect the list is protecting those cells by going to Review and Protect sheets option. You can also password protect it if it's that important.
I really appreciate you taking the time to teach!!! God bless you and blessings to you sir!!! I am trying to get a job in a medical setting, patient intake, billing. Can you think of anymore programs that would be helpful to know?
Thanks for the clear explanation. I have a situation and not sure what to do: an existing data set in a column has a list dropdown applied, but an additional 30 samples have been added to the sheet afterwards where the dropdown was not applied. How can this be corrected?
Thanks for this very elaborate tutorial. I would like to know how I can make my validation list un scrollable, is that possible? and then how can restrict people from accidentally changing the original selection thanks
Hello, Thank you very much for the simply explained information. Could you please write down the tips in description. It will be useful when I want to review it because it is difficult to find it without watching the whole video. Best wishes !
Hi! Let me just start off by saying you make wonderful videos that are very easy to understand. I have a doubt about this video, is it possible to use colors with this technique? I have tried but came up empty.
For the individuals who are taking the Microsoft Office ProveIt Assessment (Outlook, Word, Excel, and PowerPoint), I highly encourage this video. I passed my tests with an overall score of 90.75. I made sure to add the video to my favorites so that if I am lacking in an area in the future, I can refer back to this video. Clear and concise instructions. The individual teaching this video is a great communicator in the sense that he does not bombard the viewers with confusing information.
I used to think creating such things as the drop downs were really advanced techniques, but you've shown how easy it is for even a beginner. Thank you for your videos.
Had totally forgotten how to use Excel. Doing a Master's degree and need to do a research log in Excel. Came upon your videos...you are a star!! It has all come back to me, thank you so much!!! You explain everything so well and clearly...and love the sense of humour!
I too am in my masters program and find myself lost with excel!! these are very helpful
This tutorial is AMAZING. Your way of explaining things is so clear and methodical and it is a pleasure to listen to you talk. I find your explanations so easy to follow. Have just learned this amazing data validation but only because you made it so very easy. Phenomenal. Once I have a bit more time I am going to look into your tutorials in more detail. For the time being, and to stop my team messing up the spreadsheet we work from by putting whatever they please in each cell, I needed desperately to learn how to do the dropdown lists to restrict their choices. So very grateful to you. Thank you
You have changed my life with your Excel videos. I feel that Excel is the hardest to understand conceptually at first, but with practice, other Microsoft programs make sense. Please never take these videos down. Thank you sir.
When you use data validation, source....you can just type the first letter and it will pop up ;) Love your videos!
I am taking an Excel basic course in the company I work for. I didn't understand this topic at all. After watching your tutorial I am a lot more clear. Thank you very much. I have to say that the way you explain makes it also easier. Congratulations and blessings!
This man's love of synthpop is legendary
This is so clear and well explained. I feel like you opened a world in front of me! Thank you for this video.
I absolutely love your videos. Excel is now fun and easy for me. I did a list of tv shows I'm watching, what seasons I'm missing, etc, lol, so it's been kind of similar and allowed me to practice. Just by watching the beginners, intermediate and now the advanced ones I went on to explore other functions, just figured how to do the genre's list throughout different sheets, etc... amazing!
which shows you watching?
excel is great for personal use just as it is for professional work, especially goal tracking
all your videos are great teaching devices many thanks!
ua-cam.com/video/alV9Dn7YIfA/v-deo.html
I enjoy hearing you speak. You sound so clear, articulate and pleasant. Definitely makes the learning experience rewarding. Thanks for uploading all the videos that you have :-)
All your videos are so well explained. Thanks for the great learning resource.
I am beginner in learning Computer Programmes, your all Videos are great to start and endup by learning clearly, Its such a great platform and you are the best Teacher with Excellent Articulation.
I got my Excel certification back in 2015 through my university, but didn't really get to use excel afterwards. I'm so glad i found this channel, i've been dying to refresh my memory on some of the important advanced functions that I had forgotten!
You speak very clearly with the right rhythm. So you made your videos very easy to follow. I learned a lot from them. They helped me to get started with my new job. Thank you very much.
Thank you.. My Professor of MABS recommended for watching you lessons of word and exel then ppt.. you made it easy for me.. thank you شكرا
You deserve the world for creating these videos.
Watched the main three tutorials and honestly I wanna take this time to appreciate that you made them because it truly will help me a lot.
I start my first ever office job tomorrow, wish me luck☀️
New to ANY sort of technology! Your explanations using Excel are at a level I can actually follow and apply...Thank you!
Your excel tutorials are best, concise, organized well, easy to understand, and love the music!
OMG, I Absolutely Love your website; I feel as though I am Back in School and listening to everything also watching it actually happen.
I was looking for a teacher on advanced excel and I did not what to do as I got no time to go far.But now looking these videos has made me great
Thanks
Your videos make (re)learning Excel effective through simplicity and compelling style. TY!
For someone who did not know much going into it, these videos have certainly helped me out a lot.
Many many thanks! Your way of teaching - combined with your calm voice - is wonderful!
Wow! Your explanations are very clear and precise. As a non-english speaker, I understand everything very well. I'm starting to apply for my very first job soon and I find your tutorials very helpful and useful. Thankyou so much! All credits to you brother. Thanks for sharing your knowledge with us. God bless you.
Thank you so much for this. I took the same computer class in college twice because I failed the first time. We had labs but they never taught us excel. TheY taught us Word and a little Powerpoint. I had a project on excel. Imagine how it went the first time. The second time I ask a friend who knows excel to do this for me and then show me how did he do it. I paid 1.000 euros twice to learn Powerpoint (something I learned by myself. Not an expert but I felt it was a waste of time.) 4 month and didn't learn what I needed to. So thank you so much for this.
It may be worth pointing that list will work regardless of where it is put. Great videos.
Your continued commentary on synthpop cracked me up. Great vid.
One video and I'm sold. U sir are a great inspiration 👏 I took 1 class and my non profit could no longer afford cont education. So I learn only own to help. Thank you. I will look into your video catalog to see where to start in case I missed anything... if you have any pointers on how to follow and progress. Let me know 🙏 pls. Thank you
Wow, this video is amazing. You explain everything clearly and concisely. I was truly afraid of excel, now I have been using it like crazy at work and making personal forms for my vast comic and music collections. You are a God- Send! Thank you, thank you!!!!
watching now May 2020 because im looking for a office job or virtual assistant and all your tutorial may helpful to my future endeavors thank you for this .
Your explanations are the best I've ever heard! Have tried many times to learn vlookup and pivot tables without success. BUT your voice, style, and explanations have helped me better than I ever thought I could learn! Thank you so much!!
I find these videos to be extremely helpful particularly when you follow the important one in sequential orders. Then, I look at other videos for extra knowledge. Thank you very much.
Had to catch up with my high school daughter's proficiency ... your navigational / application videos have been great!!
They way you teach this is so fun, I’m so happy I found a teacher that teaches tech in such a cool way, unlike my teachers
Learning this is like cavemen discovering fire.
😂😂😂😂😂😂😂😂😂😂
I have NEVER commented on vids, until today. THANK YOU! You have excellent teaching skills.
THANK YOU for the BESTplayslist of excel in all of youtube ! thaaank uuuu
I don't like new wave but I love your videos. Very easy to understand.
I currently am trying to get my degree in accounting. I started to look for entry level jobs and saw proficiency in excel was a requirement. I’ve learned so much in these videos! To be certified in excel how much more would I need to learn?
Your tutorials are so easy to follow up and interesting because of the way you teach
Omg this is one of the best tricks I've learned so far! I just love the way you teach. It's informative and entertaining as well!
I am amazed to see that a so clear explanation can be done and also in such an elegant way!
I had a problem with my excel data, I did not find anyone to help me. after watching this video, I know how to do well.
thank you so much. your fun from Afghanistan.
Thanks a lot brother this is what I have been looking for a long time
These tutorials are very helpful and I appreciate your sense of humor (re: romance movies) along the way.
Your tutorial videos are easy and simple to understand. Thanks.
I am very grateful. All your videos i have watched has been of great help to me.
Much appreciated.
God bless you
cant stress enough what good teacher you are!!!! thank you
This is very helpful. I'm an EXCEL novice. Thanks.
Lol. Best part is new wave “will always be relevant”. Haha great vids man.
Bro 😂😂
@Conner Roberts What the hell man
I must confess you are indeed great in your ways of teaching, thanks so much and more Grace as you keep helping people 👏👏😊
Your videos are great. You are helping many people learn new skills during quarantine. Thank you for all that you do.
Good job! These videos are very educational. I learned a lot from them as a beginner!
I've been going video to video trying to understand but your channel is the one that really did it. Thank you sir.
a very nice tutorial specially for beginners. Can i have the link for entire courses in ascending order from beginners to advance level.
this was a huge help - thank you. I have a self learning manual but you just cut down so much time on understanding Data validation
I’d love to see some Statistics videos. You do a great job explaining thoroughly.
I'm new on Excel, no experience here ,now I'm learning something new, thanks
Good video Sir, There is 1 more thing that I expectedin this video is the change in value in the next coloumn. E.G Lets say you rent a video dvd and any one want to know the rent of dvd by the category so moment he/she select the category like "Romance" then the rent amt in corresponding cell should automatically change, If he select "Horror" then the rent on the corresponding should automatically change ... So on so forth
Couldn't Princess Bride👰 be considered romance as well as fantasy? Your videos 📼 are good for those of us just getting familiar with Excel. I have found them helpful
hi
Another good idea to not affect the list is protecting those cells by going to Review and Protect sheets option. You can also password protect it if it's that important.
Many thanks watched all 3 videos have better understanding of excel
got myself new knowledge of Excel in this Self quarantine situation:) Thankyou so much
Me too!
Best tutorial, clear voice, well structured. very well done and THANK YOU.
Tommorow is my practical test
I am here list validation but i found both
Thank u a lot
U helped me
I am a first time user and i love your videos, so easy to understand, thank you!
WHY ARE YOU SO GOOD AT THESE SIR?
Very helpful. I had figured it out but your video validated that I did it correctly. Thanks.
I really appreciate you taking the time to teach!!! God bless you and blessings to you sir!!! I am trying to get a job in a medical setting, patient intake, billing. Can you think of anymore programs that would be helpful to know?
Thank you. You make it so easy. Now I have to start practicing.
Using your tutorials for Libre Office's Calc(their version of Excel) and this tutorial works for that too
Thanks for the clear explanation. I have a situation and not sure what to do: an existing data set in a column has a list dropdown applied, but an additional 30 samples have been added to the sheet afterwards where the dropdown was not applied. How can this be corrected?
I do know excel very well from watching your videos. Thanks for noticing 👀💖
Thanks for this very elaborate tutorial. I would like to know how I can make my validation list un scrollable, is that possible? and then how can restrict people from accidentally changing the original selection thanks
Wonderful indeed to have your tutorial online. Thank you
So good. I’m learning both excel skills and movies. I love how u categorized movies by locations. So funny!!
a very educating piece , i always enjoy using it to improve myself. i am very grateful.
Really helpful. I do know a fair amount but have picked up some more tips. Thank you
Thanks you for the great explanation, I been watching many videos, and this one was just perfect, I was able to do what I needed.
Thanks, Merry Christmas🎄 and Happy New Year
Wonderful content. I like your voice . Can listen to your tutorial all day long.😊😊
Great Value of information and fantastic way of delivering it! Thank you so much!
Tnx for beautiful videos. what's agood way to practice all and also how many hours to cover it up like a pro. Pls reply. Thank you again
Such a nice diction and comprehensible speech. Thank you very much for your videos.
I like how you pronounce 'Ok'. Thanks for the great videos.
The Martian is by far the best movie in the list (although it might be M, not PG-13.) Thanks for the info!
I always learn something new from your videos 👍
Great info. Please provide more videos. Keep up the great work again.
great video. what if i want to display the items purchased in 2007.
you're a hero. I'm binging your excel videos so that I can start sorting my steaming pile of overwhelming work tomorrow 😵
I benefit alot from your tutorial. Good teaching
Nice movie list! I love them all. Very informative videos. Thank you.
thank you do much, these tutorials helped me alot, you truly are the best excel teacher on youtube !
Nice movie collection, love older movies as well as older music. Great job thank you.
I found your comment about Synthpop being the best genre of music contradictory to your otherwise unbiased approach to data.
Hello,
Thank you very much for the simply explained information.
Could you please write down the tips in description. It will be useful when I want to review it because it is difficult to find it without watching the whole video.
Best wishes !
Hi! Let me just start off by saying you make wonderful videos that are very easy to understand. I have a doubt about this video, is it possible to use colors with this technique? I have tried but came up empty.