Page 120 - Ms Excel Note and Workbook
P. 120
MICROSOFT EXCEL NOTE AND WORKBOOK
Filtering Data
Filters can be used to narrow down the data in your worksheet, allowing you to view only the
information you need. In this example, we're filtering the worksheet to show only rows that contain
the words Laptop or Projector in column B.
Summarizing Data
The Subtotal feature allows you to quickly summarize your data. In our example, we've created a
subtotal for each T-shirt size, which makes it easy to see how many we'll need in each size.
111 | P a g e
