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 Standard

replyReply Tue 19 Feb 2008, 16:44Delegate Sarah said...

Sarah has attended:
Excel Intermediate course

Formulas

Can you provide me with some information regarding basic formula calculations that I can use for references purposes on a day-today basis?

For upcoming training course dates see: Pricing & availability

replyReply Sat 23 Feb 2008, 21:19Trainer Cress said...

RE: Formulas

Hello

There are many many formulas and there are very good examples in the excel help files. If you cant find what you are looking for then please let us know exactly what you are trying to do and we can help you with the formula. Go to Help, Microsoft Excel Help. Common formulas to use are as follows:

vlookup = to see if values from one set of data exist in another set of data.
Left= to get any number of characters from the left of the value
Right = to get any number of values from the right of the value
SUM = to sum values
Count = to count values

 

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

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

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