Working with Formulas in Excel 2016 for Windows
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 loan in Excel 2016 for Windows3m 19sUP NEXT
-
2.Simulating a loan in Excel 2016 for Windows4m 22s
-
3.Reaching a target value in Excel 2016 for Windows4m 38s
-
4.Solving a problem in Excel 2016 for Windows6m 3s
-
5.Using the forecast tool in Excel 2016 for Windows5m 18s
-
6.Creating automatic reports in Excel 2016 for Windows4m 22s
-
7.Finding identical values in your spreadsheet in Excel 2016 for Windows2m 47s
-
8.Finding duplicates in your document in Excel 2016 for Windows3m 6s
-
9.Visualizing your duplicate values in Excel 2016 for Windows3m 51s
-
10.Preventing duplicate values in Excel 2016 for Windows2m 18s
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.