Excel - Forecast, Project, & Explore Data


Provide an understanding of the Automated Analysis Tools: Data Tables, Scenarios, Goal Seek, Solver, and Analysis ToolPak. Used the tools to analyze and investigate data, many times on a hypothetical basis. Each element is used for advanced data analysis and forecasting.


Course Outline:

1 – Outline

  • Determine potential outcomes using data tables to forecast data and see the impact.
  • Determine potential outcomes and create scenarios to see the effects.
  • Learn to see what is needed to reach a goal or retention.
  • Learn to use Solver o project an outcome.
  • Use the Add-In – Analysis ToolPak to analyze data.
  • Create a forecast sheet to compile potential outcomes in a sheet.

Enroll in this course


Need Help Finding The Right Training Solution?

Our training advisors are here for you.

USD United States (US) dollar