Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · High Priority · Version 2003

Reply Wed 13 Oct 2010, 12:50Delegate Jay said...

Jay has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Excel

I need to calculate the percentage of times a report is run over the scheduled time using two criteria. the name of the report and the month its run in.

I have a list or reports, list of months and list of completion times along with the scheduled completion time.

For upcoming training course dates see: Pricing & availability

Reply Fri 29 Oct 2010, 13:56Trainer Jacob said...

RE: excel

Hi Jay

Thanks for your post which a colleague has passed for my attention. A solution could present itself in 10 minutes or take several hours, what we would need to so is:

1) Have you send us your working files
2) Bullet point all the items you are trying to achieve

We will then review and if a solution is available we will let you know the scope of work to complete:

1) Duration (hours/days)
2) Breakdown of work
3) Schedule of work

Only upon your agreement will work commence. If you wish to discuss this further please get in touch or if it can wait till your attendance on our Excel VBA course in December, depending on any spare time your trainer has, they may be able to give you a few pointers.

Kind regards

Jacob

Fri 5 Nov 2010: Automatically marked as resolved.

Excel articles

· How To Use Slicers In Excel 2010
· Make A Custom Sort List In Excel
· Excel in the Home Office
· Find Out Your Age In Days With Excel
· How To Use Excel To Track Your Weight Loss

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips