Excel – Introduction to Logical Functions

Date/Time: Tuesday, 17th January 2023 - 10:00 - 10:45
Location: Online
Available Spaces: 15
Contact Details: Paul Atwell: paul.atwell1@nhs.net


An introduction to the most commonly used logical functions.

A knowledge of creating basic formulae and functions within Excel.
Ideally, previous attendance of “Introduction to Formulae and Functions” course or equivalent experience.

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.

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.