Excel for non-beginners- Day 1 - The SUBTOTAL function

What I will be covering in this Lesson:

  • What is the SUBTOTAL function and why it is an amazing weapon in our arsenal for creating reports
  • Taking Autofilters to another level with SUBTOTAL (If you want a refresher lesson on Autofilters, scroll down)
  • Combining SUBTOTAL with non-numeric information to deepen our data analysis

A refresher lesson on Autofilters:

  • The power and importance of eliminating data we do NOT need
  • How to put conditions on data to narrow down only the information you need within a list
  • How to see immediately see if data has been filtered (not doing this can be a costly mistake)