Basic Formulas in Excel 2016 for Windows
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 library in Excel 2016 for Windows3m 57sUP NEXT
-
2.Performing simple calculations in Excel 2016 for Windows5m 20s
-
3.Using automated formulas in a table in Excel 2016 for Windows3m 50s
-
4.Creating automated cumulative totals in Excel 2016 for Windows3m 40s
-
5.Inserting subtotals in Excel 2016 for Windows3m 47s
-
6.Counting cells in a range in Excel 2016 for Windows4m 30s
-
7.Ranking a value in Excel 2016 for Windows5m 23s
-
8.Rounding a number in Excel 2016 for Windows4m 49s
-
9.Using replacement formulas in Excel 2016 for Windows3m 5s
-
10.Converting number types in Excel 2016 for Windows3m 2s
-
11.Factorizing the results of a division in Excel 2016 for Windows2m 30s
-
12.Creating random values in Excel 2016 for Windows4m 27s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.