excel courses in london - i am very confused

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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!

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

resolvedResolved · Low Priority · Version Standard

Olga has attended:
No courses

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

how the hell do they work????

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

 

Training courses

 

Training information:

See also:

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

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

Frequently Asked Questions
What does 'Resolved' mean?

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


 

Excel tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips


Server loaded in 0.08 secs.