Today we focus on two must-have skills in data analysis: sorting and filtering data.  The session starts at beginner level with simple sorting, then covers multi-level sorting and filtering data.  You'll displaying your data in exactly the way you want in no time!

Finally we, cover the super practical =SUBTOTAL formula that performs cool operations such calculating the sum of only filtered rows.

DAY 3: Learning Outcomes

  1. sort data

  2. do a multi-level sort

  3. filter data

  4. build a SUBTOTAL formula


Enjoying the Excel Data Analysis Crash Course?  Check out our Excel Basics course.