Forecasting & Solving Problems

Excel Microsoft 365 (Windows)
• 8 Videos | 49m 32s
• Includes Assessment
Likes 122
This 8-video course explores the wide range of formula error messages in Excel for Office 365. Learn how to identify several error messages, and how errors are produced. You will learn to use the Formula auditing tools to evaluate and resolve nested formulas, and to trace errors to their source. Next, learners will observe how to use Excel's data types to insert and visualize information associated with the data, and how to create a loan amortization schedule. This course demonstrates how to use the Goal Seek tool to find a target value. You will learn how to use the Solver tool to automatically solve mathematical problems in a table by selecting the value that you want to optimize, minimize, or otherwise adjust. Then learn how to use One-Click Forecasting to make predictions on historical data, and to adjust the timeline and seasonality settings, and make changes to the forecast data once the sheet has been inserted. Finally, you will learn how to test what-if scenarios while working on data.

WHAT YOU WILL LEARN

• 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

IN THIS COURSE

• 1.
Understanding formula errors
• 2.
Reviewing & debugging formula errors
• 3.
Using intelligent data types
• 4.
Calculating the interest on a loan
• 5.
Reaching a target value
• 6.
Solving a problem
• 7.
Using the forecast tool
• 8.
Using data tables

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.

Likes 0
Likes 0
Likes 1

Likes 238
Likes 713
Likes 139