Excel - Forecast, Project, & Explore Data

Introduction:

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.

Objectives:

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

$49.00

Select a start date for your 0.25 course

EventDates

2023-02-02 16:00:00_2023-02-02 17:00:00
2023-02-24 16:00:00_2023-02-24 17:00:00
2023-03-20 16:00:00_2023-03-20 17:00:00
2023-04-11 16:00:00_2023-04-11 17:00:00
2023-05-03 11:00:00_2023-05-03 12:00:00
2023-05-25 16:00:00_2023-05-25 17:00:00
2023-06-19 14:00:00_2023-06-19 15:00:00

Clear

Questions About This Course?

Need Help Finding The Right Training Solution?

Our training advisors are here for you.