# Basic Formulas

Excel 2016 (Windows)    |    Beginner
• 12 Videos | 48m 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.