Topic 2: Excel Formulas and Functions Video Presentations
| Site: | QMplus - The Online Learning Environment of Queen Mary University of London |
| Module: | SEF PGT Welcome Week and Pre-Sessional - January 2025 |
| Book: | Topic 2: Excel Formulas and Functions Video Presentations |
| Printed by: | Guest user |
| Date: | Sunday, 1 June 2025, 11:44 AM |
Description
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.
1. Excel 2.1 Formulas and Functions
Transcript: Slides
Watch a video presentation in which Claudio Vallar introduces the concepts of formulas and functions and how to use them.
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).
3. Excel 2.3 Logical Functions
Transcript: Slides
In this video presentation Claudio Vallar explains some of the most commonly used logical functions (if, and, or) and nested functions.
4. Excel 2.4 Cell References
Transcript: Slides
Watch a video presentation in which Claudio Vallar explains how to apply the correct cell references and the importance of it.
5. Excel 2.5 Cell Auditing
Transcript: Slides
Watch a video which introduces how to audit a formula and the most common errors formulas return.
6. Excel 2.6 Formulas Application
Watch a video in which Claudio Vallar shows an example in Excel using the skills developed in this session.