Category: MS Advance Excel Course

This function calculates the average from a list of numbers. If the cell is blank or contains text, the cell will not be used in …

COUNTIFS is another Excel function that allows you to count the number of cells that meet multiple criteria within a range. This function is useful …

COUNTIF is an Excel function that counts the number of cells within a range that meet a specified criteria. This function is useful when you …

SUMIFS is another Excel function that allows you to sum up the values in a range of cells based on multiple criteria. This function is …

SUMIF is an Excel function that adds up the values in a range of cells based on a specific condition. This function is very useful …

HLOOKUP stands for ‘Horizontal Lookup’. It is a function in Excel that makes search for a certain value in a row. HLOOKUP allows you to …

VLOOKUP stands for Vertical Lookup, The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and …

The Microsoft Excel LOOKUP function is one of the most popular functions of MS Excel. This Function is categorized under Excel Lookup and Reference functions. …

The FREQUENCY function in Excel help you to calculating the frequency (no of repeated value) of a data set within a given range of values. …

A cell reference refers to the name or address of a specific cell or range of cells within the spreadsheet which is a combination of …