Excel – Advanced Formulae and Functions

When

January 23, 2024
10:00 am - 11:00 am
18 spaces left

Where

Online

Contact details: Paul Atwell @ paul.atwell1@nhs.net

Description

A guide to some of the more advanced functions available within the Logical, Mathematical, Date & Time and Lookup categories.

Prerequisites
A good working knowledge of creating formulae and functions within Excel. Ideally, previous attendance of “Introduction to Formulae and Functions” and “Introduction to Logical Functions” courses or equivalent experience.
PLEASE NOTE: This is the 8th course in a suggested series of the 14 Excel sessions available.

Course outline

  • Exploring the Formulas ribbon
  • Comparing the Logical functions of IF and IFS
  • Using the Statistical functions of COUNTIF and COUNTIFS
  • Using the Math & Trig functions of SUMIF and SUMIFS
  • Methods of rounding using ROUND, ROUNDDOWN and ROUNDUP
  • The differential between dates using DATEDIF and NETWORKDAYS
  • Deriving a new date using EDATE and EOMONTH
  • Returning the current date/time using TODAY and NOW
  • Manipulating a date using DAY, MONTH, YEAR and DATE
  • Using the Lookup function of CHOOSE

The session will take between 45-55 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.