Basic Formulas

Excel 2016 (Windows)
  • 12 Videos | 54m 21s
  • Includes Assessment
  • Earns a Badge
Likes 255 Likes 255
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
    3m 57s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations
    5m 20s
  • Locked
    3. 
    Using automated formulas in a table
    3m 50s
  • Locked
    4. 
    Creating automated cumulative totals
    3m 40s
  • Locked
    5. 
    Inserting subtotals
    3m 47s
  • Locked
    6. 
    Counting cells in a range
    4m 30s
  • Locked
    7. 
    Ranking a value
    5m 23s
  • Locked
    8. 
    Rounding a number
    4m 49s
  • Locked
    9. 
    Using replacement formulas
    3m 5s
  • Locked
    10. 
    Converting number types
    3m 2s
  • Locked
    11. 
    Factorizing the results of a division
    2m 30s
  • Locked
    12. 
    Creating random values
    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 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 704 Likes 704  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 139 Likes 139  
Likes 704 Likes 704  
Likes 118 Likes 118