Basic Formulas in Excel 2016 for Mac

Excel 2016 (Mac)    |    Beginner
  • 12 videos | 55m 7s
  • Earns a Badge
Likes 40 Likes 40
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 in Excel 2016 for Mac
    4m 8s
    UP NEXT
  • Playable
    2. 
    Performing simple formulas in Excel 2016 for Mac
    4m 31s
  • Locked
    3. 
    Creating automated cumulative totals in Excel 2016 for Mac
    3m 18s
    FREE ACCESS
  • Locked
    4. 
    Using automated formulas in a table in Excel 2016 for Mac
    4m 36s
    FREE ACCESS
  • Locked
    5. 
    Inserting subtotals in Excel 2016 for Mac
    4m 47s
    FREE ACCESS
  • Locked
    6. 
    Counting cells in a range in Excel 2016 for Mac
    4m 23s
    FREE ACCESS
  • Locked
    7. 
    Ranking a value in Excel 2016 for Mac
    5m 37s
    FREE ACCESS
  • Locked
    8. 
    Rounding a number in Excel 2016 for Mac
    5m 24s
    FREE ACCESS
  • Locked
    9. 
    Using replacement formulas in Excel 2016 for Mac
    2m 42s
    FREE ACCESS
  • Locked
    10. 
    Inserting a conditional sum formula in Excel 2016 for Mac
    6m 8s
    FREE ACCESS
  • Locked
    11. 
    Inserting a conditional message formula in Excel 2016 for Mac
    4m 26s
    FREE ACCESS
  • Locked
    12. 
    Using IF & OR in conditional formulas in Excel 2016 for Mac
    5m 6s
    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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Microsoft Excel Professional 2021 Guide: A Complete Excel Reference, Loads of Formulas and Functions, Shortcuts, and Numerous Screenshots to Become an Excel Expert
Course Using Basic Formulas in Excel 2019 for Windows
Likes 266 Likes 266  
Course Referencing data in Excel 365

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course PivotTables in Excel 2016 for Mac
Likes 25 Likes 25  
Course Configuring Excel 2013 for Windows
Likes 38 Likes 38  
Course Saving Time by Setting Goals
Likes 678 Likes 678