Forecasting & Solving Problems

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.