Using Excel for Data Analysis: Fresh Take

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

In this section, you will learn how to sort and filter data, as well as find other connections within data.

Sorting and Filtering

You can view the transcript for “Excel: How to Filter & Sort Data & Columns in Microsoft Excel – Sort A to Z Filter Settings Tutorial” here (opens in new window).

Count and CountIf

You can view the transcript for “The Excel COUNTIF and COUNTIFS Functions” here (opens in new window).