Excel - Forecast, Project, & Explore Data
A one-hour live class on what-if analysis in Excel: data tables to forecast outcomes, scenarios to compare possibilities and working back from a goal to see what it takes to reach it.
About this course
A one-hour live class on what-if analysis in Excel: data tables to forecast outcomes, scenarios to compare possibilities and working back from a goal to see what it takes to reach it.
Curriculum
- 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 to project an outcome.
- Use the Add-In - Analysis ToolPak to analyze data.
- Create a forecast sheet to compile potential outcomes in a sheet.
Who it's for
Analysts and planners using Excel.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Microsoft Office & 365 Apps →55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.