Tag Archives: Auto filter

Excel Filter: How to analyse data by filtering multiple columns

Following example video demonstrates how to analyse big data tables by setting filtering criteria to multiple columns simultaneously. In the example below I show only countries with population less than one million and population updated recently.

Excel Filter: How to filter data according to dates

Filter Options

Filter Options

Today I will demonstrate Excel’s powerful capabilities to filter date columns. You have many options for selecting which time period to show or not to show.

In following video I will show how to select time period

  • by selecting start date and end date
  • by selecting “Last Year” from the menu
  • by selecting any year

Excel Filter: How to filter data according to text content

Following demonstration video shows how to filter data according to text content. In this example case we have list of countries and their populations. The list contains independent countries and dependent territories with country it belongs to in parenthesis. We can show only independent countries by filtering “country name”-column with criteria “show only cells not containing parenthesis” and with the opposite logic show only dependent territories. The video will clarify this:

Excel Filter: How to filter number columns efficiently

Following example video demonstrates how to use Excel’s Filter-feature to analyse data of the large tables – in this case population of countries. You can easily filter e.g.

  • Top 10 list
  • Bottom 10 list
  • Above average list
  • Below average list
  • Countries with population between 5 and 10 million people
  • etc…

How to use Auto Filter -feature

An easy way to analyse data of large tables is to use Excel’s Auto Filter -feature. With this feature you can define filtering criteria for each column of the table to show only the information that is most relevant to you.

Following video demonstrates the Auto Filter -feature