Day 6
The final day of the data analysis crash course! How have you found it? The bad news: there's no session tomorrow :-( The good news: I've saved the best until last ...
Excel's DSUM formula is another of my Excel 'secret weapons'. Perhaps you've enjoyed feeling the power of the likes of AVERAGEIFS, but have struggled to build the formulae - which can get quite long. If so, DSUM could be a great option for you. I love it because the formula itself is relatively short and easy to maintain. Some setup is required, but we cover that in the video.
If you can work along with me one final time, I'm sure you'll be adding this formula and its variants to your Excel Toolkit ...
DAY 6: Learning Outcomes
Excel's DSUM formula is another of my Excel 'secret weapons'. Perhaps you've enjoyed feeling the power of the likes of AVERAGEIFS, but have struggled to build the formulae - which can get quite long. If so, DSUM could be a great option for you. I love it because the formula itself is relatively short and easy to maintain. Some setup is required, but we cover that in the video.
If you can work along with me one final time, I'm sure you'll be adding this formula and its variants to your Excel Toolkit ...
DAY 6: Learning Outcomes
- create a DSUM / DAVERAGE / DCOUNT formula
Enjoying the Excel Data Analysis Crash Course? Check out our Excel Basics course.