How To Create Basic Formulas In Microsoft Excel


Formulas

All Formulas and Functions begin with =. It is the = sign that tells Excel it is going to be doing something mathematical. You will need to ensure you click in the cell you would like the answer to display in. The difference between Formulas and Functions is Formulas use symbols like on the calculator + – the multiply is the * and the divide is the / .

All Calculations Begin with =

OPERATORS
Multiplication*
Division/
Addition+
Subtraction

= Cell Ref Operator Cell Ref

Order of Operations

Formulas are not worked on left to right as you might think. You must follow a specific order a rule. BODMAS is the acronym for what must be done first, second and third.

The BODMAS Order

B ( )

Exponential eg 3m2

D /

M *

A +

S –

Eg; 5+ 2 * 10 = 25

If you need 70 to be your answer

Add brackets to the formula

(5+2)*10 = 70

Watch this video for a demo on how to create a basic formula using Microsoft Excel.

Functions

Functions follow a structured and there are over 300 functions pre-defined in Microsoft Excel eg = sum (A1:A12) . When creating a function start with = then the function name followed by an open bracket, this bracket is important if you do not have it there is no function. Watch this video to demonstrate how to construct a basic function.

Microsoft Office Small Group Training Sessions

AZ Solutions Pty Ltd delivers customized training courses here in Sydney – Australia. We come to you. All you need is a board room, PC’s for each student and a TV/ Projector with a HDMI connection cable. In our training sessions you are welcomed to bring examples of your work to class. We prefer it.

Call Now M 0414 417 059 visit www.azsolutions.com.au

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s