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

5. Manage worksheet data

In this chapter

• Filter data ranges and tables

• Summarize filtered data

• Enforce data entry criteria

You can manage vast amounts of data in an Excel workbook, but it’s difficult to make business decisions based on that data unless you can focus on the specific information required for each decision.

By working with filtered data, you can more easily discover information such as the percentage of monthly revenue earned in the 10 best days of the month, the average revenue earned on a specific weekday, or the slowest business day of each month.

Just as you can limit the data that a worksheet displays, you can also create validation rules that limit the data entered in them. When you set rules for data entry, you can prevent ...