Statistical Functions in Excel

Hello All. In this section, let’s look into all the Statistical functions available in Excel. Here is the table with Syntax and Usage Function Usage Syntax AVEDEV Returns the average of deviations from their mean =avedev(number1,[number2],..) AVERAGE Returns the average of selected arguments =average(number1,[number2],..) AVERAGEA Returns the average of selected arguments including logical values TRUE … Read more

Math & Trigonometry Functions in Excel

Hello All. In this section, let’s look into all the Math and Trigonometry functions available in Excel. Here is the table with Syntax and Usage  Function Usage  Syntax  ABS  Returns absolute value of a number =ABS(number)  ACOS  Returns the arccosine of a number (o to pi) =ACOS(number)  ACOSH  Returns inverse hyperbolic cosine =ACOSH(number)  ACOT  Returns … Read more

Lookup & Reference functions in Excel

Hello all. In this section, let’s look into all the Lookup & Reference functions available in Excel. The below table lists out the function and its usage / syntax. Function Usage Syntax ADDRESS Returns the address of the cell based on row & column number =address(row_num,col_num,[abs_num],[a1],[sheet]) AREAS Returns the number of areas in a reference. … Read more

Date & Time functions in Excel

Hello All. In this section, let’s look at all the Date&Time functions in excel. Here is the table with the usage & syntax for all the functions under this category.  Function Usage  Syntax   DATE  Create a date with year, month & date  =Date(year, month, date)  DATEVALUE  Convert a date in text format to a valid … Read more

Text Function in Excel

Hello All. In this section, let’s look into all the Text functions available. Here is the table with the usage and syntax for all the Text functions in Excel    Function Usage  Syntax   CHAR  Return a specific character based on the numerical value input =CHAR(number)   CLEAN  Removes all non-printable characters from the text  =CLEAN(text)  CODE … Read more

Logical Functions in Excel

Hello All. In this section let’s look into all the logical functions available. Here is the table with the usage and syntax for all the functions.  Function  Usage  Syntax  AND  Test multiple conditions and returns true if all conditions are true  =AND(Logic 1, Logic 2,…)  FALSE  Returns the logical value FALSE  =FALSE()  TRUE  Returns the … Read more