Using Excel for Data Analysis: Apply It 1

  • Sort data in a table.
  • Filter data in a table.
  • Use the COUNTIF function.
  • Use the IF function.

Let’s take what we know about sorting, filtering, and the IF functions to sort and analyze different data.

Choose Your Own Dataset

Choose a Data Set