The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel training

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

Excel training

Resolved · Low Priority · Version 2003

ReplyWed 10 Mar 2010, 16:29Delegate Magdalena said...

Excel training

how do I create formulas?

For upcoming training course dates see: Pricing & availability

ReplyThu 11 Mar 2010, 10:19Trainer Simon said...

RE: Excel training

Hi Magdalena,

Thank you for your question and welcome to the forum.

To create a formula such as adding two cells together, click into the relevant cell and start with the Equals sign. Then click on the relevant cells inserting the + symbol between the two cells and pressing enter to complete the formula.

=A1+B1
=A1*B1
=A1-B1
=A1/B1

I hope this answers your question.

Regards

Simon

Wed 17 Mar 2010: Automatically marked as resolved.

Excel articles

· Learn The Secrets Of COUNT Functions In Excel
· Want To Get To Grips With The Different SUM Functions In Excel?
· Microsoft Excel Training: Not Just for Newbies Anymore
· Do You Really Need Excel VBA Training?
· Microsoft Excel provides the building blocks of shared information

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips

What would you suggest using hyperlinks for?

» Forum post: Hyperlink

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions