Excel’s best-kept secret: What-If Analysis tools

What-If Analysis tools are a well-kept secret in Excel, located on the Data tab, Data tools group. Scenario manager You’ve probably seen payment calculators that let you adjust terms and rate.Chances are you’ve “plugged and played” various scenarios ending up with, “That second scenario looked good! What was that?” Scenario Manager allows you to save […]

Read More
Learn Goal Seek Method Most Useful Forecasting Tool

Learn Goal Seek Method : Most Useful Forecasting Tool

Learn Goal Seek Method : Most Useful Forecasting Tool Example with detailed explanation, on request from Mr Karthi Keyan How Goal Seek Works. ============== Goal Seek feature allows you to alter the data used in a formula in order to find out what the results will be. The different results can then be compared to […]

Read More