• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

In Excel 2007 Power Shortcuts, Adobe product manager and designer Michael Ninness, shows many of the tips and tricks he's picked up throughout his career to make Excel work for him. Michael starts with his top ten shortcuts, then continues with tips for navigation, cell selection, formatting, and data entry. He shows how to make a sheet easier to read by shading every other row, and demonstrates how to remove hyperlinks from selected cells. He explains how to get basic statistics from the Status bar, and introduces the ever-useful AutoSum keyboard shortcut. This course is filled with useful tips for anyone who uses Excel to track projects, create spreadsheets, or build forms. Exercise files accompany the course.

Course Excel 2007 Power Shortcuts Author Michael Ninness SKU ISBN Release Date 2009-11-17 Duration 2.04 hrs / 48 tutorials Work files Yes Price $ 19.95 Retail price $ 49.95 Language Tags Excel

1. The Top 10 The Repeat command 02:07 The AutoSum keyboard shortcut 01:41 Changing the Excel 2007 defaults 03:13 The Format Painter 02:55 Creating charts with a keyboard shortcut 02:39 Adding custom keyboard shortcuts via macros 04:28 Sharing a spreadsheet using the Send command 01:14 Getting statistics from the Status bar 02:46 Expanding and collapsing the Formula bar 02:26 Autofitting all columns and rows to data 01:28 2. Ribbon and Toolbar Shortcuts Hiding the Ribbon 02:15 Revealing and using the Ribbon keytips 03:15 Accessing the Mini toolbar 02:37 Customizing the Quick Access toolbar 04:04 Using the Quick Access toolbar keyboard shortcuts 03:22 3. Sheet Navigation Shortcuts The Go To command 01:52 Moving around a worksheet 05:03 Zooming in and out with the keyboard 02:00 The Zoom to Selection command 01:43 Hiding and revealing rows and columns 03:51 4. Cell Selection Shortcuts Selecting a range of cells with the keyboard 01:34 Selecting the current region of cells 01:01 Selecting non-adjacent cells 02:17

Selecting entire rows and columns 01:42 Selecting the same cell range in multiple sheets 03:02 Selecting, copying, and pasting content between cells 02:49 Grouping rows or columns to create collapsible regions 02:41 5. Data Entry Shortcuts Extending a series or pattern with Autofill 04:35 Creating a custom list for Autofill 03:00 Data entry shortcuts with AutoCorrect 03:57 Creating a custom data drop-down list 04:30 Inserting the current date and/or time 02:14 Entering fractions versus dates 02:05 Removing duplicate rows of data 01:10 Keeping row and column headings in view 02:17 6. Formatting Shortcuts Quick formatting shortcuts 02:54 Adding and removing cell borders 01:58 Custom date formats 03:41 Custom time formats 03:27 Adding time values and formatting them correctly 02:20 Shading every other row automatically 03:55 Parsing names into multiple columns 02:15 Changing uppercase text to proper case with the Proper function 01:38 Removing automatic hyperlinks 03:01 Changing colors by picking a different theme 02:53 Conclusion Goodbye 00:24