Basic Formulas

Excel 2016 (Mac)    |    Beginner
  • 12 Videos | 55m 7s
  • Earns a Badge
Likes 21 Likes 21
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.

WHAT YOU WILL LEARN

  • use the Function Library to insert a formula in Excel 2016 for Mac
    perform simple formulas in Excel 2016 for Mac
    create automated cumulative totals in Excel 2016 for Mac
    use the Fill Down function to automate formulas in Excel 2016 for Mac
    add subtotals in Excel 2016 for Mac
    learn formulas to count cells in a range in Excel 2016 for Mac
  • rank values in Excel 2016 for Mac
    learn formulas to round your data values in Excel 2016 for Mac
    use replacement formulas in Excel 2016 for Mac
    insert conditional sum formulas in Excel 2016 for Mac
    insert conditional message formulas in Excel 2016 for Mac
    use IF and OR in conditional formulas

IN THIS COURSE

  • Playable
    1. 
    Inserting a formula using the function library
    4m 8s
    UP NEXT
  • Playable
    2. 
    Performing simple formulas
    4m 31s
  • Locked
    3. 
    Creating automated cumulative totals
    3m 18s
  • Locked
    4. 
    Using automated formulas in a table
    4m 36s
  • Locked
    5. 
    Inserting subtotals
    4m 47s
  • Locked
    6. 
    Counting cells in a range
    4m 23s
  • Locked
    7. 
    Ranking a value
    5m 37s
  • Locked
    8. 
    Rounding a number
    5m 24s
  • Locked
    9. 
    Using replacement formulas
    2m 42s
  • Locked
    10. 
    Inserting a conditional sum formula
    6m 8s
  • Locked
    11. 
    Inserting a conditional message formula
    4m 26s
  • Locked
    12. 
    Using IF & OR in conditional formulas
    5m 6s

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

Likes 255 Likes 255  
CHANNEL Excel
Likes 2186 Likes 2186  
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 705 Likes 705  
COURSE Tools
Likes 72 Likes 72  
Likes 206 Likes 206