Excel – Introduction to Logical Functions

Date/Time: Monday, 19th July 2021 - 3:00 pm - 3:45 pm

Location: Online

Available Spaces: 17

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

Description

This course is for those requiring an understanding of commonly used logical functions.

Session contents:

  • 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!

This session is 30 minutes in duration with an additional 15 minutes for a Q & A session which you are not obligated to remain for.


You need to be logged in in order to be able to register for this event.