Excel – Introduction to Formulae and Functions

Date/Time: Tuesday, 5th July 2022 - 15:00 - 15:45
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.


You need to be logged in in order to be able to register for this event.
Please use the login form at the top of the page.