Register now or log in to join your professional community.
I'm agree with all answers, Thank you Mr. Ahmed Allam for invitation
simply is that when one cell is a part of a formula and you want it to have a specific value. So, using goal seek to tell Excel which cell he needs to change to give you your output exactly.
I am using it most of the time it is very useful. you can find a lot of examples on YouTube.
It means by simple to let excel find the value of cell depending on the formula on another cell and by determining the target value and the cell which you want excel change its value.
This can be done from Data > Data Tools > What if Analysis.
Review the toturial on the link below:
http://www.homeandlearn.co.uk/excel2007/excel2007s7p4.html