114076 SayPro Lesson 8.5 Filtering and Sorting data

Email: info@saypro.online Call/WhatsApp: + 27 84 313 7407

SayPro is a Global Solutions Provider working with Individuals, Governments, Corporate Businesses, Municipalities, International Institutions. SayPro works across various Industries, Sectors providing wide range of solutions.

To Filter Data:

In this example, we will filter the contents of an equipment log at a technology company. We will display only the laptops and projectors that are available for check-out.

  1. Begin with a worksheet that identifies each column using a header row.

  1. Select the Data tab, and locate the Sort & Filter
  2. Click the Filter

  1. Drop-down arrows will appear in the header of each column.
  2. Click the drop-down arrow for the column you would like to filter. In this example, we will screen the Type column to view only certain types of equipment.


  1. The Filter menu appears.
  2. Uncheck the boxes next to the data you don’t want to view. (You can uncheck the box next to Select All to deselect all quickly.)
  3. Check the boxes next to the data you do want to view. In this example, we will check the Laptop and Projector to display only those types of equipment.

  1. Click OK. All other data will be filtered or temporarily hidden. Only laptops and projectors will be visible.

Filtering options can also be found on the Home tab, condensed into the Sort & Filter command.

  • Neftaly Malatjie | CEO | SayPro
  • Email: info@saypro.online
  • Call: + 27 84 313 7407
  • Website: www.saypro.online

SayPro ShopApp Jobs Courses Classified AgriSchool Health EventsCorporate CharityNPOStaffSports

Comments

Leave a Reply