# Basic Formulas

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

• 1.
Inserting a formula using the function library
• 2.
Performing simple calculations
• 3.
Using automated formulas in a table
• 4.
Creating automated cumulative totals
• 5.
Inserting subtotals
• 6.
Counting cells in a range
• 7.
Ranking a value
• 8.
Rounding a number
• 9.
Using replacement formulas
• 10.
Converting number types
• 11.
Factorizing the results of a division
• 12.
Generating random values

## 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.