If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
Nicolas Cage xyz NY 1436778 990 Route 5 20 Geneva NY 14456 311 RT 9W Glenmont NY 12077 Can I put comma automatically before NY with set up formula??? Like 990 Route 5 20 Geneva, NY 14456 311 RT 9W Glenmont, NY 12077 Need help with this... please make video on the above
@@TYoung023 I remember going into a job interview 10 years ago saying "I knew everything there is to know about Excel!".... to be young and naïve. Now? Oofth.... I'm convinced even the developers don't know all there is to know about Excel. I promise you don't need to justify your expertise to us TH-cam commenteres. The simple fact that you are commenting on an excel video on TH-cam most definitely on your free-time means that you're a class above most. Keep on learning babe.
@@JunkyJane I’ll never stop. In my experience, my knowledge of Excel has had a correlation to everything else I’ve ever learned..combined. I can learn some new function or method in Excel so well that I can make it do somersaults…and then 5 years later I have to learn half of it over again. New Excel knowledge has pushed out some of the old! 😆. That definitely helps to make it endless!
Thanks a lot. Just wanted to pointed 2 things. When grouping sheets together, need to be very careful not to forget to ungroup once done, otherwise you mess up all the sheets with unwanted changes. Using new window option to open a file twice is very very handy but if you use freeze panes, you will see that the file -2 will not have any freeze panes unlike file -1. If after using the files and you close the file-1 and then save and close file - 2. You would basically saved the file without any freeze panes. So the trick is to always close the second file, file-2. I had a lot of instance when I had to set all the freeze panes again until I found the culprit. Hope this helps.
30 years ago Excel sucked me in and while friends played their games I experimented with formulas and VBA. Today I'm called the Excel Wizard in my organization and everyone who handles long lists or numbers love my custom made macros and formulas. But your videos ALWAYS give me something new that I find very useful.
21 years of excel using but today i learnt something very very useful and helpful which i need most of the times i feel heck. You shared such a great knowledge bro. I could never imagine what excel keeps in it. its like whatever we can think and need, excel is providing us Thank you so much
I dint think much of this video when I first watched it..but I've found myself using these tips a lot just over the week. Had to search this video up again to comment. Great stuff!
Mindblowingly amazing video! Thank you so much! I have learned a lot of extremely useful tips today. Thank you so much! I think that for transforming the comma separated address data, you may want to search for ", " (note the trailing space) so that the vertically arranged data items will not have a leading space. You ROCK!
As a Share Trader this has given me so many options now for analysing and updating my Trading Journal. I currently have about 6 tabs that I must update on a daily basis to record market moves in my positions. You have given me a world of change and time saving ideas. Thank you. Liked and Subscribed.
adding to the new and excellent knowledge on excel, i am also automatically improving my english vocabulary, "now see what happens","instantly", etc to name a few
Some great tips in here! I especially love the "Filter based on Cell Value"!! That is definitely going to come in handy, as will the split screen. Thanks!
Yes, amazing is exactly what is was! Excellent time saving shortcuts! This will help me to review and edit massive budgets so much quicker. I can’t wait to use them! Thank you!!!!!!!!
Great video as always 👍, thanks for sharing. For #3, you can also filter based on cell value with a single click of the AutoFilter icon, while the cell is selected.
Some very good time saving tips that I didn't know exist. There was a time I thought I am good at Excel but when started knowing more I realized I am still a baby novice. Talking to a friend a few days ago about Excel, I said Excel is an Ocean and we have only crossed few small lakes separately. It's true indeed!
Thank you TrumpExcel!! Videos of your channel are really amazing and very informative. This is really helping me to do my work very accurately & efficiently . I had one question regarding line brake, in case if you want to change address or information which has "," to vertically in same cell is understood very clearly but what to be done if has to be done vice-versa.Please educate us on this as well. Thanks a lot. Keep it up!!
Thanks for your excellent job, please continue because it was so useful. I must aware that I knew only half of these tricks were presented in this video (after several years using Excel).
Thank you so much sir , explained clearly. Iam unable to catch your speed due to my language problem. Really feeling,you are a great tutor sir. Heartfelt thanks forever.
Great! There is always something you don't know, and this video has proved it again! Thanks for sharing these really valuable tips! Looking forward for more! 😊👍
Hi sumit..You are very good at teaching. I have been learning excel and hugely benefited watching your videos. I told my friends about your channel. Can u plz specify which operations can be performed while the sheets are grouped
Good stuff. Even on the one or two tricks I knew I wound up learning a new shortcut. If you had been in the next cube and asked if I wanted to see how to view multiple sheets (trick 10) I would have gladly handed over some cash to find out.
Filter on the selection is relatively new in Excel. However it’s of limited use since you cannot select multiple cells. It’s much better to write your own little macro to loop over the selected cells and add them to the autofilter.
![ตีสิบเดย์ [FULL] | อาจารย์โอเล่ ญาณสัมผัส ผ่าดวงคนดัง ประเทศไทยจะเป็นยังไงหลังจากนี้!](http://i.ytimg.com/vi/gszT2O76fL4/mqdefault.jpg)
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
Do you do company trainings? I need to hire someone
@@kashmoney1 I don't do training anymore. The entire focus is on creating content for the web
Nicolas Cage xyz NY 1436778
990 Route 5 20 Geneva NY 14456
311 RT 9W Glenmont NY 12077
Can I put comma automatically before NY with set up formula??? Like 990 Route 5 20 Geneva, NY 14456
311 RT 9W Glenmont, NY 12077
Need help with this... please make video on the above
@@kashmoney1 Sir I Do training for groups
Hi, please provide excel file also, so we can practice it .
20 years of Excel and still learning (even VBA). I’ve always said about Excel: “the more you know, the more you know you don’t know it all”!
Couldn't agree more. Excel is like infinate
Wtf? 20 years?
@@deepakshinge7780 At least 20. Very little professional use but tons of personal use. Not counting Lotus 1-2-3 or Quatro experience before that.
@@TYoung023 I remember going into a job interview 10 years ago saying "I knew everything there is to know about Excel!".... to be young and naïve. Now? Oofth.... I'm convinced even the developers don't know all there is to know about Excel. I promise you don't need to justify your expertise to us TH-cam commenteres. The simple fact that you are commenting on an excel video on TH-cam most definitely on your free-time means that you're a class above most. Keep on learning babe.
@@JunkyJane I’ll never stop. In my experience, my knowledge of Excel has had a correlation to everything else I’ve ever learned..combined. I can learn some new function or method in Excel so well that I can make it do somersaults…and then 5 years later I have to learn half of it over again. New Excel knowledge has pushed out some of the old! 😆. That definitely helps to make it endless!
Thanks a lot. Just wanted to pointed 2 things. When grouping sheets together, need to be very careful not to forget to ungroup once done, otherwise you mess up all the sheets with unwanted changes. Using new window option to open a file twice is very very handy but if you use freeze panes, you will see that the file -2 will not have any freeze panes unlike file -1. If after using the files and you close the file-1 and then save and close file - 2. You would basically saved the file without any freeze panes. So the trick is to always close the second file, file-2. I had a lot of instance when I had to set all the freeze panes again until I found the culprit. Hope this helps.
I especially like how you show the "traditional" way so I know exactly what I can replace with the techniques you present. Well done.
30 years ago Excel sucked me in and while friends played their games I experimented with formulas and VBA. Today I'm called the Excel Wizard in my organization and everyone who handles long lists or numbers love my custom made macros and formulas. But your videos ALWAYS give me something new that I find very useful.
Your first trick is unbelievable. Never heard of that anywhere else. It's a life saver for large data sets and long lists. Thanks a lot.
Even after using Excel for decades there are always new things to learn. Great work
Just to the point. No rubbish talk. Really helpful and easy.
21 years of excel using but today i learnt something very very useful and helpful which i need most of the times i feel heck. You shared such a great knowledge bro.
I could never imagine what excel keeps in it. its like whatever we can think and need, excel is providing us
Thank you so much
Clear, Simple,Lucid 🙏🙏🙏 Thanks ...Most Useful daily chores
Thanks for commenting Rajesh... Glad you found the video useful!
I dint think much of this video when I first watched it..but I've found myself using these tips a lot just over the week. Had to search this video up again to comment. Great stuff!
You did a great job quickly showing 10 amazing but uncommon tricks. I appreciate this!
Great
Always Giving high quality lessons
Sumit Bansil =High Quality
Thanks A Lot
Thanks for the kind words... Glad you found the video useful!
Comparing sheet side by side and splitting sheet are amazing excel tricks. Thank you so much Summit😃...
Thanks Suraj... Glad you found the video helpful 🙂
*great video, gets to the point, no stupid clickbait*
Mindblowingly amazing video! Thank you so much! I have learned a lot of extremely useful tips today. Thank you so much!
I think that for transforming the comma separated address data, you may want to search for ", " (note the trailing space) so that the vertically arranged data items will not have a leading space.
You ROCK!
Cool tricks thanks for sharing. Keyboard to move column/row ( Ctrl X then move to cell where to insert and Ctrl Shift = )
LOVE the fast column and row movement... and now I know the ALT-= trick instead of typing out a formula each time... Thanks.👍👍👍
Faster:
Select the colum,
Ctrl X (cut),
go to the next position,
and then Ctrl (num +)
As a Share Trader this has given me so many options now for analysing and updating my Trading Journal. I currently have about 6 tabs that I must update on a daily basis to record market moves in my positions. You have given me a world of change and time saving ideas. Thank you. Liked and Subscribed.
Thanks Sumit. The option (Tip #3) for filtring by cell value is available in Office 2013 and 2016.
Thanks for commenting Miguel... I wonder why I didn't use it earlier. Now that I know about it, I find it quite useful
adding to the new and excellent knowledge on excel, i am also automatically improving my english vocabulary, "now see what happens","instantly", etc to name a few
Some great tips in here! I especially love the "Filter based on Cell Value"!! That is definitely going to come in handy, as will the split screen. Thanks!
I learned some new things here today. Impressive knowledge you have. Thanks for sharing. I have subscribed! Looking forward to another lesson.
Just when I thought I knew it all! 8-). Thank you.
Thanks for commenting Sherri... Glad you found the video useful :)
Yes, amazing is exactly what is was! Excellent time saving shortcuts! This will help me to review and edit massive budgets so much quicker. I can’t wait to use them! Thank you!!!!!!!!
Great video as always 👍, thanks for sharing.
For #3, you can also filter based on cell value with a single click of the AutoFilter icon, while the cell is selected.
Thanks for commenting.. Good tip about AutoFilter
Hi Sir,
This is one of the best channel to learn tips and tricks in excel.
Sir Please make a videos on Power Pivot as well.
Some very good time saving tips that I didn't know exist. There was a time I thought I am good at Excel but when started knowing more I realized I am still a baby novice. Talking to a friend a few days ago about Excel, I said Excel is an Ocean and we have only crossed few small lakes separately. It's true indeed!
The way of your teaching is amazing.. kindly upload some more new excel functions...
Thanks Mr.
Sumit Bansal. Your channel are very helpful for us. When I fell any problem in Excel then I find solve in your channel. You are ...
Excellent video. The decimal point trick is perfect as I often enter currency in as data. The numbers always contain decimals. Thank you very much!
Excel is a wonderous program! I think to be an Excel expert would take years and years.
Thank you TrumpExcel!! Videos of your channel are really amazing and very informative. This is really helping me to do my work very accurately & efficiently . I had one question regarding line brake, in case if you want to change address or information which has "," to vertically in same cell is understood very clearly but what to be done if has to be done vice-versa.Please educate us on this as well. Thanks a lot. Keep it up!!
Very helpful for time saving of my day to day work
Always learning. Thank you for sharing your knowledge Sir
Like the way you list out topics with time stamps..that's really helpful.
Thanks for taking time to share your expertise!
Simply awesome. I am not easy to be impressed when it comes to excel but...just 2 videos of yours and I have already subscribed your channel.
Excellent features described with clear understand. Good work
Great lessons, great delivery, great narration! Thanks for these very valuable lessons!😊🎉
You really explain in a very easy and moreover in an effective way. Thanks a lot to make us educated 👍👍
Thanks for the kind words Anand... Glad you found the video useful!
In fact I got it what I expected long time. Thank you sir.
I have to watch this video again, so much useful stuff in here.
Thanks for your excellent job, please continue because it was so useful. I must aware that I knew only half of these tricks were presented in this video (after several years using Excel).
I share your resources and tutorials with my students. Thank you!
Thanks for sharing the content... Happy to know you find it useful :)
You had me on the very first shortcut!!! Never knew that existed and what a time saver.
Learning a lot from you Brother ..
You're really helping everyone here to achieve things faster in Excel ..
Thanks for sharing your knowledge .. :)
Thanks for the kind words Harshith.. glad you liked the video
My "Like" does not describe how useful this video is. Thanks so much!
Thank you so much sir , explained clearly.
Iam unable to catch your speed due to my language problem.
Really feeling,you are a great tutor sir.
Heartfelt thanks forever.
Thank you so much. You have shown me stuff I did not know. Appreciate you sharing with us!
I salute you brother.. You are phenomenal..
I knew these tricks years ago, but anyway thank you very much.
Brillliant video, I am happy I came across this video by happenstance. Thank you!!!
Submit Bansal , you are the best thing ever to happen to my excel life. Thank you so much
Great! There is always something you don't know, and this video has proved it again! Thanks for sharing these really valuable tips! Looking forward for more! 😊👍
Thanks for commenting Vijay... Glad you found the video useful!
Thx for the quick access toolbar tip.
Thank you, really cool stuff, been using excel for years and only knew a handful of these. Thanks for sharing.
Excellent video, very clear instructions.
Wow, some I knew, most I didn't. Kudos to you and thanks for sharing.
Glad you found the video useful!
Last one was highly useful, thank you very much Sumit. ❤️
I really like your tips. They are extremely interesting.
Thank you very much.
Very useful information. Some heavy work easy. Thanks you 🙏
All trick is superb.
Really really very useful shortcuts. Great video you share with us. Thanks
I have excelled to the top of my company thanks to your videos. I made this rlly bad ass calculator
Awesome! Super happy to know the videos are helpful :)
@@trumpexcel they rlly are!
I have definitely learned new shortcuts. You are amazing, Thank you!
Excellent and very clearly explained.
Thank you. I will be back to look at this again. Very helpful.
Thanks for providing informative vdo in a very simple method
Keep it up
👍👍👍👍👍👍
Awesome,...Every time I watch your videos I learn something new.
Finally I found you brother this is very useful
Very useful tips, clearly presented. Thanks for sharing them with us.
Glad you found the video useful!
Thank you very much for the knowledge. I learned a lot.
Very Very Useful Video for Daily Users of Excel..Great Gob..
Dude, these are some SUPER useful tips! You've got yourself a new subscriber!
I just found this channel. Outstanding tips and tricks. Liked and subscribed.
Handy tips that I didn't even know I needed.
Hi sumit..You are very good at teaching. I have been learning excel and hugely benefited watching your videos. I told my friends about your channel. Can u plz specify which operations can be performed while the sheets are grouped
sir thankyou for that split function. love excel even more. love u sir.
EXTREMELY helpful and informative. Thank you!
Thank you. I learned so much.
Nice and useful. They are for very particular tasks but nevertheless can save some hour or two of manual work.
Excellent practical issues which have been well addressed. Really insightful and i found it very useful. Thanks.
Thanks for these tips and showing how to use them.
So good the material you have sir! Helped a lot for my job tasks, thanks a lot!!
Good stuff. Even on the one or two tricks I knew I wound up learning a new shortcut. If you had been in the next cube and asked if I wanted to see how to view multiple sheets (trick 10) I would have gladly handed over some cash to find out.
Very useful tips! Congrats and thank you!
Thanks, found couple of these tricks to be very useful!
Good job, wasn't aware of many of these tips even though i have been using Excel for years!
Thanks for commenting Rishi... Glad you found the video useful!
I learned 6 things today - you should get 6 Thumbs Up, but I could only give one.
Thanks for the excellent tips.
Good work bro ..thanks for making excel a bit easier
Great video! The split screen trick at the end is so helpful. Thanks!
Very nice I learned something new Thank you
Very nice ; lot of tips not known before ; Thank you
Your voice is very clear, able to understand each step..
Glad you found the video useful!
Wow I have learned so much in just 15 mins! Just subscribed!
Thanks :) Glad you found the video useful
Thank you my friend for providing such stuff FOC.
Filter on the selection is relatively new in Excel. However it’s of limited use since you cannot select multiple cells. It’s much better to write your own little macro to loop over the selected cells and add them to the autofilter.
Nice tips! Especially the ALT = for column sum.
Well explained & informative.