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.