Using Conditional Formulas

Excel Microsoft 365 (Windows)    |    Intermediate
  • 8 Videos | 43m 42s
  • Includes Assessment
  • Earns a Badge
Likes 114 Likes 114
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Inserting a conditional sum formula
    5m 36s
    UP NEXT
  • Playable
    2. 
    Inserting a conditional message formula
    5m 13s
  • Locked
    3. 
    Performing complex conditional formulas
    5m 36s
  • Locked
    4. 
    Creating multiple conditions
    5m 19s
  • Locked
    5. 
    Using IF & OR in conditional formulas
    5m 50s
  • Locked
    6. 
    Using conditional formulas to count up value occurrences
    3m 58s
  • Locked
    7. 
    Using reference positions in conditional formulas
    5m 22s
  • Locked
    8. 
    Keeping your table up to date with conditional formulas
    2m 47s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1408 Likes 1408  
Likes 704 Likes 704  
Likes 705 Likes 705