Basic Formulas

Excel 2010 (Windows)
  • 12 Videos | 52m 3s
  • Earns a Badge
Likes 61 Likes 61
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

  • 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
    round numbers in Excel 2010
    use replacement formulas in Excel 2010
    convert number types in Excel 2010
    factorize the results of a division in Excel 2010
    use formulas to generate random values in Excel 2010

IN THIS COURSE

  • Playable
    1. 
    Inserting a formula using the function library
    5m 39s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations
    4m 38s
  • Locked
    3. 
    Using automated formulas in a table
    3m 51s
  • Locked
    4. 
    Creating automated cumulative totals
    2m 48s
  • Locked
    5. 
    Inserting subtotals
    4m 1s
  • Locked
    6. 
    Counting cells in a range
    4m 50s
  • Locked
    7. 
    Ranking a value
    5m 25s
  • Locked
    8. 
    Rounding a number
    6m 6s
  • Locked
    9. 
    Using replacement formulas
    3m 17s
  • Locked
    10. 
    Converting number types
    2m 43s
  • Locked
    11. 
    Factorizing the results of a division
    2m 11s
  • Locked
    12. 
    Generating random values
    5m 33s

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 21 Likes 21  
Likes 0 Likes 0  
Likes 16 Likes 16  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 21 Likes 21  
Likes 1408 Likes 1408  
Likes 704 Likes 704