formulas
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Formulas

resolvedResolved · Low Priority · Version 2003

replyReply Thu 2 Oct 2008, 17:01Delegate Maggie said...

Maggie has attended:
Excel Intermediate course

Formulas

how to put together formulas?

For upcoming training course dates see: Pricing & availability

replyReply Fri 3 Oct 2008, 12:06Trainer Rajeev said...

RE: formulas - Calculation order (BODMAS)

Dear Maggie

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

As there are so many formulae and functions the question you asked is not very straightforward. There is however a structure that you have to follow in performing any formulae.

First remember that any formulae starts with an = sign.

Second you can click on the cell that you want to include in the formula.

Use the operator (these are PLUS, MINUS, MULTIPLY, DIVIDE, Brackets, etc

 

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

Excel tip:

Finding cells that have data restrictions

Click anywhere on the worksheet.
On the Edit menu, click Go To.
Click Special.
Click Data validation.
Click All.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard