ONLINE - IF, COUNTIF and SUMIF Functions in Excel 10-27-20

Length/CPE Hours

3 hours

Cost $75/person

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

Break from 10:00 to 10:15

Method of Delivery

This class will be held online using GoTo Metting. Class participants will receive a PDF of the book. Instruction will be using Outlook for Office 365. However, if you have Office 2016 or Office 2013, you will be able to follow along with minor exceptions.

When you register, be sure to use the email that you would like your GoTo Metting invitation sent to. The meeting invitation and materials are usually sent after the cancellation deadline which is 5 days prior to the class start date. 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 GoTo Meeting subscription to participate.

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

https://www.gotomeeting.com/

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

Course Description

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

Outline

  • 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

 

Prerequisite

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 10-27-2020 9:00 am
Event End Date 10-27-2020 12:00 pm
Capacity 14
Registered 0
Available place 14
Cut off date 10-27-2020 8:00 am
Individual Price $75.00
Location ONLINE