This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel 2007 Great Shortcuts: How to work faster and easier than before!
Introduction
Welcome (1:17)
What you need to know for this course (0:24)
Training files
Ten must know shortcuts
Saving your work (2:08)
Cut copy paste (3:00)
Undo and redo (2:11)
Print preview and print (2:20)
Check spelling (2:56)
Creating tables (2:27)
Filtering data (1:45)
Autosum function (3:11)
Format painter (4:31)
Creating charts quickly (1:44)
Formatting shortcuts
Bold italic underline (0:57)
Repeat last action (2:02)
Percent style (0:44)
Comma style (1:02)
Workbook and worksheet shortcuts
Opening and closing workbooks (1:36)
Switching between workbooks (1:56)
Minimize window (0:52)
Inserting worksheets (1:06)
Renaming worksheets (1:09)
Switching between worksheets (0:56)
Selecting all worksheets (1:37)
Selection shortcuts
Selecting all cells in a worksheet (0:52)
Selecting all data in a table (0:51)
Selecting the entire row (1:08)
Selecting the entire column (1:03)
Data Entry shortcuts
Entering data in cells simultaneously (3:20)
Finding and replacing data (6:23)
Go to cell (2:41)
Autofill (5:44)
Picking data from drop down list (3:56)
Working with a line break (2:45)
Working with dates (2:16)
Ribbon shortcuts
Using the alt key (3:19)
Minimize the ribbon (1:18)
Formulas and functions shortcuts
Expanding the formula bar (1:48)
Summing up named ranges (3:09)
Conclusion
Goodbye and thanks (0:56)
Finding and replacing data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock