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

microsoft-excel-courses - charts

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Charts

microsoft-excel-courses - Charts

ResolvedVersion Standard

james has attended:
Excel Introduction course
Excel Intermediate course

Charts

whats the easiest way of creating a chart using excel?

RE: charts

The easiest way to creat a chart in excel woul dbe to click on the Chart Wizard on the standard toolbar.

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.1 secs.