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