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

Formulas

ResolvedVersion 2003

Wed 11 Jun 2008, 15:57 Delegate Julie said...

Julie has attended:
Excel Advanced course

Formulas

Are there more courses available to just specific types of formulas..i.e SumIf, NestedIf, Round Formula?

Thu 12 Jun 2008, 10:04 Trainer Mark said...

RE: Formulas

Hi Julie

How are you doing, thanks for your question and there is only one answer to this if you want more info on the formulas you mentioned i would recommend you go through the documentation on the CD in the back of the manual that you had from yesterday

This will help you out with more info on these things

But the course you were on yesterday is the only course that goes through this

Hope this helps

Mark East
mark@stl-training.co.uk

MOUS Master Instructor

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

Use the SUBTOTAL function in Excel