0
Browsing Category

Excel

Bigdata Excel

VARP in Excel

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
Bigdata Excel

Value in Excel

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 More
Bigdata Excel

VLOOKUP in Excel

VLOOKUP 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 More
Bigdata Excel

YEARFRAC in Excel

YEARFRAC 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 More
Bigdata Excel

Date in Excel

Date 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 More
Bigdata Excel

Cell in Excel

Cell 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