7 Uncommon Excel Shortcuts to Teach to Your Coworkers
In this video, I share 7 Excel shortcuts that every Excel user should know. These are not common keyboard shortcuts like Ctrl+C or Ctrl+V, but will save a lot of time when working in Excel and navigating worksheets. They’re all really easy to learn and with a little bit of practice, you’ll have them memorized in no time.
If you’d like to see the accompanying blog post on my website, you can find it here: https://www.excelcampus.com/keyboard-shortcuts/uncommon-shortcuts/
The shortcuts that are covered are listed below (with the Mac equivalents in parentheses):
1. Open Various Options Menu with Alt+Down Arrow (Opt+Down Arrow) 0:17
2. Repeat Last Action with F4 (Cmd+Y) 1:51
3. Select Used Cells in Column with Ctrl+Shift+Down Arrow 2:30
4. Copy Sheet(s) with Ctrl+Drag (Opt+Drag) 3:48
5. Select Previous/Next Sheet with Ctrl+Page Up/Down (Fn+Cmd+Up/Down Arrow) 4:38
6. Insert Today’s Date with Ctrl+; 5:16
Insert Current Time with Ctrl+Shift+; (Opt+;) 5:50
7. Insert Sum Formula with Alt+= (Opt+Shift+T) 6:30
Additional Resources:
2 Keyboard Shortcuts to Select a Column with Blank Cells in Excel: https://www.youtube.com/watch?v=b8By_uVpBw8
7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel: https://www.youtube.com/watch?v=D8zNsJH7Mm8
7 Keyboard Shortcuts for the Filter Drop Down Menus:
https://www.excelcampus.com/keyboard-shortcuts/filter-dropdown-menu-shortcuts/
Best Keyboards for Excel Keyboard Shortcuts: https://www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/
How Dates & Times Work in Excel: https://www.excelcampus.com/functions/how-dates-work-in-excel/
#MsExcel #ExcelCampus #ExcelShortcuts
Видео 7 Uncommon Excel Shortcuts to Teach to Your Coworkers канала Excel Campus - Jon
If you’d like to see the accompanying blog post on my website, you can find it here: https://www.excelcampus.com/keyboard-shortcuts/uncommon-shortcuts/
The shortcuts that are covered are listed below (with the Mac equivalents in parentheses):
1. Open Various Options Menu with Alt+Down Arrow (Opt+Down Arrow) 0:17
2. Repeat Last Action with F4 (Cmd+Y) 1:51
3. Select Used Cells in Column with Ctrl+Shift+Down Arrow 2:30
4. Copy Sheet(s) with Ctrl+Drag (Opt+Drag) 3:48
5. Select Previous/Next Sheet with Ctrl+Page Up/Down (Fn+Cmd+Up/Down Arrow) 4:38
6. Insert Today’s Date with Ctrl+; 5:16
Insert Current Time with Ctrl+Shift+; (Opt+;) 5:50
7. Insert Sum Formula with Alt+= (Opt+Shift+T) 6:30
Additional Resources:
2 Keyboard Shortcuts to Select a Column with Blank Cells in Excel: https://www.youtube.com/watch?v=b8By_uVpBw8
7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel: https://www.youtube.com/watch?v=D8zNsJH7Mm8
7 Keyboard Shortcuts for the Filter Drop Down Menus:
https://www.excelcampus.com/keyboard-shortcuts/filter-dropdown-menu-shortcuts/
Best Keyboards for Excel Keyboard Shortcuts: https://www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/
How Dates & Times Work in Excel: https://www.excelcampus.com/functions/how-dates-work-in-excel/
#MsExcel #ExcelCampus #ExcelShortcuts
Видео 7 Uncommon Excel Shortcuts to Teach to Your Coworkers канала Excel Campus - Jon
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
19 Advanced Excel Shortcuts (do you know them all?)50 Ultimate Excel Tips and Tricks for 202010 Super Neat Ways to Clean Data in ExcelBEST Excel Shortcuts for Business & FinanceINDEX MATCH Explained (An Alternative to VLOOKUP)Most Useful Excel Keyboard Shortcuts25 AWESOME Excel Keyboard Shortcuts (You Should Know)!A Real-Life Excel Test from a Job Interview: Can You Pass??How to Shortcut Your Shortcuts Without a Mouse | No Mouse ExcelHow to easily automate boring Excel tasks with Power Query!How to Combine Excel Tables or Worksheets with Power QueryThe New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel15 MUST KNOW Excel Keyboard Shortcuts to Speed-up WorkExcel Goal Seek Explained in Simple StepsIF Formula Tutorial for Excel - Everything You Need To KnowWhat is the Best Way to Split Text in Excel?🔎 How to Create Searchable Drop Down List in ExcelExcel Shortcut Keys | Full GuideEXCEL KEYBOARD SHORTCUTS Everyone Should Know!