Live Online - Microsoft Excel - IF Functions & Conditional Formatting

Event Information

Share this event

Date and Time

Location

Location

This is an Online Training course delivered via the web using industry leading software

Online Training, VIC

Australia

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

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.

Date and Time

Location

This is an Online Training course delivered via the web using industry leading software

Online Training, VIC

Australia

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved