Day 5
Ok, time to pick up the pace on the Data Analysis Crash Course! These formulae allow us to analyse data through multiple criteria and really pack a punch. If you've enjoyed SUMIF and other formulae we've already covered, you'll love the more powerful versions in today's sessions. So, buckle up and enjoy the ride!
In the session, I show you how to build these powerful data analysis formulae step-by-step. There's no doubt they are tricky to build and you're unlikely to get it right first time - I rarely do! So, make sure you work along with me using your own Excel file. The results will be worth it, I promise ...
DAY 5: Learning Outcomes
In the session, I show you how to build these powerful data analysis formulae step-by-step. There's no doubt they are tricky to build and you're unlikely to get it right first time - I rarely do! So, make sure you work along with me using your own Excel file. The results will be worth it, I promise ...
DAY 5: Learning Outcomes
- create a SUMIFS formula
- create a AVERAGEIFS formula
- create a chart with multiple series
Enjoying the Excel Data Analysis Crash Course? Check out our Excel Basics course.