Live Online - Microsoft Excel - IF Functions & Conditional Formatting, This is an Online Training course delivered via the web using industry leading software, Thursday, 04. June 2020

If you have been struggling with Excel functions, then this 1/2 Day Online training may be just the course for you! We begin with a solid overview one of Excel’s most popular functions, the IF Function. You will also explore Nested Functions and variations such as SumIF.
You’ll then move on to Conditional Formatting, an incredibly useful tool for data visualisation. This can help to highlight data that meets your criteria, such as sales above or below target or measuring against KPIs.
This is an intermediate level course.
What you get

Class size kept to a maximum of 10 participants.
Average class is 4-6 people.
Qualified, experienced and approachable facilitators.
Training materials and take away practice files.
Lifetime post course support.

Need to Learn more about Live Online Training.
 
Microsoft Excel IF Functions & Conditional Formatting 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


If you need to book a course after the ticket sales have closed, please get in touch and we'll do our best to accommodate you.
See here for terms and conditions.









Thursday, 04. June 2020, This is an Online Training course delivered via the web using industry leading software, Live Online - Microsoft Excel - IF Functions & Conditional Formatting

Find more interesting events
Get event recommendations based on your Facebook taste. Get it now!Show me the suitable events for meNot now