Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

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 fine-tune data

• Define Excel tables

With Excel, 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 so that you can store ...