Published by admin on 29 May 2010
How to Use Goal Seek in Microsoft Excel 2007
Goal Seek is a very useful function in Excel which is used to determine a value which will produce a target figure in a calculation. In this example we have a spreadsheet of salaries and which have been awarded a 5% annual increase. The total increase for all salaries is £7,516, however we only have a budget for £6,200. Here is how we would solve the problem with Goal Seek:

- First download the Excel spreadsheet Salary Increases.
- Next click the Data tab on the Ribbon, then click What If Analysis and select Goal Seek.
- In the Goal Seek dialogue box enter D11 in the Set Cell field.
- In the To Value field type the value 6200.
- For the By changing cell field enter cell reference B3.
- Finally click OK and Goal Seek will calculate the correct salary percentage increase to meet the budget of £6200.
This is a very simple Excel tool, but one which can save a lot of time. We cover this and many other time-saving topics on our Microsoft Excel 1 day courses. We specialise in on-site training and can deliver Foundation, Intermediate and Advanced levels of Excel at your own offices anywhere in the UK. For more information email info@pbatraining.co.uk or call free on 0800 2922842.
We are running Microsoft Excel Training Course in Cheshire including Chester, Crewe, Nantwich, Sandbach, Warrington & Widnes throughout June and July. Increasing your staff’s knowledge on Excel can make a big difference to productivity and our Foundation, Intermediate & Advanced training courses will give them approved, structured learning. For more details about our 1 day on-site Microsoft Excel courses please call freefone 0800 2922842 or email
Throughout June we are booking Foundation & Advanced Microsoft Project training courses in Derbyshire including Alfreton, Bakewell, Buxton, Chesterfield, Matlock & Ripley. We are specialists in on-site IT training and are qualified to deliver Microsoft Project training at your offices anywhere in the UK. Our daily rates are very competitive and we do not charge travelling or other hidden expenses.
We are pleased to announce Sage training courses in Lancashire including Accrington, Blackburn, Bolton, Burnley, Bury, Chorley, Colne, Oldham, Preston, Rochdale & Salford. This is thanks to our new associate tutor and we would like to say a very warm welcome to Eric Crimmins. Eric is accredited as a Sage 200 trainer and is qualified teacher with many years of industry experience. He lives in Colne and will be looking after Sage training throughout the Lancashire region. Eric will also be delivering Microsoft Excel & Access training for us in the area and we look forward to working together in the future.
We are delivering Foundation & Advanced Microsoft Word Training Courses in Surrey throughout 2010 including Byfleet, Crowhurst, Godalming, Guildford, Horley, Leatherhead, Redhill, Reigate & Weybridge.