Top Excel Keyboard Shortcuts You DON'T Know (For Using Formulas within Excel)
Top Excel Keyboard Shortcuts You DON'T Know (For Using Formulas within Excel)
In this Excel tutorial we’ll discuss the top 11 keyboard shortcuts for using formulas in Microsoft Excel.
More specifically, we’ll cover:
01 Accepting a Function with Autocomplete (Tab)
02 Toggling between Absolute, Relative, and Mixed References (F4)
03 Opening the Inserting Function Dialog Box (Shift + F3)
04 Autosumming Selected Cells (Alt + =)
05 Toggling Formulas On and Off (Ctrl + `)
06 Entering an Array Formula (Ctrl + Shift + Enter)
07 Calculating Worksheets (F9)
08 Calculating Active Worksheet (Shift + F9)
09 Expanding or Collapsing the Formula Bar (Ctrl + Shift + U)
10 Displaying the Function Arguments Dialog Box (Ctrl + A)
11 Defining a Name (for a Range of Cells) (Ctrl + F3)
This is video 18 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...