🤯 23 HIDDEN Excel Tricks You (Probably) Don't Know

🤯 23 HIDDEN Excel Tricks You (Probably) Don't Know

20.452 Lượt nghe
🤯 23 HIDDEN Excel Tricks You (Probably) Don't Know
In this video, I will show you some of the hidden tricks in Excel that you can use in your day-to-day work. I call them hidden as most of these options are not readily available and are often hidden in different places. I have also not seen many people use them. 00:00 Intro 00:21 Control & Fill Handle 01:14 Autofill Months Trick 02:17 Quick Filter Trick 04:00 Scroll Horizontal Shortcut 04:40 Autosum Trick 05:56 Get Running Totals Fast 06:36 Truly Hide Cell Values 08:13 Copy from Status Bar 09:34 Disable Automatic Data Conversion 12:03 Automatically Place Decimals 13:22 Move Right After Enter 14:46 Open Specific File on Excel Startup 16:59 Sort Left to Right 18:59 Create Custom Sort Criteria 21:33 Delete Hidden Rows and Sheets Fast 23:06 Quick Access Toolbar Shortcuts 24:24 Formula Argument Shortcuts 25:57 Disable Row Insertion or Deletion 27:11 Move Rows and Columns (Fastest Way) 28:59 Count Workdays Between Dates 32:03 Unhide Multiple Sheets & Deselect After Selection 33:09 Make Sheet Very Hidden 35:25 Split Screen ☕ 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 #SumitBansal