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

certificates

ResolvedVersion 2010

Certificates

Can I please have a certificate for this course?

RE: Certificates

Hi Jonathan

Your certificate for Excel 2010 Introduction will be posted to you shortly. Did you want certificates for the other courses you attended or do you have them already?

The question you asked on your course about icon sets was intersting. I've attached a solution but puts the icons in the adjacent column.
I'll let you know if we find another way.

Cheers
Doug
Best STL

Attached files...

iconsets.xlsx

RE: Certificates

Thanks very much for your attachment. Yes I believe one of my certificates is on its way for Project Intermediate, otherwise I don't have any and would be very grateful if someone could send them to me.


Regards,
Jonathan Theophile

Edited on Thu 16 Aug 2012, 16:46

RE: Certificates

Hi Jonathan.
Your certificares are on their way.

Regards
Doug

Thu 23 Aug 2012: Automatically marked as resolved.

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.