Location: Online
Available Spaces: 14
Contact Details: Paul Atwell: paul.atwell1@nhs.net
Description
Ideal for those new to Excel and those requiring a basic understanding of formulae construction including demonstrations of the functions: SUM, AVERAGE, MAX, MIN, COUNT and TODAY.
Prerequisites
An understanding of navigation within workbooks and worksheets.
Ideally, previous attendance of “Excel – An Introduction” course or equivalent experience.
Course outline
- How to construct a basic formula
- Using Autofill
- Understanding BODMAS
- Absolute cell references
- Creating a formula with a function
- Mathematics with dates
The session will take between 30-40 minutes to complete and is followed by a Q & A which is optional to attend.