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!!!
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
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!!
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 :)
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 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
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.
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
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.
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....
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**
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!
One of the best videos o have seen on RUclips. Short and concise, straight to the point. Extremely useful. Highly appreciated. Please keep producing such invaluable materials.
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 !
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.
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!
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.
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'm a graduate water engineer on the east coast of South Africa. I use Excel everyday for the last 4 years. These tips are going to greatly help me work more effectively
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.
@@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.
Thank you very much for putting your time into this Good Sir. I am an MSRED Grad Student working on a final project and your video was extremely useful to my efforts.
It's an amazing tutorial, I really have learned a lot. As, a beginner, I have to master these shortcuts and tricks to become competent in using excel along with other ms offices.
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.
Thank you for these, this filled in a few gaps a recent employment test revealed I had in my Excel knowledge. Your Top 25 is also better than other videos that said they were "intermediate." Formulas I know, some of these tools are new to me.
Very useful tips and trick, can't wait to apply them all. And now i realize need strong effort to deliver valueable information. Thats why i have to learn much more and never give up to have good chanel like yours. Thanks for share 🙂
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!!!
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
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
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
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 :)
That calendar picker is a great tip. Excellent for spreadsheets being issued to less technical users 👍
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 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
٣ ا ت
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
I've been working in Excel for years and learned lots of new stuff here. Well done!
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!!!!!
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!
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!
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.
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 Video Of Excel I Have Ever Seen Sir Great Value Addition!!!!* THANK YOU SO MUCH FOR SHARING!!!
बहुत ही शानदार‚ बहुत ही अच्छा ज्ञान दिया आपने आपका बहुत-बहुत धन्यवाद्।
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**
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!
One of the best videos o have seen on RUclips.
Short and concise, straight to the point.
Extremely useful.
Highly appreciated.
Please keep producing such invaluable materials.
Thanks. New video on Excel coming tomorrow.
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!
This is very informative video and explained very well. I don't know why 452 people disliked it. Good Work Sir.
Thanks for liking
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.
Very important but hidden stuff. Thank very much for your patient teaching.
Wow , my respects!! In the first three min you explained more than I can handle. THANKS YOUR AWESOME
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!
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.
I rarely use excel yet I am impressed by this video
That was truly a comprehensive tutorial. Nice job !
These, and the initial Tips & Tricks, make our assignment work much quicker. Thank you!
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'm a graduate water engineer on the east coast of South Africa. I use Excel everyday for the last 4 years. These tips are going to greatly help me work more effectively
Such an amazing tutorial to learn various useful tools that help you save your time while working with Excel. Thank you for your efforts.
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.
Very well done! Learning valuable Excel skills and ASMR, all in one.
One of the most useful and well explained videos I have ever seen
Thought I knew all about Excel, this just proved me wrong, really worth watching.
Concise and useful. Thanks for showing the analysis tools location.
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!
Check out the updated Excel 50 Ultimate Tips and Tricks video: ruclips.net/video/FXs3WG7M-qk/видео.html
Mind blown! I only thought I knew Excel. Great video, sir!
Very clear voice and understandable explanation. Very good job. Thanks.
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
One of the best excel videos. Important for any user. Thank you.
You are welcome!
Excellent professional method of teaching , Your Message was so clear. Respect!
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.
Learned a few good trick, thanks :)
Excellent professional , it's easy to understand of advanced excel . Thank you Sir
Wow. Absolutely brilliant. Great pace and clear instructions, excellent video presentation, and genuinely useful stuff. Superb. Subscribed and shared
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.
This tutorial video really gets me " wow", thank you so much!!!!!!
I didn't know about the Track Changes tool. What a discovery!
it changed my life!
This video is really a helpful one for MS-Excel advanced learners.
Awesome! Very informative and well explained. Thank you.
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.
7:30 let's convert teaspoons into cubic light years
Sounds like an idea for an Enhanced Advanced Video
Now that I've started using Excel, I realized it's a brilliant tool.
This was one of the best videos, I love this guy.
Jip! I think everyone learned atleast something from this list!
Awsome video with some very useful tips for everyday use. Thank you so much. Keep up the good work.
Very practical for everyday and business use. Thanks!
Thankful for giving complete insight of few excel shortcuts, tools and functions can be used.
Very informative and well explained. Thanks for sharing your expertise.
Wow this is very advanced omg I am not ready for this
Thank you very much for putting your time into this Good Sir. I am an MSRED Grad Student working on a final project and your video was extremely useful to my efforts.
Excellent, Glad that was helpful to you.
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
These are very useful tip and formulas 👍
Very helpful video! Thank you!
thanks a lot my good teacher. excel is too powerful in business
this one is direct to the point
This is excellent! Thank you so much. Keep the videos coming. These are the best I have seen on RUclips.
nice.. really amazing feature. I truly enjoy this video... Thank you so much
Dude, you are the Excel King! Thanks.
Happy to help!
A very good way to explain tips and tricks of excel😇😇😇
Great demonstration videos. I've learnt a lot by watching the video
Very good explained Thumps up
Great stuff - I have been using excel for 26 years, and several of these I did not know!
Excellent
Thank you for your video sir, I feel so much more confident now! :)
This guy is a life and money saver.
This was a great video. Great job. Thank you.
It's an amazing tutorial, I really have learned a lot. As, a beginner, I have to master these shortcuts and tricks to become competent in using excel along with other ms offices.
Great to hear!
You are really amazing sir... Keep going.... Very useful... Love ur videos😍😍😍
Really helpful tips, never thought about using these functions before.
Glad it was helpful!
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.
Thank you for these, this filled in a few gaps a recent employment test revealed I had in my Excel knowledge. Your Top 25 is also better than other videos that said they were "intermediate." Formulas I know, some of these tools are new to me.
You might be interested in my 10 Advanced Excel Functions. That has some interesting suggestions.
Great video. Crisp n clear. 💐
Awesome! Very specific and easy understanding. Thanks
Awesome Video. Learned many things. Thanks a lot.
Great stuff to learn about advanced excel, your voice is too good to listen
I appreciate that!
You had me at Live Transpose
Very useful tips and trick, can't wait to apply them all. And now i realize need strong effort to deliver valueable information.
Thats why i have to learn much more and never give up to have good chanel like yours. Thanks for share 🙂
Glad it was helpful!
@@SeleTraining thanks for share :)
Thanks for your great video.
I have a Cambridge IT practical tomorrow .. from watching this video and the first one I feel like am so ready
Excellent!
Great work, hope that you could make this series for Power BI.
Learned a lot. Thanks buddy. Keep it up!!
Glad to hear it!
The tips were very good.
Easy To understand. Clear directions & speaking! THX
This is great! Thank you!