Excel Functions
The functions in Excel do most of the current work and there are functions to do many things.
The function can have parameters and you have to respect the rules of it.
Help in functions
If you press the equal sign it will show you a helping page explaining each of the parameters of the function and allowing you to ask for extra help.
Tip about Excel functions
You may create your own functions in VBA and use them where you want.
"I have my data in Excel and they were able to add France District information over it and make several resume tables to show the reservation and cancelation of housings per district and month."
MARY SMITH. UK
Excel Functions
Functions in Excel are the basis of data manipulation.
Basic Functions
The functions more used in some cases have more than one way to be done.
SUM, COUNT, MAX, MIN
Search Functions
The search functions in Excel allows to find values in the spreadsheet.
INDEX is the most popular function.
Error functions
The error functions are used to check the validity of cells or properties of these cells.
ISERROR, ISNUMBER or ISTEXT are same samples
Database functions
You can define areas of excel as tables and there are some functions to work with these tables like databases.
INDEX(block; Line; Column)
It allows you to find the value of a cell inside a certain block.
Is used more to retrieve a certain column from a record in a block.
Your block may be defined with a name or absolute coordinates in order that you can copy the formula to other place and keed the reference to the same block.
Page created and hosted by
(c) 2019-2021 – 1000megabytes