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.
PLEASE NOTE: This is the 2nd course in a suggested series of the 14 Excel sessions available.
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.