Microsoft Office Tutorials and References
In Depth Information
2 Working with Data
and Excel Tables
In this chapter, you will learn how to
✔ Enter and revise data.
✔ Move data within a workbook.
✔ Find and replace data.
✔ Correct and expand upon worksheet data.
✔ Define Excel tables.
With Microsoft Excel 2010, you can visualize and present information effectively by
using charts, graphics, and formatting, but the data is the most important part of any
workbook. By learning to enter data efficiently, you will make fewer data entry errors
and give yourself more time to analyze your data so you can make decisions about
your organization’s performance and direction.
Excel provides a wide variety of tools you can use to enter and manage worksheet data
effectively. For example, you can organize your data into Excel tables, which enables you
to store and analyze your data quickly and efficiently. Also, you can enter a data series
quickly, repeat one or more values, and control how Excel formats cells, columns, and
rows moved from one part of a worksheet to another with a minimum of effort. With
Excel, you can check the spelling of worksheet text, look up alternative words by using
the Thesaurus, and translate words to foreign languages.
In this chapter, you’ll learn how to enter and revise Excel data, move data within a
workbook, find and replace existing data, use proofing and reference tools to enhance your
data, and organize your data by using Excel tables.
Practice Files Before you can complete the exercises in this chapter, you need to copy
the book’s practice files to your computer. The practice files you’ll use to complete the
exercises in this chapter are in the Chapter02 practice file folder. A complete list of
practice files is provided in “Using the Practice Files” at the beginning of this topic.