Forecasting & Solving Problems

Excel Microsoft 365 (Windows)
  • 8 Videos | 49m 32s
  • Includes Assessment
  • Earns a Badge
Likes 122 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

  • Playable
    1. 
    Understanding formula errors
    5m 36s
    UP NEXT
  • Playable
    2. 
    Reviewing & debugging formula errors
    6m 7s
  • Locked
    3. 
    Using intelligent data types
    6m 14s
  • Locked
    4. 
    Calculating the interest on a loan
    5m 54s
  • Locked
    5. 
    Reaching a target value
    5m 9s
  • Locked
    6. 
    Solving a problem
    5m 39s
  • Locked
    7. 
    Using the forecast tool
    6m
  • Locked
    8. 
    Using data tables
    4m 54s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 238 Likes 238  
Likes 713 Likes 713  
Likes 139 Likes 139