This function calculates the variance of a list of values. The variance is calculated on the basis that the values represent the entire population. …
Read More
This function converts a piece of text which resembles a number into an actual value. If the number in the middle of a long piece…
Read MoreVLOOKUP in Excel This function scans down the row headings at the side of a table to find a specified item. When the item is…
Read MoreYEARFRAC in Excel This function calculates the difference between two dates and expresses the result as a decimal fraction. Microsoft Excel Function =YEARFRAC(StartDate,EndData,Basis) Basis :…
Read MoreWeekday in Excel This function shows the day of the week from a date. Microsoft Excel Function =WEEKDAY(Date,Type) Type : This is used to…
Read MoreWorkday in Excel Use this function to calculate a past or future date based on a starting date and a specified number of days. The function…
Read MoreDate in Excel This function is used to manipulate the date time. Microsoft Excel Function =DATE(year,month,day) Formatting The result will normally be displayed in…
Read MoreConcatenate in Excel This function joins separate pieces of text into one item. Microsoft Excel Function =CONCATENATE(Text1,Text2,Text3…Text30) …
Read MoreCombine in Excel This function calculates the highest number of combinations available based upon a fixed number of items. The internal order of the combination does…
Read MoreCell in Excel This function examines a cell and displays information about the contents, position and formatting. Microsoft Excel Function =CELL(“TypeOfInfoRequired”,CellToTest) Formatting …
Read More