Top Excel Keyboard Shortcuts You DON'T Know (For Utilizing Excel Objects, Macros, & Pivot Tables)
Top Excel Keyboard Shortcuts You DON'T Know (For Utilizing Excel Objects, Macros, & Pivot Tables)
In this Excel tutorial we’ll discuss the top 10 keyboard shortcuts for using objects, macros, and pivot tables in Microsoft Excel.
More specifically, we’ll cover:
01 Inserting an Object (Alt + Access Keys)
02 Duplicating an Object (Ctrl + D)
03 Snapping an Object to the Grid (within Excel) (Alt)
04 Hiding or Showing Objects (Ctrl + 6)
05 Selecting All (Similar) Objects (Crtl + A)
06 Opening the Macro Dialog Box (Alt + F8)
07 Opening the VBA Editor (Alt + F11)
08 Creating a Pivot Table (via the Pivot Table Wizard) (Alt + D … P)
09 Selecting the Entire Contents of a Pivot Table (Ctrl + A)
10 Toggling a Pivot Table Field Checkbox On or Off (Spacebar)
11 Creating a Pivot Chart on a New Worksheet (F11)
This is video 20 of 20 in our “Top Excel Keyboard Shortcuts You DIDN'T Know” Series.
For those of you interested, go ahead and…
Download the corresponding Excel Files Here: https://goo.gl/YKKJqZ
Checkout the ProductivityMe Top Excel Keyboard Shortcuts You DIDN'T Know Playlist Here: https://goo.gl/n5Lx38
We want to help you master Microsoft Excel- Let us know what you think of this video!
Feel free to give us a thumbs up, a thumbs down, or leave a comment. Your feedback is much appreciated!!!
Cheers,
Tolan
Top Excel Keyboard Shortcuts You DIDN'T Know Series (20 Individual Videos)
(Again- you can find the entire play list here: https://goo.gl/n5Lx38 ) Otherwise, check out the individual videos…
#01: Using the File Menu • Top Excel Keyboard Shortcuts You DON'T Kno...
#02: Using the Ribbon in Excel • Top Excel Keyboard Shortcuts You DON'T Kno...
#03: Using Menus & Dialog Boxes • Top Excel Keyboard Shortcuts You DON'T Kno...
#04: Using Workbooks • Video
#05: Modifying Columns & Rows • Top Excel Keyboard Shortcuts You DON'T Kno...
#06: Navigating within Excel • Top Excel Keyboard Shortcuts You DON'T Kno...
#07: Making a Selection • Top Excel Keyboard Shortcuts You DON'T Kno...
#08: Working with the Active Cell • Top Excel Keyboard Shortcuts You DON'T Kno...
#09: Extending a Selection • Top Excel Keyboard Shortcuts You DON'T Kno...
#10: Making a Special Selection • Top Excel Keyboard Shortcuts You DON'T Kno...
#11: Entering Data in Excel • Video
#12: Editing Cells & Cell Contents • Top Excel Keyboard Shortcuts You DON'T Kno...
#13: Using Spellcheck, Help, and Other Features • Top Excel Keyboard Shortcuts You DON'T Kno...
#14: Copying & Pasting • Top Excel Keyboard Shortcuts You DON'T Kno...
#15: Working with Borders • Top Excel Keyboard Shortcuts You DON'T Kno...
#16: Using General Formatting Tricks • Top Excel Keyboard Shortcuts You DON'T Kno...
#17: Applying a Specific Number Formatting • Top Excel Keyboard Shortcuts You DON'T Kno...
#18: Using Formulas within Excel • Top Excel Keyboard Shortcuts You DON'T Kno...
#19: Diving into at Filters, Tables, & Charts • Top Excel Keyboard Shortcuts You DON'T Kno...
#20: Utilizing Excel Objects, Macros, & Pivot Tables • Top Excel Keyboard Shortcuts You DON'T Kno...