Microsoft Excel 2016 Level 3.6 Forecasting Data

  • E-Learning

Knowing how to utilize data to predict future trends can be useful in business. Employees will learn how to forecast data in Microsoft Excel 2016. This course teaches viewers how to use data tables to create a what-if analysis. 

Viewers learn how to work with multiple variables using data scenarios. Finally, the course demonstrates how to visibly display data trends. Use this course to educate employees about using data forecasting tools to create worksheets to help predict future trends. 

 

Topics Covered

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Data Scenarios 
  • Use The Goal Seek Feature
  • Forecast Data Trends
     

Duration:

0.3 hours

Code/regulation:

Best Practices

Frequency:

As Neeeded

Who Should Attend:

All Employees Who Use Excel 2016