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
Видео 10 Amazing (Less Known) Excel Tricks You Should Know канала TrumpExcel
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
Видео 10 Amazing (Less Known) Excel Tricks You Should Know канала TrumpExcel
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
7 Clever Excel Custom Formatting Tricks (Advanced)Top 10 Most Important Excel Formulas - Made Easy!Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...25 AWESOME Excel Keyboard Shortcuts (You Should Know)!How to Compare Two Excel Sheets (and find the differences)TOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips included10 awesome things you can do in Excel - WITHOUT any formulas or pivotsMicrosoft Excel Tutorial for Beginners - Full CourseHow to easily automate boring Excel tasks with Power Query!14 Computer Tricks You Wish You Learned Sooner10 Excel XLOOKUP Function Examples (Better than VLOOKUP & INDEX/MATCH)50 Ultimate Excel Tips and Tricks for 2020Dynamic Filter in Excel - Filter As You Type (with & without VBA)5 Awesome Excel Keyboard and Mouse TricksExcel LAMBDA Function6 FREE Add-Ins for Excel to Start Using Now10 Super Neat Ways to Clean Data in Excel10 Excel formatting tricks *ONLY* experts know19 Advanced Excel Shortcuts (do you know them all?)Data cleaning in Excel - 10 tricks *PROs* use all the time