Excel 2007 Power Shortcuts

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

Conclusion

• Goodbye