19 Advanced Excel Shortcuts (do you know them all?)
In this post I share 19 keyboard shortcuts for advanced Excel users. These techniques will help you save time and work sharp! You will learn how to:
1. Hide or filter out pivot items
2. Group rows and columns
3. Select visible cells
4. Show the active cell
5. Select corners of a selected range
6. Open the Go To Window
7. Find the next match or previous match
8. Enter a formula or value in all selected cells
9. Fill down or fill right
10. Copy formula text from above
11. Enter a line break in a cell
12. Modify cell styles
13. Select column or row differences
14. Select precedents and dependents
15. Open the Name Manager
16. Hide the Ribbon
17. Expand and collapse the formula bar
18. Autofit column width
19. Open the Selection Pane
If you’d like to see the accompanying blog post on my website, you can find it at this link: https://www.excelcampus.com/keyboard-shortcuts/advanced-excel-shortcuts/
Additional Resources:
7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel: https://www.youtube.com/watch?v=D8zNsJH7Mm8
7 Uncommon Excel Shortcuts to Teach to Your Coworkers: https://www.youtube.com/watch?v=KENSdcaHZI4
8 Keyboard Shortcuts for the VBA Editor in Excel: https://www.youtube.com/watch?v=IbEXB9X5kRo
5 Keyboard Shortcuts to Paste Values in Excel: https://www.youtube.com/watch?v=jd9PZd7Itzs
8 Keyboard Shortcuts for Number Formats in Excel (Win & Mac): https://www.youtube.com/watch?v=VdOAPSkwACU
#MsExcel #ExcelCampus
Видео 19 Advanced Excel Shortcuts (do you know them all?) канала Excel Campus - Jon
1. Hide or filter out pivot items
2. Group rows and columns
3. Select visible cells
4. Show the active cell
5. Select corners of a selected range
6. Open the Go To Window
7. Find the next match or previous match
8. Enter a formula or value in all selected cells
9. Fill down or fill right
10. Copy formula text from above
11. Enter a line break in a cell
12. Modify cell styles
13. Select column or row differences
14. Select precedents and dependents
15. Open the Name Manager
16. Hide the Ribbon
17. Expand and collapse the formula bar
18. Autofit column width
19. Open the Selection Pane
If you’d like to see the accompanying blog post on my website, you can find it at this link: https://www.excelcampus.com/keyboard-shortcuts/advanced-excel-shortcuts/
Additional Resources:
7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel: https://www.youtube.com/watch?v=D8zNsJH7Mm8
7 Uncommon Excel Shortcuts to Teach to Your Coworkers: https://www.youtube.com/watch?v=KENSdcaHZI4
8 Keyboard Shortcuts for the VBA Editor in Excel: https://www.youtube.com/watch?v=IbEXB9X5kRo
5 Keyboard Shortcuts to Paste Values in Excel: https://www.youtube.com/watch?v=jd9PZd7Itzs
8 Keyboard Shortcuts for Number Formats in Excel (Win & Mac): https://www.youtube.com/watch?v=VdOAPSkwACU
#MsExcel #ExcelCampus
Видео 19 Advanced Excel Shortcuts (do you know them all?) канала Excel Campus - Jon
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
25 AWESOME Excel Keyboard Shortcuts (You Should Know)!VLOOKUP Tutorial for Excel - Everything You Need To Know50 Ultimate Excel Tips and Tricks for 2020Top 10 Most Important Excel Formulas - Made Easy!Excel shortcut keys you SHOULD know!Top 60 Most Useful Excel Shortcuts - With Mind Mapping ► Easily MemorizingTOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips included☑️ Top 30 Advanced Excel Tips and TricksHow To Pass Advanced Excel Test For Job Interview10 Amazing (Less Known) Excel Tricks You Should KnowExcel Keyboard Shortcuts used by Pros5 Excel Functions YOU NEED in 20217 Uncommon Excel Shortcuts to Teach to Your CoworkersINDEX MATCH Explained (An Alternative to VLOOKUP)How to Combine Excel Tables or Worksheets with Power QueryExcel 2016 AdvancedHow to easily automate boring Excel tasks with Power Query!Secrets to Building Excel Dashboards in Under 15 Minutes!6 Useful MS Excel Hacks and Tricks | Work like a PRO7 Ways to Use Vlookup in Excel