Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
formulas

ResolvedVersion Standard

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?

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

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.