excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Excel

resolvedResolved · High Priority · Version 2003

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.

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 tip:

Charts

Select the data and press the function key F11 and the chart will be created on a separate worksheet.

View all Excel hints and tips


Server loaded in 0.09 secs.