Basic Formulas
Excel 2016 (Windows)
| Beginner
- 12 Videos | 48m 21s
- Includes Assessment
- Earns a Badge
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 library3m 57sUP NEXT
-
2.Performing simple calculations5m 20s
-
3.Using automated formulas in a table3m 50s
-
4.Creating automated cumulative totals3m 40s
-
5.Inserting subtotals3m 47s
-
6.Counting cells in a range4m 30s
-
7.Ranking a value5m 23s
-
8.Rounding a number4m 49s
-
9.Using replacement formulas3m 5s
-
10.Converting number types3m 2s
-
11.Factorizing the results of a division2m 30s
-
12.Creating random values4m 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.
