Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - I am very confused about how to use formulas, call me silly but!

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

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

Resolved · Low Priority · Version Standard

Reply Wed 9 Jan 2008, 11:25Delegate Olga said...

Olga has attended:
No courses

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

how the hell do they work????

For upcoming training course dates see: Pricing & availability

Reply Fri 11 Jan 2008, 13:54Trainer Amanda said...

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

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

Excel articles

· What's mine is yours: Sharing data in Excel
· How To Get The Best Out Of Excel With The Internet
· A Brief Glimpse At Excel's What If Analyses Tools
· Crazy Things People Have Done With Excel
· From novice to expert users - Microsoft Excel fits all

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips