Загрузка страницы

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
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
6 декабря 2019 г. 8:13:15
00:10:38
Яндекс.Метрика