Microsoft Excel IF Functions & Conditional Formatting
IF Functions & Conditional Formatting
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 Skill Level
10 Students (max)
½ Day Training Course
Upcoming Public Courses
- Logical Functions
- Using True and False
- Using Comparison Operators
Nested IF Functions
- Building Nested Functions
- Uses for the IFError Function
- Applying the IFError Function
Using SumIF and CountIF
- Setting up SumIF Functions
- Creating CountIF Functions
- Applying Conditional Number Formatting
- Using Data Bars
- Using Colour Scales
- Using Traffic Lights for KPIs
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.