Working with Formulas
Excel 2016 (Windows)
| Intermediate
- 10 Videos | 40m 3s
- Includes Assessment
- Earns a Badge
In addition to simple formulas, Excel 2016 has the power to solve more complex calculations. Explore how to calculate loan interest and payments, use the Goal Seek and forecast tools, and find and prevent duplicate values.
WHAT YOU WILL LEARN
-
Calculating the interest on a loanSimulating a loanReaching a target valueSolving a problemUsing the forecast tool
-
Creating automatic reportsFinding identical values in your spreadsheetFinding duplicates in your documentVisualizing your duplicate valuesPreventing duplicate values
IN THIS COURSE
-
1.Calculating the interest on a loan3m 19sUP NEXT
-
2.Simulating a loan4m 22s
-
3.Reaching a target value4m 38s
-
4.Solving a problem6m 3s
-
5.Using the forecast tool5m 18s
-
6.Creating automatic reports4m 22s
-
7.Finding identical values in your spreadsheet2m 47s
-
8.Finding duplicates in your document3m 6s
-
9.Visualizing your duplicate values3m 51s
-
10.Preventing duplicate values2m 18s
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.