Basic Formulas
Excel 2010 (Windows)
12 Videos | 52m 3s - Earns a Badge
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
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
round numbers in Excel 2010
use replacement formulas in Excel 2010
convert number types in Excel 2010
factorize the results of a division in Excel 2010
use formulas to generate random values in Excel 2010
IN THIS COURSE
-
1.Inserting a formula using the function library5m 39sUP NEXT
-
2.Performing simple calculations4m 38s
-
3.Using automated formulas in a table3m 51s
-
4.Creating automated cumulative totals2m 48s
-
5.Inserting subtotals4m 1s
-
6.Counting cells in a range4m 50s
-
7.Ranking a value5m 25s
-
8.Rounding a number6m 6s
-
9.Using replacement formulas3m 17s
-
10.Converting number types2m 43s
-
11.Factorizing the results of a division2m 11s
-
12.Generating random values5m 33s
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.
