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

Certificates

ResolvedVersion 2007

Tue 10 Jul 2012, 15:52 Delegate Beverley said...

Beverley has attended:
Taking Minutes course

Certificates

Please assist me with downloading my certificate for the Microsoft Excel Intermediate Training completed.

Please also remind me how to count the number of "yes" in a given range of cells e.g count the number of Yes from C4 to C53.

Thanks

Tue 10 Jul 2012, 17:48 Trainer Anthony said...

RE: Certificates

Hi Beverley, good to hear from you! Your certificate will be posted to you shortly. As for counting the number of yes values try:

=COUNTIF(c4:c53, "Yes")

Hope this helps,

Anthony

Wed 11 Jul 2012, 10:29 Delegate Beverley said...

RE: Certificates

Thank you, this works.

Please post the certificate to:

Beverley Nzeadi
Stornoway House
13 Cleveland Row
London SW1A 1DH

Many thanks!

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes

View all Excel hints and tips

Certificates

Certificates

RE: Certificates

RE: Certificates

Excel articles

Excel tip:

Difference between Two Dates