This video forms part of my free mini online course entitled: "A Basic Course in Financial Modelling for Mining Companies".

Contents:
0:00 Intro and the Conditional Formulae (e.g. SumIf function);
2:30 The AverageIf function
3:35 The CountIf function
4:14 The Offset function
5:45 The Concatenate function

I use the formulae above extensively, especially when consolidating periods in financial models i.e. converting monthly data to quarterly data to annual data. When this is the case one would need to quickly and efficiently summarise data that took place over 3 months into 1 quarter, or 4 quarters into 1year etc.

Here's a link to the full course playlist: [ Ссылка ]

To learn more about financial modelling in the mining sector download my free e-book on "Financial Modelling for Mining Companies": [ Ссылка ]

For more in-depth learning check out the following links:
- Enrol in my full "Financial Modelling for Mining Companies" course: www taurobiz.com
- Subscribe to my YouTube Channel for similar content: [ Ссылка ]
- Join my LinkedIn Group for news of future upcoming webinars, and archived content: [ Ссылка ]

свернуть