Welcome to Fast Track to 2007: Enter and Edit Data, brought to you by CareerTrack. Whether you work with Excel 2007 once in a while or every day, it always helps to know the insider tips that make it easier to get things done. This program is full of shortcuts, tips, and tricks to help you save time on everything from typing in your data, to formatting, to analyzing data. In lesson 1, use the Paste Options button so you can make sure you are getting just the right information—and just the right look. In lesson 2, separate a single column of data into multiple columns—letting you sort the data or do further analysis. Finally, in lesson 3, use AutoCorrect to enter addresses, names, whole sentences, and even paragraphs of information much more quickly.
What You'll Learn
Unlock the secrets to some of those tricks that have always made you say, "I wonder how they did that." Our expert guidance demystifies the features of Microsoft Excel, and you even learn a few tricks that most people don’t realize Excel 2007 can do!
Lesson 1: Eliminate frustration by using the special paste function to copy data without changing the format for the cells in your spreadsheet.
Lesson 2: Eliminate retyping when you want to split up one column of data into several by converting text to columns.
Lesson 3: Spend less time typing and reduce errors by setting up keystrokes that enter the data for you.