Microsoft Office 2019 Step by Step, First Edition

7

Manage worksheet data

In this chapter

• Limit data that appears on your screen

• Manipulate worksheet data

• Define valid sets of values for ranges of cells

With Excel 2019, you can manage huge data collections, but storing more than 1 million rows of data doesn’t help you make business decisions unless you have the ability to focus on the most important data in a worksheet.

Excel includes many powerful and flexible tools with which you can limit the data displayed in your worksheet. When your worksheet displays the subset of data you need, you can perform calculations on that data. You can discover what percentage of monthly revenue was earned in the 10 best days in the month, find your total revenue for particular days of the week, or locate ...