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
Видео Top 25 Excel Shortcut Tips and Tricks канала Sele Training
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
Видео Top 25 Excel Shortcut Tips and Tricks канала Sele Training
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
iPhone iOS 11 Screen RecordingOffice 365 Skype for Business Auto AttendantSkype for Business LicensingBoost Your PC Speed!The New MoFi 5500Excel Dynamic Array FormulasRemove Background from ImageMastering Excel in 2024 - New Functions!Help a YouTube CreatorMastering Excel in 2024 - Best Time-Saving TipsOutlook Mail Merge with Excel and WordThe Best New Excel FeaturesRecord Your Screen Using PowerPointExcel 2020 Best Tips and TricksFix Windows Crash Issues with the DISM ToolExcel XLOOKUPHow to Use Excel FormulasExcel for Finance and AccountingMoFi 4500 UpdateDigitize Your DVD Movie CollectionExcel Slicers - The Cool Way to Filter Data!