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.
Participants should have a good understanding of the fundamentals of Microsoft Excel. Ideally you will have completed our Microsoft Excel Beyond the Basics training course, or have some prior experience using simple Excel Spreadsheets, including entering and editing data, creating formulas, and basic formatting.
Once you’ve completed this course, you may want to further your knowledge by attending a Lookup & Reference Functions course.
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.
*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.