How to Use Excel Conditional Calculations

Live Online Learning (1 Hour)

Learn to use Excel conditional calculations, some of the most popular, adaptable and useful functions in Excel.

In this interactive live online training session, you will begin by learning how to use IF and SUMIF functions – essential tools for analysing the criteria of your data, and calculating totals from a range of cells.

With basic Excel conditional calculations mastered, you will then take things further, with SUMIFS. You will quickly become confident to perform calculations based on multiple criteria, as well as negotiate errors with formula auditing tools.

This How to Use Excel Conditional Calculations training session is suitable for users of Excel 2013 or 2016.

What Will I Learn?

How to use the IF function - Save time by using the IF function to check if data meets specified criteria.

How to use the SUMIF function - Learn to use SUMIF to calculate a total from a range of cells, based on specified criteria.

How to use SUMIFS function - Take SUMIF multiple steps further, by learning to use SUMIFS to calculate a total based on multiple criteria.

Auditing formulas - Become an Excel reverse-engineer by learning to use auditing tools to trace errors within formulas.


You should have a good experience of using Microsoft Excel, and be able to create and edit workbooks. It would also be beneficial to know how to use functions and formulas, or take our Learn Excel Formulas and Functions for Beginners / Advanced Users training first.

What Are Live Online Sessions?

Live Online gives you all the benefits of classroom training, but from the comfort of your home or office. Sessions take place on a shared online screen, where your friendly trainer will guide you and your class through the learning topic.

These interactive sessions also give you the opportunity to practice what you’ve learnt, as you take control and demonstrate your new skills to your trainer. Two-way text or voice chat is always available, for when you want to discuss a topic, need help, or want to ask any questions.


£95 per person, per session

Maximum Group Size:

6 people

Request Training

t: 0203 941 4100 | e:

Excel Conditional Calculations Course Content

  • How to use IF function
  • How to check if data meets specified criteria
  • How to use SUMIF
  • How to calculate a total from a range of cells
  • How to use multi SUMIFs
  • How to calculate a total based on multiple criteria
  • How to use auditing tools
  • How to trace errors within formulas