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 TRUEContinue reading “Statistical Functions in Excel”

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  ReturnsContinue reading “Math & Trigonometry Functions in Excel”

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.Continue reading “Lookup & Reference functions in Excel”

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 validContinue reading “Date & Time functions in Excel”

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)  CODEContinue reading “Text Function in Excel”

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 theContinue reading “Logical Functions in Excel”