Excel 2007

The UK's most regular instructor-led training courses.
Training information: excel 2003 visual basic intermediate course · Excel advanced · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel 2007

Kelly has attended:
Excel Introduction course

by - delegate Kelly [1 post] (2008 Mar 10 Mon, 16:51) Reply

Can you tell me more about the basic functions, when would be best to use Excel?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel 2007

by - trainer Mark gold contributer [180 posts] (2008 Mar 14 Fri, 11:43) Reply

Hiya Kelly

How are you today, hope you enjoyed the training course on Monday

The answer to your question about basic functions there are some examples below for you to look at and try them out

=b3+b4+b5+b6+b7+b8 will add up the cells
=sum(b3:b8) will do the same as above & easier to write
=average(b3,b7,g10,h5,d9) will calculate the average of the cell
=sum(b3,b7,g10,h5,d9) will do the same as the average but will add them up

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please click reply or post it as a new question and we should be able to answer that!!

Hope this helps

Mark East
mark@microsofttraining.net

· How to Create Better Excel Spreadsheets: Part Four
· Fun Things I've Done With Excel
· Database Tips from an Excel Training Course
· How to Create Better Excel Spreadsheets: Part Three
· Advanced Excel Training - takes you to the next level

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips