Course details

Excel Office 365 (Windows): Using Conditional Formulas

Excel Office 365 (Windows): Using Conditional Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

This 8-video course explores how to use built-in formulas to perform a calculation on a range of values in Excel for Office 365. You will begin by learning how to insert a conditional sum using SUMIF formulas to perform a sum calculation on selected data values in your range. You will next learn how to use the IF function to determine whether a condition is met or not met, and to use the IF function in conjunction with other formulas. This course continues by demonstrating how to embed multiple IF formulas within one another to obtain multiple result options. You will learn to combine qualifying and alternate conditions using the IF and OR in conditional formulas. Next, learners will observe how to use Conditional Formulas to count value occurrences. You will learn to use reference positions in Conditional Formulas. Finally, this course demonstrates how to keep your table up to date with Conditional Formulas by using formulas such as COUNTA and OFFSET.



Expected Duration (hours)
0.7

Lesson Objectives

Excel Office 365 (Windows): Using Conditional Formulas

  • inserting a conditional sum formula
  • inserting a conditional message formula
  • performing complex conditional formulas
  • creating multiple conditions
  • using IF & OR in conditional formulas
  • using conditional formulas to count up value occurrences
  • using reference positions in conditional formulas
  • keeping your table up to date with conditional formulas
  • Course Number:
    ds_msex365_18_enus

    Expertise Level
    Intermediate