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)

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee – https://www.buymeacoffee.com/SumitB

✅ Free Excel Course (Basic to Advanced) – https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course – https://bit.ly/free-excel-dashboard-course
✅ Free VBA course – https://bit.ly/excel-vba-course
✅ Free Power Query Course – https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

#Excel #ExcelTips #ExcelTutorial

Leave a Reply

Close Menu