Microsoft Excel 2019 Step by Step, First Edition

2 Work with data and Excel tables

In this chapter

• Enter and revise data

• Manage data by using Flash Fill

• Move data within a workbook

• Find and replace data

• Correct and expand upon data

• Define Excel tables

Practice files

For this chapter, use the practice files from the Excel2019SBS\Ch02 folder. For practice file download instructions, see the introduction.

With Excel 2019, 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 ...