Excel – Introduction to Logical Functions

Date/Time: Wednesday, 6th July 2022 - 9:30 am - 10:15 am
Location: Online
Available Spaces: 17
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.

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.