Thursday 14 February 2013

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

Tip: If you have difficulties to see the video, try to maximise it from lower right corner:




No comments:

Post a Comment