# Basic Formulas

Excel 2016 (Windows)
• 12 Videos | 54m 21s
• Includes Assessment
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

• 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.
Creating 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.

Likes 1
Likes 1
Likes 704

Likes 139
Likes 704
Likes 118