Introduction
Welcome
()
Using the exercise files
()
1. The Top 10
The Repeat command
()
The AutoSum keyboard shortcut
()
Changing the Excel 2007 defaults
()
The Format Painter
()
Creating charts with a keyboard shortcut
()
Adding custom keyboard shortcuts via macros
()
Sharing a spreadsheet using the Send command
()
Getting statistics from the Status bar
()
Expanding and collapsing the Formula bar
()
Autofitting all columns and rows to data
()
2. Ribbon and Toolbar Shortcuts
Hiding the Ribbon
()
Revealing and using the Ribbon keytips
()
Accessing the Mini toolbar
()
Customizing the Quick Access toolbar
()
Using the Quick Access toolbar keyboard shortcuts
()
3. Sheet Navigation Shortcuts
The Go To command
()
Moving around a worksheet
()
Zooming in and out with the keyboard
()
The Zoom to Selection command
()
Hiding and revealing rows and columns
()
4. Cell Selection Shortcuts
Selecting a range of cells with the keyboard
()
Selecting the current region of cells
()
Selecting non-adjacent cells
()
Selecting entire rows and columns
()
Selecting the same cell range in multiple sheets
()
Selecting, copying, and pasting content between cells
()
Grouping rows or columns to create collapsible regions
()
5. Data Entry Shortcuts
Extending a series or pattern with Autofill
()
Creating a custom list for Autofill
()
Data entry shortcuts with AutoCorrect
()
Creating a custom data drop-down list
()
Inserting the current date and/or time
()
Entering fractions versus dates
()
Removing duplicate rows of data
()
Keeping row and column headings in view
()
6. Formatting Shortcuts
Quick formatting shortcuts
()
Adding and removing cell borders
()
Custom date formats
()
Custom time formats
()
Adding time values and formatting them correctly
()
Shading every other row automatically
()
Parsing names into multiple columns
()
Changing uppercase text to proper case with the Proper function
()
Removing automatic hyperlinks
()
Changing colors by picking a different theme
()
Ex_Files_Excel07_PwrCuts.zip
(277 KB)