This video is for those requiring an understanding of formulae construction within Excel. The usage of the functions SUM, AVERAGE, MAX, MIN, COUNT and TODAY are also demonstrated.
The topics discussed are:
- How to construct a basic formula
- Using Autofill
- Understanding BODMAS
- Absolute cell references
- Creating a formula with a function
- Mathematics with dates