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 Tue 10 Feb 2009, 16:17Delegate Aileen said...

Aileen has attended:
Excel Intermediate course

Formulas

I would like to learn more about formulas

For upcoming training course dates see: Pricing & availability

replyReply Wed 11 Feb 2009, 11:43Trainer Amanda said...

RE: Formulas

Hi Aileen

Thank you for your question and welcome to the forum.

We do cover how to create formulas on the Excel Introduction course, so I've included a link below so you can download our Introduction level handbook:
http://www.microsofttraining.net/download/trainer/courseware/excel_2007_introduction.zip

Basically all formulas start with an = sign.
To add, use the SUM function =SUM() and enter the cells you wish to add together into the brackets (e.g. A2:A15).

Alternatively you can use + but I would only do this if you are adding say 2 or 3 cells together, e.g. =A1+A2+A3

To subtract use -
e.g. =A1-A2 minuses the value in cell A2 from the value in cell A1

To multiply use * (asterisk)
e.g. =A1*A2 will multiply the values in A1 and A2 together

To divide use / (forward slash)
e.g. =A1/A2 divides the value in cell A1 by the value in cell A2

I hope this helps.
Amanda

Wed 18 Feb 2009: Automatically marked as resolved.

 

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

Excel tip:

Page Break Preview in Excel 2010

If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want.

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