Functions

Statistic

View page »

Find

View page »

Text functions

View page »

3D Function

Excel performs calculations in a spreadsheet but it is also possible to perform calculations across multiple worksheets, this is called 3-dimensional (3D) functions Contents1 Presentation2 Performing a 3D formula Presentation Say you have a workbook that contains one sheet per month and another that will synthesize the year. Year in the sheet you want to …

View page »

Condition

View page »

Date & Time

Each function concerning date and time will be reference in this menu

View page »

INDIRECT

The INDIRECT function gives you the possibility to create a relation between your worksheet’s name and your cell’s reference containing your worksheet’s name. Contents1 Principe2 Method3 Miscellaneous Principe In the opposite example, we want to return the calling code for each countries of the column A. You can see that the data in column A is …

View page »

Leave a Reply

%d bloggers like this: