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

Formulae

ResolvedVersion 2003

Mon 10 Nov 2008, 16:26 Delegate Nick said...

Nick has attended:
Excel Introduction course
Excel Introduction course

Formulae

I think that I will need further help with their application

Wed 26 Nov 2008, 09:38 Trainer Mark said...

RE: Formulae

Hi Nick

Sorry for not getting back sooner

Here is a couple of quick formulas for you to use

to add a column of figure up nice and easy eg. =sum(b2:b15)
this will add up from cell b2 to b15 you can also do average formulas all you do is replace sum with average

If you need any help just post a question and we will be happy to assist

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Tue 2 Dec 2008: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips

Formulae

Formulae

RE: Formulae

Excel articles

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010