Hellow guys, Welcome to my website, and you are watching 19 Advanced Excel Shortcuts You Might Not Know. and this vIdeo is uploaded by Excel Campus - Jon at 2019-12-05T19:13:15-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| 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 |
| 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 |
