Forecasting & Solving Problems
Excel 2019 (Windows)
| Intermediate
- 7 Videos | 44m 29s
- Includes Assessment
- Earns a Badge
- CPE
- PMI PDU
Discover how to go further with your Excel document through understanding potential formula errors, use intelligent data types, and set goals to reach targets as well as problem-solve with the Solver and Forecast tools offered by Excel 2019. Key concepts in this 7-video course include how to identify formula errors and to understand the wide range of formula error messages; how to check for and evaluate formulas in a workbook; and how to use formulas to estimate loan-related costs and help you estimate and managed repayments. Continue by learning how to use the Goal Seek tool to modify a data variable and reach a target value; how to use the Solver add-in to analyze constraints and variables and optimize data values; and how to insert a Forecast worksheet to display trends and predictions based on available historic data. Finally, observe how to use Data Tables to create what if, variable-based scenarios, and once created, learn to adjust the values and change the calculation options.
WHAT YOU WILL LEARN
-
identify formula errors
review and debug formula errors
calculate the interest on a loan
reach a target value -
solve a problem in a table
use forecast tools
use data tables
IN THIS COURSE
-
1.Understanding formula errors5m 43sUP NEXT
-
2.Reviewing & debugging formula errors5m 3s
-
3.Calculating the interest on a loan5m 32s
-
4.Reaching a target value4m 12s
-
5.Solving a problem4m 55s
-
6.Using the forecast tool4m 5s
-
7.Using data tables4m 30s
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.
