Excel Office 365: Forecasting & Solving Problems
Excel Office 365: Forecasting & Solving Problems Overview/Description Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description Go further with you Excel document through understanding potential formula errors, use intelligent data types, set goals to reach targets as well as problem solve with the solver and Forecast tools offered by Excel for Office 365.
Expected Duration (hours)
0.8
Lesson Objectives Excel Office 365: Forecasting & Solving Problems
identify formula errors
check for and evaluate formulas in a workbook
insert and visualise dynamic geographical and stock-related data in a worksheet
use formulas to estimate loan-related costs
use the Goal Seek tool to modify a data variable and reach a target value
use the Solver add-in to analyze constraints and variables and optimize data values
insert a Forecast worksheet to display trends and predictions based on available historic data
use Data Tables to create what if, variable-based scenarios
Course Number: ds_msex365_12_enus
Expertise Level
Intermediate
