Hi guys, Welcome to the Advanced Video Search Engine, and you are watching 19 Advanced Excel Shortcuts You Might Not Know. That video is uploaded by Excel Campus - Jon at 2019-12-05T19:13:15-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [5pwV7ERbXjk]
| Name | 19 Advanced Excel Shortcuts You Might Not Know |
| Video Uploader | Video From Excel Campus - Jon |
| Upload Date | This Video Uploaded At 06-12-2019 03:13:15 |
| Video Discription | Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ 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 00:00 Introduction 00:33 Filter Out Items in Pivot Tables 01:07 Group Rows and Columns 01:36 Select Visible Cells 02:01 Show the Active Cell 02:12 Select Corners of Selected Range 02:31 Open the Go To Window 02:48 Find the Next or Previous Match 03:46 Enter Formula/Value in All Selected Cells 04:12 Fill Down 04:48 Copy Formula Text From Above 05:34 Line Breaks 06:01 Modifying Cell Style 06:31 Selecting Cells with Differences 07:08 Selecting Precedents and Dependents 08:11 Named Ranges 08:46 Expand or Collapse the Formula Bar 5pwV7ERbXjk |
| Category | Education |
| Tags | excel | excel campus | advanced excel shortcuts | advanced excel shortcuts and formulas | advanced excel shortcuts pdf | advanced excel tricks | coursedots | excel 2016 | excel advanced | excel formulas | excel keyboard shortcuts | excel shortcuts | excel tips and tricks | excel tips and tricks 2019 | excel tutorial | introduction to excel | keyboard shortcut keys | microsoft excel tips | microsoft office | microsoft office suite tutorial | power tips for excel | shortcutkeys |
