Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Working with data and Excel tables
Working with data and
IN THIS CHAPTER, YOU WILL LEARN HOW TO
▪ Enter and revise data.
▪ Manage data by using Flash Fill.
▪ Move data within a workbook.
▪ Find and replace data.
▪ Correct and expand upon worksheet data.
▪ Define Excel tables.
With Microsoft Excel 2013, 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 enter and revise Excel data, manage data by using Flash Fill, move
data within a workbook, find and replace existing data, use proofing and reference tools
to enhance your data, and organize your data by defining Excel tables.
PRACTICE FILES To complete the exercises in this chapter, you need the practice files
contained in the Chapter02 practice file folder. For more information, see “Download
the practice files” in this topic’s Introduction.