Top 25 Excel Shortcut Tips and Tricks

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: https://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

الفئة