excel computer training london

excel computer training london - Formula

Resolved · Low Priority · Version Standard

Formula

Taylan has attended:
Excel Introduction course

by - delegate Taylan [1 post] (2007 Mar 28 Wed, 09:47) Reply

How do I create formulas?

Maths isn't my strong point!

Many thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Formula

by - trainer Amanda diamond contributer [1240 posts] (2007 Mar 28 Wed, 15:34) Reply

Hi Taylan

Thanks for your question.

The good news is if you want to add things together you can use the AutoSum button on the standard toolbar in Excel. Otherwise all formulas begin with an = sign and you can perform subtractions (-) multiplications (*) and division (/) - these need to be typed into a formula. The names of cells can be inputted by clicking directly on the cell.

Good luck!
Amanda

· MS Excel: Excel At Making The Most Of Your Christmas
· Improve Performance Of Your Excel Macros
· From the Classroom to the Corporate World
· What's Better Than the Help Function in Excel? Microsoft Training
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Rate this page: