Updated on: 23-04-2024
Excel - Intermediate (half day)
Topics covered
Complex Formulae
- Review of simple formulae
- Formulae with relative referencing
- Formulae with absolute referencing
- Applying BODMAS
- Create a 3D Reference (total of multiple sheets) and create a summary sheet
Functions
- Statistical Functions (sum/average/count/min/max/countif)
- Logical Functions (IF function)
Range Naming
- Defining Range Names
- Using Range Names in formulae and functions
- Manage Range Names
Online training will be delivered via MS Teams. You will receive joining instructions before your selected session
At the end of the session all delegates will:
On successful completion of this course you will be able to:
- Create complex formulae and functions
- Define and manage Range Names
About the course
| Course Code | MLCSU-TR0086 |
|---|---|
| Intended Audience | Regular users of Excel or those who have completed the Excel Introduction course |
| Delivery Method | Online |
| Required Experience / Training | Attendees to have completed the Excel Introduction course or have equivalent work based experience Quiet room with access to MS Teams and headset or headphones |
| Duration of Training | 2 - 2.5 hours |
Premium Content
This course requires a paid subscription to access. Please login to see if your organisation has a subscription.