Loading Course Dates
  • This course has passed.

Live Online – Microsoft Excel – IF Functions & Conditional Formatting

20 August @ 1:00 pm - 4:30 pm


Microsoft Excel Training Course

Full details can be seen on our IF Functions & Conditional Formatting page or Download our Course Outline.

Need to learn more about Live Online Training?

Payment Options are detailed below.

Course Details

Skill Level: Intermediate
Duration: Half Day

Time: 1:00pm-4:30pm
Class Size: 10 Students (max)

Course Overview

Students on this Microsoft Excel – IF Functions and Conditional Formatting half-day course will learn various ways to use one of Excel’s most popular functions, the IF Function. You will explore Nested Functions and variations such as SumIF. You will then move on to work with Conditional Formatting to assist with data visualisation, all without having to be away from the office for a full day.

The course assumes that you have a working knowledge of the fundamentals of Excel, however, people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.

Course Content

IF Functions
Nested IF Functions
Using IFError

Using SumIF and CountIF
Conditional Formatting


20 August
1:00 pm - 4:30 pm
Courses Category:


Online Training delivered through the web via industry leading software