Use Goal Seek to Forecast Profit
Excel’s Goal Seek feature is extremely valuable when you know what answer you want from a calculation, but don’t know the exact figure to input to get it. You can learn more about Goal Seek on our Excel Courses in Brighton, Sussex.
As an example – you might have a profit target of £170 on a particular job, and want to know what profit percentage would achieve that figure.
This video tutorial on Goal Seek in Excel 2007 explains how to achieve this:
