Description
COURSE OBJECTIVE:
This online Excel course introduces participants to the power of IF
functions, enabling them to make spreadsheets more intelligent and
responsive.
Learners will discover how to use the IF function to test conditions and
return different results based on the outcome, as well as explore more
advanced techniques such as nested IF statements and combining IF with
other functions.
By the end of the course, participants will be able to automate
decision-making within their spreadsheets, reduce manual effort, and
create more dynamic and efficient solutions.
COURSE FORMAT:
The course involves explanation, demonstration and hands-on practice,
working through exercises that build on your existing skills and
increase the functionality of spreadsheet formulae.
PREREQUISITES:
Participants should be able to perform the following tasks without
assitance:-
• Create formula using basic function such as SUM, AVERAGE etc
• Calculate percentages
• Fix a cell reference within a formula (absolute cell referencing)
To gain these skills we recommend that you attend the following course
first:-
Excel Understanding Formula (to learn basic formula & functions)
CONTENT
• IF Function
• IFS Function
• SUMIF Function
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
