Excel – Introduction to Formulae and Functions

When

March 20, 2024
11:15 am - 12:00 pm
17 spaces left

Where

Online

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.

Either the booking cut off time has passed, or you are unable to book a place on this event due to security restrictions, please contact NECSU.learning@nhs.net if you believe this to be incorrect.