10 Amazing (Less Known) Excel Tricks You Should Know

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)

#Excel #ExcelTips #ExcelTutorial

[trumpexcel]

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:

[TYoung]

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

[razwanahamed]

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

[cathyb]

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

[MrSweck]

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.

[ersins.]

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.

[raccoon]

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

[parmindarsingh]

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.

[patricklonski]

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

[rajesh]

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

[c.f.]

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

[jananisrinivasan]

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!

[MianMithu]

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

[surajbhardwaj]

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

[wunpawngmangshang]

Thanks for taking time to share your expertise!

[reformerx]

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

[wandagreer]

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

[RealityCheck]

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

[ProfessorPhysics]

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

[miteshvaidya]

Excellent features described with clear understand. Good work