certificates
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Certificates

resolvedResolved · Low Priority · Version 2007

replyReply Wed 14 Sep 2011, 15:36Delegate Peter said...

Peter has attended:
Excel Introduction course
Excel Intermediate course
Access Introduction course

Certificates

I recently attended an introduction and intermediate level excel course. Can you provide me a certificate for these?
Many Thanks
Peter

For upcoming training course dates see: Pricing & availability

replyReply Thu 15 Sep 2011, 10:05Trainer Yolande said...

RE: Certificates

Hi

Thanks for your certificate request, we've printed one off and it will be sent to you within a week.

Best regards

Yolande

 

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

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard