Excel 365 – Anticipate and solve problems

Overview

This 8-clip course explores the wide range of formula error messages in Excel for Office 365. Learn how to identify different error messages and how errors occur. You will learn how to use Formula Auditing tools to evaluate and resolve nested formulas and to track errors from source to source. Next, students will learn how to use the data types in Excel to insert and view the information associated with the data, and how to create a loan repayment schedule. This course demonstrates how to use the Goal Seek tool to find a target value. You’ll learn how to use the Solver tool to automatically solve math problems in a table by selecting the value you want to optimize, minimize, or adjust. You’ll then learn how to use One-Click Forecasting to make predictions about historical data and adjust your timeline and seasonality settings, and how to change predicted data after inserting the sheet. Finally, you will learn how to test what-if scenarios while working with data.

Objectives

• Identify formula errors
• Check and evaluate formulas in a workbook
• Insert and view dynamic geographic and action data in a worksheet
• Use formulas to estimate loan costs
• Use Goal Seek 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 historical data
• use of data tables to create what-if scenarios, based on variables