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.