excel microsoft training - Calculations

The UK's most regular instructor-led training courses.
Training information: excel microsoft training · Excel-courses-london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Calculations

Barbara has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Barbara [1 post] (2008 Jan 22 Tue, 09:16) Reply

how do you work out the projected percentage of a target figure based on work produced so far; the target firgure also having an end date.
eg target at end date 156,000 - produced so far 94,000 -

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: calculations

by - trainer Rajeev gold contributer [480 posts] (2008 Feb 4 Mon, 16:27) Reply

Dear Barbara

Thank you for attending Excel courses with us.

I am not clear of the question but I am assuming you simply want to know how much work has been done (%) depending on the expected figure and actual figure.

If that is what you are seeking then simply divide the actual work done by the expected target. To make sure it is in % I would format the resulting cell as percentage by choosing Format> Cells… Number tab and choosing percentage with 0 decimal places.

I have uploaded the Excel file based on the info you provided.

If this is what you were seeking then please mark the question as resolved. Otherwise you can ask your specific query by replying back to this message.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003