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.
@@Junk_Jane 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!
00:00 Intro 00:12 Repeat Headers in Printed Pages (Name Box Trick) 01:10 Convert Number of Percentage (Paste Special Trick) 01:54 Filter Data based on Cell Value (two-click method) 02:35 Automatically Insert Decimal Point when Typing 03:55 Quickly Add Line Breaks (Find and Replace trick) 05:34 Quick Access Toolbar Shortcuts Trick 07:55 Split Screen to Compare Data 10:23 Move Rows and Column in Excel (Drag and Drop trick) 12:51 Group Sheets and Make Changes in One Go 15:04 Compare Sheets in the Same workbook (Side by Side)
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.
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!
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.
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
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!!!!!!!!
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!
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
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.
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!
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.
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 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!!
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
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! 😊👍
Excellent tricks. I believed that I am very handy with Excel. But I only knew one of these 10 tricks. Well good for me, I just learnt few more things. Am I a pro now :-)
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.
@@Junk_Jane 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!
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.
Just to the point. No rubbish talk. Really helpful and easy.
I especially like how you show the "traditional" way so I know exactly what I can replace with the techniques you present. Well done.
00:00 Intro
00:12 Repeat Headers in Printed Pages (Name Box Trick)
01:10 Convert Number of Percentage (Paste Special Trick)
01:54 Filter Data based on Cell Value (two-click method)
02:35 Automatically Insert Decimal Point when Typing
03:55 Quickly Add Line Breaks (Find and Replace trick)
05:34 Quick Access Toolbar Shortcuts Trick
07:55 Split Screen to Compare Data
10:23 Move Rows and Column in Excel (Drag and Drop trick)
12:51 Group Sheets and Make Changes in One Go
15:04 Compare Sheets in the Same workbook (Side by Side)
Thank you
Even after using Excel for decades there are always new things to learn. Great work
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.
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!
Clear, Simple,Lucid 🙏🙏🙏 Thanks ...Most Useful daily chores
Thanks for commenting Rajesh... Glad you found the video useful!
*great video, gets to the point, no stupid clickbait*
You did a great job quickly showing 10 amazing but uncommon tricks. I appreciate this!
Amazing! it's easy to follow. Thank you very much. Very helpful tricks!
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.
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
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!!!!!!!!
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 🙂
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 +)
Thanks for taking time to share your expertise!
Just when I thought I knew it all! 8-). Thank you.
Thanks for commenting Sherri... Glad you found the video useful :)
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!
Great
Always Giving high quality lessons
Sumit Bansil =High Quality
Thanks A Lot
Thanks for the kind words... Glad you found the video 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
The way of your teaching is amazing.. kindly upload some more new excel functions...
Always learning. Thank you for sharing your knowledge Sir
Thx for the quick access toolbar tip.
Excel is a wonderous program! I think to be an Excel expert would take years and years.
Last one was highly useful, thank you very much Sumit. ❤️
Excellent features described with clear understand. Good work
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 ...
You had me on the very first shortcut!!! Never knew that existed and what a time saver.
Cool tricks thanks for sharing. Keyboard to move column/row ( Ctrl X then move to cell where to insert and Ctrl Shift = )
Very helpful for time saving of my day to day work
Submit Bansal , you are the best thing ever to happen to my excel life. Thank you so much
Excellent video, very clear instructions.
I learned some new things here today. Impressive knowledge you have. Thanks for sharing. I have subscribed! Looking forward to another lesson.
My "Like" does not describe how useful this video is. Thanks so much!
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!
Like the way you list out topics with time stamps..that's really helpful.
Great lessons, great delivery, great narration! Thanks for these very valuable lessons!😊🎉
All trick is superb.
Absolutely brilliant 👍👍👍
Thank you. I learned so much.
I salute you brother.. You are phenomenal..
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
Excellent tricks and great presentation.
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!
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.
Thanks for providing informative vdo in a very simple method
Keep it up
👍👍👍👍👍👍
Very useful tips! Congrats and thank you!
Thank you. I will be back to look at this again. Very helpful.
Always learning. Thank you.
In fact I got it what I expected long time. Thank you sir.
Great! Almost all your videos are spectacular.
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
Finally I found you brother this is very useful
Brillliant video, I am happy I came across this video by happenstance. Thank you!!!
Thank you for your lesson!
Very useful information. Some heavy work easy. Thanks you 🙏
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).
Amazing! Thank you 🙏
Thanks for these tips and showing how to use them.
I share your resources and tutorials with my students. Thank you!
Thanks for sharing the content... Happy to know you find it useful :)
Great tips.. thank you Sumeet
Very Very Useful Video for Daily Users of Excel..Great Gob..
Really really very useful shortcuts. Great video you share with us. Thanks
Thank you so much. You have shown me stuff I did not know. Appreciate you sharing with us!
Well explained & informative.
Thank you very much for the knowledge. I learned a lot.
Wow! Thank you! 🙏
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!!
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.
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 just found this channel. Outstanding tips and tricks. Liked and subscribed.
Thank you my friend for providing such stuff FOC.
WOW! Fantastic! Thank you so much!
Thanks for commenting Dona... Glad you found the video useful!
This video is 💯 incredible. Thaaaaaank you sir
Very Informative. Thank you 👍
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
Superb vid - thank you!
nice tutorial. good job. thanks
Excellent,
Excellent,
Excellent!!!
Glad you liked the video :)
Wow, some I knew, most I didn't. Kudos to you and thanks for sharing.
Glad you found the video useful!
So many great tips in this video. Thanks for publishing this.
Glad you found the video useful!
Thank you, really cool stuff, been using excel for years and only knew a handful of these. Thanks for sharing.
Always something to learn!!👌
Very helpful. Thx 🙏
Lots of good new tips here. Thanks
Thanks for commenting Seamus... Glad you found the video useful!
Very very very useful tips man.❤️
Thanks, found couple of these tricks to be very useful!
Thank you, excellent tips
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!
Very nice I learned something new Thank you
Awesome,...Every time I watch your videos I learn something new.
Useful tips. Thanks
Excellent tricks. I believed that I am very handy with Excel. But I only knew one of these 10 tricks. Well good for me, I just learnt few more things. Am I a pro now :-)
Your voice is very clear, able to understand each step..
Glad you found the video useful!