Supporting the entrepreneurial spirit

Big Ideas for SMBs

BLOG

Microsoft Excel Filters for Beginners

Microsoft Excel Filters for Beginners

By Olivia Novak

If you are starting out on Microsoft® Excel®, this article will introduce you to basic applications and methods for using filters. The filters are one of the most fundamental and popular functions of the software and mastering their use will enable you to advance in your Excel capabilities.

Applications of Excel Filters

One of the keys to getting the most out of Excel is creating a subset of data within a spreadsheet. Data subsets are created using filters, which allow you to drill down and find the precise information you need. Filtering provides a quick overview of the range of your data for a specific variable.

Depending on the information in your spreadsheet, you can filter data in three ways:

  1. Based on numbers
  2. Based on text data
  3. Based on dates

These three methods of filtering data provide a basic glimpse into the many possible applications for filtering data. For example, if you work in the sales department of a company, you may want to see the range of sales figures for a given product, see all of the sales associated with a particular sales representative, or see all of the sales on a particular date.

Start with a Basic Filter

To become familiar with the filter function in Microsoft Excel, let’s begin by applying a basic filter to an existing spreadsheet.

  1. Open a completed spreadsheet with columns and headers (here is an example you can use), and save it to your desktop.
  2. Click any single cell inside a data set in the spreadsheet.
  3. On the Data tab in the Sort & Filter group, click Filter.

  4. A small box with a grey downward triangle on the right side of the top row of the columns will be visible. Click the arrow and you will see all of the options available to you to limit the data.
  5. Click on Select All to clear all of the check boxes, then check the box for your selection and click OK.
  6. The result is a display of the figures exclusively for that selection.

Working with Filters and Limits

The basic filter options will default based on the data type in the column. For example, in the image below, dates in the month/day/year format show the year as the first layer with months as the next layer, and then days as the layer beneath.

 

 

To drill down further into this data to help certain values stand out, you may wish to set inclusive or exclusive limits. To filter the data in this spreadsheet and limit your data to include only the date of August 3rd, follow these steps:

  1. Uncheck Select All
  2. Under 2017, click the grey box with a plus sign on the left of August
  3. Select the checkbox left of 03

With this foundational understanding of how Excel filters work, you can ramp up your capabilities through practice as increasingly complex assignments and projects come across your desk. 

Olivia Novak

About the author

Olivia Novak is a Customer Support Engineer for ECi DDMS with broad experience in various applications. She holds a Master’s of Science in Information Technology and Management. In her spare time she reads and crafts items such as latch hook rugs.

facebook-icon facebook-icon linkedin-icon linkedin-icon twitter-icon twitter-icon blog-icon blog-icon youtube-icon youtube-icon instagram-icon instagram-icon Bookmark this page Google +