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