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 · Low Priority · Version 2003

Niklas has attended:
Excel Introduction course

Excel

Can I download additional charts from Microsoft etc?

Edited on Fri 27 Jun 2008, 10:10

RE: Excel

Hi Niklas

The best place to look for new and different charts is Microsoft's own site.

Users are always designing new templates and updating the site. The link below takes you to a few examples which can be downloaded:

http://office.microsoft.com/en-us/templates/results.aspx?qu=chart +types&av=TPL000

Hope this helps

Carlos


 

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


Server loaded in 0.09 secs.