excel courses in london - I am very confused about how to use formulas, call me silly but!

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Certified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

excel courses in london - I am very confused about how to use formulas, call me silly but!

I am very confused about how to use formulas, call me silly but!

Olga has attended:
No courses

by - delegate Olga [1 post] (2008 Jan 9 Wed, 11:25) Reply

how the hell do they work????

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 5 Fri	Bayswater	0	FULL
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	4	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	1	book now	£235	£240
Full Schedule: See all 95 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: I am very confused about how to use formulas, call me silly

by - trainer Amanda diamond contributer [1243 posts] (2008 Jan 11 Fri, 13:54) Reply

Hi Olga

Thank you for your question.

Formulas in Excel can be confusing, however they are very useful. The main advantage of formulas is that they will automatically recalculate - if any of the inputs into the formula change, then the formula result will automatically change.

For example, if you typed 2 into cell A1 in Excel, and you typed 1 into cell B1, then in cell C1 type =A1+B1 and press Enter. The formula in cell C1 should display 3 (the number in cell A1 added to the number in cell B1). Try changing the numbers in cells A1 and B1 and you should see the result in cell C1 change as you make changes to the two numbers.
This is automatic recalculation.

If you replace what is in cell C1 with =A1-B1 the cell will show the result of minusing the number in cell B1 from the number in cell A1. Again, if you change the numbers in these cells, the result of the formula will change.

If you wish to multiply then use an asterisk * in place of the - sign in the formula above. If you wish to divide, use /

Lastly when you are creating formulas the first thing you must always enter into a cell is =

I hope this helps.
Amanda

Training by application

Main information pages

excel courses in london - I am very confused about how to use formulas, call me silly but!

Related articles

Excel tip:

Change the default location for opening and saving spreadsheets