One of the best videos I have come across. Many thanks. No high pitch... No extra tones... Just a very calm, relaxed and professional way of explaining... Kudos!!!
You have made a lot of bosses a whole lot happier!!...because you have taught their teams how to provide better presented and analysed spreadsheets! Kudos to you sir!!
I like his narration. It so soothing, can easily understanble . I watched other videos for hours, but his videos are only time. That indicates how easily he made..
I've always said to myself over the last decade that Excel is too powerful for what's needed on the market. Without exaggeration I can say that even if Excel will not be updated 100 years from now it will still be as powerful as today for most users. Great clip. I'm gonna use some of these newly acquired tricks in my future work for sure
The narrator is most informative with the step by step displays and tone of voice. Made me want to stay and re-watch video to absorb his brilliant presented processes. I am definitely a follower. Thanks for the education.
Haha sometimes it's hard to pay attention with relaxed tone of voice + not the most exciting content. It's only a special group of people that like watching excel videos :)
Very nice job of explaining these tools! Thanks! I hope this reference will continue to be available as I am sure I will watch it over and over and over....
One of the best videos o have seen on UA-cam. Short and concise, straight to the point. Extremely useful. Highly appreciated. Please keep producing such invaluable materials.
Very impressive list of truly advanced features. I have been using Excel for over 10 years. I only knew two of those tricks! Thanks for the very valuable and organized information.
I made sure this was helpful tips. It is annoying when people repeat the common sense stuff just to make a video. I purposely choose topics that add value. Thanks
Thank you for putting all the nice tips together and show them in video format. Very useful for my learning. I have been using Excel for years but some of them are new to me. Good job!
Hi. Just un excellent presentation of features that make Excel be a great apps. I am used to Excel since years but continue discovering tricks that are very useful. Thanks a lot
Actutally all these days I was not bothered to know the tricks in Excel . During these covid days i just watching . Really its going to be useful for me while preparing my review meetings..which will save lot of time ..Thanks
Great video, just one extra little trick I like to employ when using the Transpose array formula- as you mentioned- you need to select the size of the area to fill. I copy the original data, paste special using values and transpose. This gives me the area to select, so I highlight all of my pasted values and then type the formula as you outlined. Saves you a lot of trouble when you’ve got a lot of data to transpose.
These are so informative. Thank you for the video. **Sobs looking at the advance select feature and realizing how many hours were wasted manually editing**
I remember using the *Shift+Ctrl+Enter* that was covered in the first tip with some other function as well. Can't seem to quite remember what the function was but it's definitely something I'll brush up on more. Thanks for sharing your wisdom :)
I have not finished the video yet but I can already tell that this is an awesome and very easy to follow tutorial. Very simple, informative and straight forward. Thank you so much for sharing.
Great video. Just proving you never know everything with Excel. A few of these tricks I already knew, but some of them just blew my mind. The Date picker was my favorite, just because I use dates a lot and most of the time it's about the day of the week rather than the date. So much easier to use a picker.
Great video ! One little remark : On the scenario manager, you divide the year rate by 12%. Considering interest rate nature, you should not divide it by 12 but rather 6%^(1/12). it's not arithmetic but geometric !
Even though I have been using Excel for a *long* time and on an advanced level, you still managed to provide some neat tricks that I wish I had known years ago. Great job.
Jeepers Creepers! This is a gold mind of Excel Tips and Tricks! I teach Excel at a local College, and this has opened a whole new world of instruction. Well worth exploring and adding to my teaching repertoire. Thank you!
@@vannacheong103 Don't be discouraged. You can get better. :-) Just give yourself a few months of consistent learning and practice. You'll surprise yourself. I feel inadequate myself, but I'm learning advanced Excel and and will get good at it. :-) That's why I'm on this channel. Two other channels I like are Leila Gharani and Excel Campus - Jon. Of course, there are many other good channels there, but between these three you can learn enough to be confident in Excel. Best wishes to you.
Cheers for the video content! Sorry for the intrusion, I am interested in your initial thoughts. Have you considered - Weydaniel Organized Dominator (just google it)? It is a smashing one off guide for getting 7000 plus project management and business templates without the hard work. Ive heard some unbelievable things about it and my cousin at last got astronomical success with it.
One of the best videos I have come across. Many thanks. No high pitch... No extra tones... Just a very calm, relaxed and professional way of explaining... Kudos!!!
By far the best instructor. Concise, articulate and easy to follow.
You have made a lot of bosses a whole lot happier!!...because you have taught their teams how to provide better presented and analysed spreadsheets! Kudos to you sir!!
Thanks
I like his narration. It so soothing, can easily understanble . I watched other videos for hours, but his videos are only time. That indicates how easily he made..
Thanks!
I've always said to myself over the last decade that Excel is too powerful for what's needed on the market. Without exaggeration I can say that even if Excel will not be updated 100 years from now it will still be as powerful as today for most users.
Great clip. I'm gonna use some of these newly acquired tricks in my future work for sure
The narrator is most informative with the step by step displays and tone of voice. Made me want to stay and re-watch video to absorb his brilliant presented processes. I am definitely a follower. Thanks for the education.
Thanks
Very impressive, easy to understand and blows me away to know there is so much more you can do with excel. Great work!
Everyone of your teaching is professionally done! THANKS!!!!!
Such a calm and relaxed style of talking, makes learning very theraputic 🙌👌
Haha sometimes it's hard to pay attention with relaxed tone of voice + not the most exciting content. It's only a special group of people that like watching excel videos :)
Very nice job of explaining these tools! Thanks! I hope this reference will continue to be available as I am sure I will watch it over and over and over....
I've been working in Excel for years and learned lots of new stuff here. Well done!
One of the best videos o have seen on UA-cam.
Short and concise, straight to the point.
Extremely useful.
Highly appreciated.
Please keep producing such invaluable materials.
Thanks. New video on Excel coming tomorrow.
That calendar picker is a great tip. Excellent for spreadsheets being issued to less technical users 👍
Very clear voice and understandable explanation. Very good job. Thanks.
*One Of The Best Video Of Excel I Have Ever Seen Sir Great Value Addition!!!!* THANK YOU SO MUCH FOR SHARING!!!
Concise and useful. Thanks for showing the analysis tools location.
Very impressive list of truly advanced features. I have been using Excel for over 10 years. I only knew two of those tricks! Thanks for the very valuable and organized information.
One of the best excel videos. Important for any user. Thank you.
You are welcome!
I was surprised by how good this video was. Often, the tips are pretty obvious but these were very helpful. Many thanks!
I made sure this was helpful tips. It is annoying when people repeat the common sense stuff just to make a video. I purposely choose topics that add value. Thanks
٣ ا ت
Thank you for putting all the nice tips together and show them in video format. Very useful for my learning. I have been using Excel for years but some of them are new to me. Good job!
Excellent!
Hi. Just un excellent presentation of features that make Excel be a great apps. I am used to Excel since years but continue discovering tricks that are very useful. Thanks a lot
Glad it was helpful!
Wow , my respects!! In the first three min you explained more than I can handle. THANKS YOUR AWESOME
Very important but hidden stuff. Thank very much for your patient teaching.
That was truly a comprehensive tutorial. Nice job !
Actutally all these days I was not bothered to know the tricks in Excel . During these covid days i just watching . Really its going to be useful for me while preparing my review meetings..which will save lot of time ..Thanks
Glad to hear that
Such an amazing tutorial to learn various useful tools that help you save your time while working with Excel. Thank you for your efforts.
Great video, just one extra little trick I like to employ when using the Transpose array formula- as you mentioned- you need to select the size of the area to fill. I copy the original data, paste special using values and transpose. This gives me the area to select, so I highlight all of my pasted values and then type the formula as you outlined. Saves you a lot of trouble when you’ve got a lot of data to transpose.
Great tip. Thanks!
Seriously. This may be the best overall Excel video I've ever watched. What kind of jagoff down votes it?
Thanks. Funny but I get about 2% thumbs down on any video.
These are so informative. Thank you for the video. **Sobs looking at the advance select feature and realizing how many hours were wasted manually editing**
Very well done! Learning valuable Excel skills and ASMR, all in one.
These, and the initial Tips & Tricks, make our assignment work much quicker. Thank you!
Mind blown! I only thought I knew Excel. Great video, sir!
बहुत ही शानदार‚ बहुत ही अच्छा ज्ञान दिया आपने आपका बहुत-बहुत धन्यवाद्।
I remember using the *Shift+Ctrl+Enter* that was covered in the first tip with some other function as well. Can't seem to quite remember what the function was but it's definitely something I'll brush up on more. Thanks for sharing your wisdom :)
Awsome video with some very useful tips for everyday use. Thank you so much. Keep up the good work.
Thought I knew all about Excel, this just proved me wrong, really worth watching.
One of the most useful and well explained videos I have ever seen
I have not finished the video yet but I can already tell that this is an awesome and very easy to follow tutorial. Very simple, informative and straight forward. Thank you so much for sharing.
This is excellent! Thank you so much. Keep the videos coming. These are the best I have seen on UA-cam.
Wow. Absolutely brilliant. Great pace and clear instructions, excellent video presentation, and genuinely useful stuff. Superb. Subscribed and shared
Dude, you are the Excel King! Thanks.
Happy to help!
Excellent professional method of teaching , Your Message was so clear. Respect!
Excellent professional , it's easy to understand of advanced excel . Thank you Sir
Awesome! Very informative and well explained. Thank you.
Excellent video, very clear presentation. really useful tools. Many thanks
Learned a few good trick, thanks :)
Great demonstration videos. I've learnt a lot by watching the video
This was one of the best videos, I love this guy.
Jip! I think everyone learned atleast something from this list!
Great video. Just proving you never know everything with Excel. A few of these tricks I already knew, but some of them just blew my mind. The Date picker was my favorite, just because I use dates a lot and most of the time it's about the day of the week rather than the date. So much easier to use a picker.
Great video ! One little remark : On the scenario manager, you divide the year rate by 12%. Considering interest rate nature, you should not divide it by 12 but rather 6%^(1/12).
it's not arithmetic but geometric !
Good point!
There are morons who can give thumbs down for a such a wonderful and informative subject calmly presented. Thanks
It is funny but about 2% of people give thumbs down no matter how good the video is.
Thank you. I came across this by wondering typing in a question in my browser and it is exactly what I was looking for.
Zug egg very day FCC
Play Group a
these are great, easy to follow along. You are a wonderful teacher.
Thank you!
Even though I have been using Excel for a *long* time and on an advanced level, you still managed to provide some neat tricks that I wish I had known years ago. Great job.
Thankful for giving complete insight of few excel shortcuts, tools and functions can be used.
This tutorial video really gets me " wow", thank you so much!!!!!!
This video is really a helpful one for MS-Excel advanced learners.
it changed my life!
Awesome! Very specific and easy understanding. Thanks
Learned a lot. Thanks buddy. Keep it up!!
Glad to hear it!
Very helpful video! Thank you!
These are very useful tip and formulas 👍
Wow have been using a lot of Excel features, still most of those features are new to me
Yeah - definitely going to be using slicers more often!
Excellent. Truly advanced level. Well presented.
Very practical for everyday and business use. Thanks!
Easy To understand. Clear directions & speaking! THX
Jeepers Creepers! This is a gold mind of Excel Tips and Tricks! I teach Excel at a local College, and this has opened a whole new world of instruction. Well worth exploring and adding to my teaching repertoire. Thank you!
Great video. Crisp n clear. 💐
!!!!!!!!!!!!! Simply FANTASTIC !!!!!!!!!!!!!!!
7:30 let's convert teaspoons into cubic light years
Sounds like an idea for an Enhanced Advanced Video
This is very informative video and explained very well. I don't know why 452 people disliked it. Good Work Sir.
Thanks for liking
This was a great video. Great job. Thank you.
Really helpful tips, never thought about using these functions before.
Glad it was helpful!
nice.. really amazing feature. I truly enjoy this video... Thank you so much
it is amazing that theres so much more to excel. i am now so eager to get on board and apply what i have just learnt
@Vanna Cheong I agree. Excel is like a playground for data geeks once you start using more than its basic features. :-)
@@BiancaAguglia i feel awfully insdequate in excel. :)
@@vannacheong103 Don't be discouraged. You can get better. :-) Just give yourself a few months of consistent learning and practice. You'll surprise yourself.
I feel inadequate myself, but I'm learning advanced Excel and and will get good at it. :-) That's why I'm on this channel. Two other channels I like are Leila Gharani and Excel Campus - Jon.
Of course, there are many other good channels there, but between these three you can learn enough to be confident in Excel. Best wishes to you.
Very good explained Thumps up
Really useful, SLICERS! Thank you.
You had me at Live Transpose
Thanks so much. This information is very helpful and presented in a way that I can follow, learn, and utilize everyday at work.
Thank you for your video sir, I feel so much more confident now! :)
Learned many new ideas/shortcuts. Thank U so much.
this one is direct to the point
Great help and very well demonstrated.
Awesome Video. Learned many things. Thanks a lot.
Thank you, really like the way you present the tools, easy to follow and understand.
Thanks. You may want to check out the original Excel tips and tricks video as well: ua-cam.com/video/EdnAeqxqdzM/v-deo.html
Wow this is very advanced omg I am not ready for this
Thanks so much. You explained it so well. I'm gonna try this out. Many thanks for the easy explanation.
Great stuff
Very nice video , it helped me a lot . You surely got a thumb up bro. I hope you continue uploading more videos to master this software.
Thank you, I will
This is great! Thank you!
Some great tips here! Thanks for sharing
Thank you so much, yi did so well am so exited to learn ..please keep the tutorial going on and helping the community ..thank you God Bless You
Thank you Sele for this video. Thoroughly enjoyed it!
You are really amazing sir... Keep going.... Very useful... Love ur videos😍😍😍
I didn't know about the Track Changes tool. What a discovery!
Helps me alot. Thank you so very much..God bless you
Cheers for the video content! Sorry for the intrusion, I am interested in your initial thoughts. Have you considered - Weydaniel Organized Dominator (just google it)? It is a smashing one off guide for getting 7000 plus project management and business templates without the hard work. Ive heard some unbelievable things about it and my cousin at last got astronomical success with it.
Thanks! Such a great things I had learn from you
The tips were very good.
Very useful tips, Thanks for sharing.
Thanks for your great video.