What if

Hello Lin

Thank you for your question and welcome to the forum.

There will be certain parts of Excel that are relevant to the job that you do, so there are probably a lot of Excel features that people don't use because their roles don't require them to.

Goal seek and Solver both belong to the 'what-if' analysis tools within Excel. These tools are often used to try and ascertain what might happen in future, therefore can be used when looking at future budgets, and for modelling and forecasting.

There is a general introduction to the different 'what-if' analysis tools on the following page:
http://office.microsoft.com/en-us/excel/HA102431641033.aspx

Kind regards
Amanda