Excel 2007 Power Shortcuts

Teaches shortcuts to make navigation, cell selection, formatting, and data entry faster for any Excel user.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. Topics include: Creating charts with a keyboard shortcut Hiding or customizing the Ribbon to save screen real estate Zooming in and out using only the keyboard Grouping rows or columns to create collapsible regions Building data-entry shortcuts with AutoComplete Parsing names into multiple columns for better sorting