ONLINE - IF, COUNTIF and SUMIF Functions in Excel 4/28/20

Length/CPE Hours

3 hours

Cost $75/person

9:00 a.m. – 12:00 p.m.

Break from 10:00 to 10:15

Course Description

This online class is designed to help you learn how to work with IF Statements in Excel.


  • Learning How to Write an IF Statement
  • Working with Nested If Statements
  • Using the Countif Function
  • Learn the SUMIF Function
  • Look at the NEW IFS statement

Method of Delivery

We will be using ZOOM to deliver this online class.  When you register, be sure to use the email that you would like your Zoom meeting invitation sent to.  The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a Zoom subscription to participate.  

The web browser client will download automatically when you start or join your first Zoom meeting and is also available for manual download here.

It is a good idea to download this prior to the online meeting.


Basic to Intermediate Knowledge of Excel

Excel Versions

I will be using Microsoft Office 365 to demonstrate the keystrokes.  However, these keystrokes will work in most versions of Excel.

Who Should Attend?

Excel users who would like to improve their knowledge of the IF Functions in Excel.

Event Properties

Event Date 04-28-2020 9:00 am
Event End Date 04-28-2020 12:00 pm
Capacity 10
Registered 2
Available place 8
Cut off date 04-27-2020 5:00 pm
Individual Price $75.00
We are no longer accepting registration for this event