Excel for non-beginners- Day 2 - Summarising with formulas

What I will be covering in this Lesson:

  • How we can combine the power of summarising with the power of logic building in one Excel function: SUMIF
  • Making our summarising even more deeper through adding more logic criteria with SUMIFS
  • Using the 'wildcard' to create partial filtering criteria which allows us to cast a wider net when we need to in our analysis