Skip to content
Keystroke Learning - Microsoft Excel Training Course

Microsoft Excel 
IF Functions & Conditional Formatting

Microsoft Excel
IF Functions & Conditional Formatting

Microsoft Excel Computer Training Course

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 Details

Course Skill Level

Intermediate

Class Size

10 Students (max)

Course Duration

½ Day Training Course

Class Times

9:00am -12:30pm

Price

$350+GST

Upcoming Public Courses

There are no upcoming courses at this time.
However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.
 

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants.

Course Content

IF Functions
  • Logical Functions
  • Using True and False
  • Using Comparison Operators
Nested IF Functions
  • Building Nested Functions
Using IFError
  • Uses for the IFError Function
  • Applying the IFError Function
Using SumIF and CountIF
  • Setting up SumIF Functions
  • Creating CountIF Functions
Conditional Formatting
  • Applying Conditional Number Formatting
  • Using Data Bars
  • Using Colour Scales
  • Using Traffic Lights for KPIs
Keystroke Learning - Building Computer Skills to Enable Success

Learn 
Today
Face to Face
Online
 with Keystroke Learning

Learn with Keystroke Learning

Our training approach is professional yet friendly, motivating participants to learn quickly and easily. 

When you complete our training course, you will be ready to apply your new skills right away. 

If you have a customised training solution in mind or need to schedule our popular computer courses

call (03) 9999 7780 or email us @ info@keystrokelearning.com.au

Melbourne Training Venue

Level 2 / 52 Albert Rd
South Melbourne, VIC, 3205

Venue Access Hours

Monday – Friday 8:30am – 5:00pm

Are you Running Late???

Keystroke Learning - Building Computer Skills to Enable Success

Log in