Using conditional formulas in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 9 Videos | 31m 1s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Conditional formulas let you perform calculations in Excel 365 on a range of values by specifying the criteria the data must meet. In this course, discover how to use built-in conditional formulas and create your own. Key concepts covered in this course include how to insert a conditional SUM formula to perform a sum calculation on certain data values; insert a conditional message formula that can be used to display one message if a condition is met, and another if a condition is not met; check if a value is not equal to another; and how to perform complex conditional formulas to create conditions based on calculations and analyze your data in a variety of different ways. You will also explore how to create multiple conditions; how to use IF and OR in conditional formulas; and how to use conditional formulas to count up value occurrences or call out data. Finally, you will learn to use reference positions in conditional formulas and analyze data ranges with conditional formulas.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Microsoft 365: Using conditional formulas in Excel 365 course
    insert conditional SUM formulas in Excel 365
    insert a conditional message formula in Excel 365
    create complex conditional formulas by combining functions in Excel 365
    create a formula with nested functions in Excel 365
  • use conditional formatting rules to highlight data in Excel 365
    use conditional formulas to count up value occurrences in Excel 365
    use IF, OR, and NOT in conditional formulas in Excel 365
    use reference positions in conditional formulas in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Course Overview: Using conditional formulas in Excel 365
    45s
    UP NEXT
  • Playable
    2. 
    Inserting a conditional SUM formula
    4m 31s
  • Locked
    3. 
    Inserting a conditional message formula
    2m 15s
  • Locked
    4. 
    Using complex conditional formulas
    4m 26s
  • Locked
    5. 
    Creating a formula with nested functions
    3m 50s
  • Locked
    6. 
    Calling out data with conditional formatting
    4m 34s
  • Locked
    7. 
    Counting up value occurrences
    2m 59s
  • Locked
    8. 
    Using IF, OR, and NOT in conditional formulas
    3m 45s
  • Locked
    9. 
    Using reference positions in conditional formulas
    3m 55s

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