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 – 1000megabytes 

en_USEnglish
en_USEnglish