No video :(

10 Amazing (Less Known) Excel Tricks You Should Know

Подписаться 375 тыс.

Просмотров 567 тыс.

50% 1

In this video, I covered 10 less known but amazing Excel tricks it can save you a lot of time.
These are simple Excel tricks that you can use in your day-to-day work and be more efficient
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)
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 489

@trumpexcel 3 года назад

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

@kashmoney1 3 года назад

Do you do company trainings? I need to hire someone

@trumpexcel 3 года назад

@@kashmoney1 I don't do training anymore. The entire focus is on creating content for the web

@SN-ks7zj 3 года назад

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

@AnandGautam9901 3 года назад

@@kashmoney1 Sir I Do training for groups

@akashdeshmukh116 3 года назад

Hi, please provide excel file also, so we can practice it .

@TYoung023 3 года назад

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”!

@Darienninety4 3 года назад

Couldn't agree more. Excel is like infinate

@deepakshinge7780 2 года назад

Wtf? 20 years?

@TYoung023 2 года назад

@@deepakshinge7780 At least 20. Very little professional use but tons of personal use. Not counting Lotus 1-2-3 or Quatro experience before that.

@JunkyJane 2 года назад

@@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 RU-vid commenteres. The simple fact that you are commenting on an excel video on RU-vid most definitely on your free-time means that you're a class above most. Keep on learning babe.

@TYoung023 2 года назад

@@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!

@cathyb2204 3 года назад

I especially like how you show the "traditional" way so I know exactly what I can replace with the techniques you present. Well done.

@parmindarsingh1757 3 года назад

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.

@ersins.1941 3 года назад

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.

@razwanahamed520 2 года назад

Just to the point. No rubbish talk. Really helpful and easy.

@patricklonski 3 года назад

Even after using Excel for decades there are always new things to learn. Great work

@jennydrumm7223 3 года назад

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!

@jananisrinivasan9886 2 года назад

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!

@c.f.405 2 года назад

You did a great job quickly showing 10 amazing but uncommon tricks. I appreciate this!

@bonnie4026 3 года назад

You had me on the very first shortcut!!! Never knew that existed and what a time saver.

@sherrilbjalexander2856 3 года назад

Just when I thought I knew it all! 8-). Thank you.

@trumpexcel 3 года назад

Thanks for commenting Sherri... Glad you found the video useful :)

@kaesuma 3 года назад

I have definitely learned new shortcuts. You are amazing, Thank you!

@rajesh844 3 года назад

Clear, Simple,Lucid 🙏🙏🙏 Thanks ...Most Useful daily chores

@trumpexcel 3 года назад

Thanks for commenting Rajesh... Glad you found the video useful!

@raccoon874 2 года назад

*great video, gets to the point, no stupid clickbait*

@reformerx667 2 года назад

I have to watch this video again, so much useful stuff in here.

@ProfessorPhysics 3 года назад

LOVE the fast column and row movement... and now I know the ALT-= trick instead of typing out a formula each time... Thanks.👍👍👍

@lgvdbroek 2 года назад

Faster: Select the colum, Ctrl X (cut), go to the next position, and then Ctrl (num +)

@surajbhardwaj428 4 месяца назад

Comparing sheet side by side and splitting sheet are amazing excel tricks. Thank you so much Summit😃...

@trumpexcel 4 месяца назад

Thanks Suraj... Glad you found the video helpful 🙂

@tempestcapital3006 2 года назад

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.

@leos280 3 года назад

Like the way you list out topics with time stamps..that's really helpful.

@RealityCheck1980 2 года назад

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!!!!!!!!

@soniccheese01 3 года назад

Cool tricks thanks for sharing. Keyboard to move column/row ( Ctrl X then move to cell where to insert and Ctrl Shift = )

@YouExcelTutorials 3 года назад

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.

@trumpexcel 3 года назад

Thanks for commenting.. Good tip about AutoFilter

@MianMithu 3 года назад

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

@speedsecrets7020 3 года назад

Great video! The split screen trick at the end is so helpful. Thanks!

@rory1653 3 года назад

Great little hints there, thank you 🙏

@madirit1 3 года назад

I really like your tips. They are extremely interesting. Thank you very much.

@ernstgenzs7456 2 года назад

Thank you so much. You have shown me stuff I did not know. Appreciate you sharing with us!

@TheBachelor916 2 года назад

Thx for the quick access toolbar tip.

@shahzadsami5613 3 года назад

Great Always Giving high quality lessons Sumit Bansil =High Quality Thanks A Lot

@trumpexcel 3 года назад

Thanks for the kind words... Glad you found the video useful!

@vijayarjunwadkar 3 года назад

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! 😊👍

@trumpexcel 3 года назад

Thanks for commenting Vijay... Glad you found the video useful!

@shashinair7881 2 года назад

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

@wandagreer9144 2 года назад

I learned some new things here today. Impressive knowledge you have. Thanks for sharing. I have subscribed! Looking forward to another lesson.

@patrickschardt7724 3 года назад

As always great stuff. I need to remember these

@trumpexcel 3 года назад

Thanks for commenting Patrick... Glad you found the video useful!

@bty1461 3 года назад

Submit Bansal , you are the best thing ever to happen to my excel life. Thank you so much

@baburajankumaran3768 2 года назад

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!

@renatovallessoto6511 3 года назад

My "Like" does not describe how useful this video is. Thanks so much!

@arkady714 2 года назад

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!

@serdip 3 года назад

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!

@adityasharma0101 3 года назад

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.

@questionresearch8721 3 года назад

Thank you. I will be back to look at this again. Very helpful.

@K2KnowledgeKrishnaKumar 2 года назад

All trick is superb.

@venkasom 3 года назад

Excellent practical issues which have been well addressed. Really insightful and i found it very useful. Thanks.

@miteshvaidya5386 2 года назад

Excellent features described with clear understand. Good work

@FranktheDachshund 2 года назад

Handy tips that I didn't even know I needed.

@zlee11 Год назад

Thank you. I learned so much.

@wunpawngmangshang1688 2 года назад

Thanks for taking time to share your expertise!

@abdofeduconsult 3 года назад

Useful tips. Thanks

@Apoorvashetty18 3 года назад

Thank you so much for this :)

@InsightfulJourney123 3 года назад

Wow! Thank you! 🙏

@arielspalter7425 3 года назад

Dude, these are some SUPER useful tips! You've got yourself a new subscriber!

@aramroshani6197 3 года назад

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).

@GunnerAl9 2 года назад

Excellent video, very clear instructions.

@mehmetkaya4330 3 года назад

Great tips! Thank you sooo much!

@tedmoy 2 года назад

EXTREMELY helpful and informative. Thank you!

@TheGmiah 3 года назад

Wow, learnt so much! Thanks a lot :)

@Hexa1123 2 года назад

Brillliant video, I am happy I came across this video by happenstance. Thank you!!!

@Larwai 2 года назад

I knew these tricks years ago, but anyway thank you very much.

@monirhossain9850 3 года назад

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 ...

@basementtunes 3 года назад

Thank you. This was so awesome.

@jbcosta51 3 года назад

Always learning. Thank you.

@kamalshrestha1276 3 года назад

Always something to learn!!👌

@ln1977 2 года назад

Thank you, really cool stuff, been using excel for years and only knew a handful of these. Thanks for sharing.

@MsOfficeLearning 3 года назад

Thank you for your lesson!

@Florinda6060 2 года назад

Amazing! Thank you 🙏

@eltonm.t.873 2 года назад

Very useful tips! Congrats and thank you!

@maheshsrikanthsirwalkar1500 3 года назад

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!!

@aanand2017 3 года назад

You really explain in a very easy and moreover in an effective way. Thanks a lot to make us educated 👍👍

@trumpexcel 3 года назад

Thanks for the kind words Anand... Glad you found the video useful!

@manishbaps 3 года назад

Loved this video..Thanks for sharing the tips...

@paulamccall9621 2 года назад

Always learning. Thank you for sharing your knowledge Sir

@silvestrecamposano6317 Год назад

Thank you very much for the knowledge. I learned a lot.

@sonicmach1 3 года назад

Thanks for these tips and showing how to use them.

@mariabc9815 3 года назад

Thanks for the tips and tricks. It's really helpful.

@dave3459 Год назад

Great tips! Very useful!

@pupycron4302 2 года назад

This was great. Thank you.

@harshiths2337 3 года назад

Learning a lot from you Brother .. You're really helping everyone here to achieve things faster in Excel .. Thanks for sharing your knowledge .. :)

@trumpexcel 3 года назад

Thanks for the kind words Harshith.. glad you liked the video

@bzflowerbee 3 года назад

Thanks! Very useful tip.

@ajlifesolutions7072 2 года назад

Nice tips! Especially the ALT = for column sum.

@chandikaprashan661 Год назад

Very helpful. Thank you.

@radar2609 Год назад

Great lessons, great delivery, great narration! Thanks for these very valuable lessons!😊🎉

@mosesfrancis4976 2 года назад

In fact I got it what I expected long time. Thank you sir.

@MuhammadTayyab-vr9sf 2 года назад

Great! Almost all your videos are spectacular.

@rudycramer225 2 года назад

Excel is a wonderous program! I think to be an Excel expert would take years and years.

@apwnew 2 года назад

Nice Job! Thank you!

@antygona-iq8ew 3 года назад

Nice and useful. They are for very particular tasks but nevertheless can save some hour or two of manual work.

@nradhakrishnan3717 2 года назад

Great tips.. thank you Sumeet

@patrickmadziar3860 3 года назад

Very useful tips, clearly presented. Thanks for sharing them with us.

@trumpexcel 3 года назад

Glad you found the video useful!

@SolidSnake59 3 года назад

Really cool tricks. Thanks!

@SalihArtAndTech 2 года назад

Very Informative. Thank you 👍

@devatheshmirra8176 2 года назад

Thank you my friend for providing such stuff FOC.

@waqaramir8526 3 года назад

great... awesome info

@muthusubramanianv428 Год назад

Excellent and very clearly explained.

@ahammadgalib5810 2 года назад

Amazing. Thanks a lot

@spamdump4459 2 года назад

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.