Function

Logical :

We will learn use of AND, FALSE, IF, IFERROR, NOT, OR, TRUE here.

TEXT :

With the use of Text function in excel, we can do various text operations, like combine t cell value, trimming cell from left, right side, splitting text etc. For more we have study on particular function.

Date and Time :

With the use of Date & Time function in excel, we can calculate date , time, fetch today’s date, different between to days and more thing. For more we have study on particular function.

Lookup & Reference :

You use these functions when you want to carry out more than one comparison in your formula or test multiple conditions instead of just one.

Maths :

With the use of Mathematical function we do various arithmetic opertions like adding that value from a range, finding average etc. For more we have study on particular function.

Statistical :

You use these functions when you want to carry out more than one comparison in your formula or test multiple conditions instead of just one.

Information :

With the use Information function we get information about the sheet & its contents like, cell value is even number or not, cell has error. For more we have study on particular function.