These tools work very well when you either want to try seeing how things would look with different variables in place, or when you need to work out what variables will drive the outcome you’re looking for.
Performing what-if analysis in Excel using the Scenario Manager and Goal-Seek.