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 libraryPerforming simple calculationsUsing automated formulas in a tableCreating automated cumulative totalsInserting subtotalsCounting cells in a range
-
Ranking a valueRounding a numberUsing replacement formulasConverting number typesFactorizing the results of a divisionCreating 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.