Basic Formulas
Excel 2016 (Mac)
| Beginner
- 12 Videos | 55m 7s
- 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
-
use the Function Library to insert a formula in Excel 2016 for Macperform simple formulas in Excel 2016 for Maccreate automated cumulative totals in Excel 2016 for Macuse the Fill Down function to automate formulas in Excel 2016 for Macadd subtotals in Excel 2016 for Maclearn formulas to count cells in a range in Excel 2016 for Mac
-
rank values in Excel 2016 for Maclearn formulas to round your data values in Excel 2016 for Macuse replacement formulas in Excel 2016 for Macinsert conditional sum formulas in Excel 2016 for Macinsert conditional message formulas in Excel 2016 for Macuse IF and OR in conditional formulas
IN THIS COURSE
-
1.Inserting a formula using the function library4m 8sUP NEXT
-
2.Performing simple formulas4m 31s
-
3.Creating automated cumulative totals3m 18s
-
4.Using automated formulas in a table4m 36s
-
5.Inserting subtotals4m 47s
-
6.Counting cells in a range4m 23s
-
7.Ranking a value5m 37s
-
8.Rounding a number5m 24s
-
9.Using replacement formulas2m 42s
-
10.Inserting a conditional sum formula6m 8s
-
11.Inserting a conditional message formula4m 26s
-
12.Using IF & OR in conditional formulas5m 6s
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.