Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Resolved · Low Priority · Version Standard
Sarah has attended:
Excel Intermediate course
Can you provide me with some information regarding basic formula calculations that I can use for references purposes on a day-today basis?
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:Make macros work in newer versions of ExcelIf you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using. |
We'll call during UK business hours
Server loaded in 0.07 secs.