Advance Excel

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 the average calculation. If the cell contains zero 0, the cell will be included in the average calculation. Syntax =AVERAGE(Range1,Range2,Range3… through to Range30)    

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 when you need to count the number of times a particular combination of values or conditions appears in a range of cells. For example, let’s say you have a list

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 need to count how many times a particular value or condition appears in a range of cells. For example, let’s say you have a list of exam scores and 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 useful when you need to sum up values that meet more than one condition. For example, let’s say you have a list of sales figures for different products in different

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 when you need to sum up only those values in a range that meet a certain criteria. For example, let’s say you have a list of sales figures for different

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 search a data range that is set up Horizontally. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row. Syntex HLOOKUP (lookup_value, table_array,

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 returning the value in the same row in the index_number position.   The VLOOKUP function is a built-in function in MS Excel, which allows to the user for searches data

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. Use the LOOKUP function to look up a value in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range.   Some uses of

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. It means how many times a data value has occurred amongst a given set of values. Syntax =FREQUENCY(data_array, bins_array)   Data_array – It is an array or reference to a

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 a column letter and a row number. Each worksheet in Excel consists of several cells. Each cell has a specific cell reference which helps the users to find easily address