Conditional Formulas

Excel 2013 (Windows)    |    Intermediate
  • 9 Videos | 51m 43s
  • Earns a Badge
Likes 31 Likes 31
Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own.

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
    Keeping your table up to date with conditional formulas
    Translating data in your worksheet
    Using reference positions in conditional formulas

IN THIS COURSE

  • Playable
    1. 
    Inserting a conditional sum formula
    6m 51s
    UP NEXT
  • Playable
    2. 
    Inserting a conditional message formula
    4m 22s
  • Locked
    3. 
    Performing complex conditional formulas
    6m 9s
    FREE ACCESS
  • Locked
    4. 
    Creating multiple conditions
    6m 53s
    FREE ACCESS
  • Locked
    5. 
    Using IF & OR in conditional formulas
    5m 25s
    FREE ACCESS
  • Locked
    6. 
    Using conditional formulas to count up value occurrences
    3m 36s
    FREE ACCESS
  • Locked
    7. 
    Keeping your table up to date with conditional formulas
    7m 28s
    FREE ACCESS
  • Locked
    8. 
    Translating data in your worksheet
    5m 4s
    FREE ACCESS
  • Locked
    9. 
    Using reference positions in conditional formulas
    5m 56s
    FREE ACCESS

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

COURSE Finding and analyzing data with formulas in Excel 365
COURSE Using macros in Excel 365
BOOK Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More