5 Manage worksheet data

In this chapter

Practice files

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

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 ...

Get Microsoft Excel 2019 Step by Step, First Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.