Topic 2: Excel Formulas and Functions Video Presentations: Excel 2.2 Mathematical Functions

1. Excel 2.1 Formulas and Functions
2. Excel 2.2 Mathematical Functions
3. Excel 2.3 Logical Functions
4. Excel 2.4 Cell References
5. Excel 2.5 Cell Auditing
6. Excel 2.6 Formulas Application

Module Evaluation Surveys

The Module Evaluation Surveys are confidential questionnaires about how things are going on the modules you have taken. Your voice is crucial in helping us to improve your experience and the experience of future students.

Please tell us what you have enjoyed as well as what you feel we can improve on to allow us to further build on your positive experience.

To continue to explore this topic, view and navigate the following Excel Formulas and Functions video presentations which take you through Mathematical Functions, Logical Functions, Cell References, Cell Auditing and an Excel Example Application applying the skills developed in this section.

2. Excel 2.2 Mathematical Functions

Transcript: Slides

Watch a video in which Claudio Vallar explains some of the most commonly used mathematical functions (sum, sumif, ln, exp, sqrt, abs and round).