• Wendy Ni

How to Create Filters in Excel

Updated: Aug 14

The Advantages of Using Filters

Filters can be used to narrow down the data in your worksheet and hide parts of it from view. While it may sound a little like grouping, filtering is different because it allows you to qualify and display only the data that interests you. Filters can be applied in different ways to improve the performance of your worksheet. You can use filters ideally in situations where there are a lot of text, dates, and/or numbers. You can even use more than one filter to further narrow your results. Save time. Sort through easily. Stay organized.



Steps to Make Filters in Excel

  • Select all data in the Excel sheet

  • Click on the Sort & Filter button on the top right

  • On the drop down, click Filter

Here is a video, for a more visual tutorial and explanation on how to use filters.

Here is another blog where we go through three graphs that you can use to tell your story of a set of data.



#excel #sheets #spreadsheets #filters #narrow #data #information #graphs #visual #date #name #account #vendor #payment #search #transactions #sort #bookkeeping #philadelphia #phl #newyorkcity #nyc #financialservices #accounting #financialgps

  • Grey LinkedIn Icon
  • Grey Facebook Icon
  • Grey Instagram Icon

©2019 All Rights Reserved 

Philadelphia, PA | New York City, NYC | hello@FinancialGPS.co