Channel: Sele Training

Category: Science & Technology

Tags: excel tutorialexcel tips and tricksexcel shortcut tips and tricksusing microsoft excelshortcut keys in excelsele trainingexcel shortcut tipsbasic excel tutorialmicrosoft excelexcel tutoralpopular excel shortcutsexcelexcel insert chartadvanced excel tricksexcel 2016excel 2019advanced excelsurprising excel shortcutsexcel shortcutsexcel keyboard shortcuts

Description: These are not ordinary shortcuts. Here are some surprising shortcut tips and tricks that can save you a bunch of time in Excel. Support me with your Amazon purchases, click here: amzn.to/2Kxp533 Contents 0:00 1. Paste Values (Right Click-V) 0:16 2. Insert Selection (Drag-Shift) 0:35 3. Copy Selection (Drag-Ctrl) 1:01 4. Show Formulas (Ctrl-`) 1:19 5. Flash Fill (Ctrl-E) 1:36 6. Quick SUM (Alt-=) 1:57 7. Insert Date/Time (Ctrl-;/Ctrl-Shift-;) 2:10 8. Zoom In/Out (Ctrl-Mouse Wheel) 2:24 9. Autosize Columns/Rows (Doubleclick Divider) 2:42 10. Select Column/Row (Ctrl-Spacebar/Shift-Spacebar) 3:08 11. Create Chart (Alt-F1/F11) 3:24 12. Cell References (F4) 3:39 13. Add Notes (Shift-F2) 3:59 14. Hide Column/Row (Ctrl-9/Ctrl-0) 4:20 15. Filter (Ctrl-Shift-L) 4:31 16. Select Region (Ctrl-Shift-Spacebar) 4:56 17. Formatting 5:08 Format (Cells Ctrl-1) General (Ctrl-Shift-`) Number (Ctrl-Shift-1) Time (Ctrl-Shift-2) Date (Ctrl-Shift-3) Dollar (Ctrl-Shift-4) Percent (Ctrl-Shift-5) Scientific (Ctrl-Shift-6) 18. Copy Down/Right (Ctrl-D/Ctrl-R) 5:48 19. Table (Ctrl-T) 6:08 20. Apply/Remove Border (Ctrl-Shift-7/Ctrl-Shift—) 6:22 21. Workbook Statistics (Ctrl-Shift-G) 6:39 22. Expand Selection (Ctrl-Shift-Arrows) 6:55 23. Insert Multiple Rows (Right Click-Insert) 7:11 24. See Formula Results (F9) 7:30 25. Quick Analysis (Ctrl-Q) 7:54 #seletraining #excel #tipsandtricks