Basic Formulas in Excel 2016 for Windows

Excel 2016 (Windows)    |    Beginner
  • 12 videos | 48m 21s
  • Includes Assessment
  • Earns a Badge
Likes 335 Likes 335
The power of Excel 2016 is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers.

WHAT YOU WILL LEARN

  • Inserting a formula using the function library
    Performing simple calculations
    Using automated formulas in a table
    Creating automated cumulative totals
    Inserting subtotals
    Counting cells in a range
  • Ranking a value
    Rounding a number
    Using replacement formulas
    Converting number types
    Factorizing the results of a division
    Creating random values

IN THIS COURSE

  • Playable
    1. 
    Inserting a formula using the function library in Excel 2016 for Windows
    3m 57s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations in Excel 2016 for Windows
    5m 20s
  • Locked
    3. 
    Using automated formulas in a table in Excel 2016 for Windows
    3m 50s
  • Locked
    4. 
    Creating automated cumulative totals in Excel 2016 for Windows
    3m 40s
  • Locked
    5. 
    Inserting subtotals in Excel 2016 for Windows
    3m 47s
  • Locked
    6. 
    Counting cells in a range in Excel 2016 for Windows
    4m 30s
  • Locked
    7. 
    Ranking a value in Excel 2016 for Windows
    5m 23s
  • Locked
    8. 
    Rounding a number in Excel 2016 for Windows
    4m 49s
  • Locked
    9. 
    Using replacement formulas in Excel 2016 for Windows
    3m 5s
  • Locked
    10. 
    Converting number types in Excel 2016 for Windows
    3m 2s
  • Locked
    11. 
    Factorizing the results of a division in Excel 2016 for Windows
    2m 30s
  • Locked
    12. 
    Creating random values in Excel 2016 for Windows
    4m 27s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 809 Likes 809  
Likes 266 Likes 266