Excel – Introduction to Logical Functions

When

January 4, 2024
11:00 am - 11:45 am
18 spaces left

Where

Online

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

Description

An introduction to the most commonly used logical functions.

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

Course outline

  • How to construct a basic IF function
  • Understanding relational operators
  • Using SUMIF and COUNTIF functions
  • Boolean logic with AND and OR functions
  • Using IFERROR to eliminate #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!

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.