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.
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
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:
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
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