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. 

It is best to complete this course in one sitting, if you do need to stop the training midway, please enable cookies for our website and allow popups (turn off your popup blocker) so that you don't lose progress for the course.


Topics Covered

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


0.3 hours


Best Practices


As Neeeded

Who Should Attend:

All Employees Who Use Excel 2016