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 2007

replyReply Wed 17 Jun 2009, 15:32Delegate Bianca said...

Bianca has attended:
Powerpoint Intermediate Advanced course
Excel Advanced course
Excel Intermediate course

Formulas

What are all the basic calculations/formulas for Excel?

For upcoming training course dates see: Pricing & availability

replyReply Wed 17 Jun 2009, 17:08Trainer Amanda said...

RE: Formulas

Hello Bianca

Thank you for your question and welcome to the forum.

With regard to basic formulas (ref means reference):

1. All formulas start with =
2. To add cells, use =cell ref+cell ref or =sum(cell:cell) to add adjacent or =sum(cell,cell) to add non-adjacent cells
3. To subtract, =cell ref-cell ref
4. To multiply, =cell ref*cell ref
5. To divide, =cell ref/cell ref
6. =AVERAGE(cell:cell) finds the average of the cell range selected
7. You can use MIN or MAX in place of AVERAGE to find the lowest or highest value in a range, respectively.

Kind regards
Amanda

Wed 24 Jun 2009: Automatically marked as resolved.

 

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

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

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