basic excel training - Formulas

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

Resolved · Low Priority · Version Standard

Formulas

Sajid has attended:
Excel Intermediate course

by - delegate Sajid [1 post] (2007 Feb 8 Thu, 09:58) Reply

how 2 do formulas

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: formulas

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 8 Thu, 11:29) Reply

Good morning Sajid,

This is a very open question ! Do you mean formulas which you wish to create for example..

= A1 + B1

If this is the case you need to make sure your cursor is in the cell you would like you result/output to be in.

You then press the = sign and you can either type the characters A1 or click into the cell A1, after this you click an operator, in this case the + sign and continue to type or click into cell B1, once you have finished press the enter key and you should be left with the sum of the values in cell A1 and B1.

I hope that helps! Your training today will cover formula so you may find your initial question will be answered over the course of the day. If not feel free to post another question on the forum

Tracy

· Compare Different MS Excel Training Methods
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Microsoft Excel Training Course
· How to Create Better Excel Spreadsheets: Part Three

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips