Excel – Advanced Formulae and Functions

Date/Time: Thursday, 11th November 2021 - 1:30 pm - 2:15 pm

Location: Online

Available Spaces: 18

Contact Details: Marc Watson: marc.watson@nhs.net

Description

This course will show you how to create advanced formulae and functions.  Including:

  • Calculations:
    • SUMIF
    • SUMIFS
    • COUNTIF
    • COUNTIFS
  • Dates
    • NETWORKDAYS
    • DATEDIF
    • EDATE
  • Logical
    • CHOOSE
    • IF (Including boolean logic)
      • AND
      • OR
      • NOT
    • IFS

Please ensure that you attend on time as the session will begin at the time stated.


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.