-
Excel Tutorial – MOD
Read More: Excel Tutorial – MODThe MOD function in Excel allows you to perform a modulus operation, which returns the remainder of a division operation. This can be useful if you want to determine if a number is divisible by another number. To use the MOD function, you will need to follow these steps: Select the cell where you want…
-
Excel Tutorial – SUBTOTAL
Read More: Excel Tutorial – SUBTOTALThe SUBTOTAL function in Excel allows you to perform a specific calculation on a range of cells and ignore hidden cells within that range. This can be useful if you have a large dataset that contains hidden rows or columns and you want to perform a calculation on the visible cells only. To use the…
-
Excel Tutorial – XLOOKUP
Read More: Excel Tutorial – XLOOKUPThe XLOOKUP function in Excel allows you to search for a value in a table and return a value from the same row based on a specified column number or column name. This can be useful if you have a large table of data and you want to quickly retrieve a specific value within that…
-
Excel Tutorial – HLOOKUP
Read More: Excel Tutorial – HLOOKUPThe HLOOKUP function in Excel allows you to search for a value in the top row of a table and return a value from a row below the top row based on the column number. This can be useful if you have a large table of data and you want to quickly retrieve a specific…
-
Excel Tutorial – INDIRECT
Read More: Excel Tutorial – INDIRECTThe INDIRECT function in Excel allows you to reference cells or a range of cells indirectly using a text string. This can be useful if you want to reference cells or a range of cells dynamically, rather than using a fixed cell reference. To use the INDIRECT function, you will need to follow these steps:…
-
Excel Tutorial – INDEX
Read More: Excel Tutorial – INDEXThe INDEX function in Excel allows you to retrieve a value from a range of cells based on the row and column number. This can be useful if you have a large dataset and you want to quickly retrieve a specific value within that dataset. To use the INDEX function, you will need to follow…
-
Excel Tutorial – MATCH
Read More: Excel Tutorial – MATCHThe MATCH function in Excel allows you to find the position of a specific value within a range of cells based on a specified match type. This can be useful if you have a large dataset and you want to quickly find the position of a specific value within that dataset. To use the MATCH…
-
Excel Tutorial – ROW
Read More: Excel Tutorial – ROWThe ROW function is a useful function in Excel that allows you to find the row number of a cell or range of cells. To use the ROW function, you will need to follow these steps: Select the cell where you want the result of the ROW function to appear. Type “=ROW(” (without the quotes)…
-
Excel Tutorial – COLUMN
Read More: Excel Tutorial – COLUMNThe COLUMN function is a useful function in Excel that allows you to find the column number of a cell or range of cells. To use the COLUMN function, you will need to follow these steps: Select the cell where you want the result of the COLUMN function to appear. Type “=COLUMN(” (without the quotes)…
-
Excel Tutorial – MID
Read More: Excel Tutorial – MIDThe MID function is a useful function in Excel that allows you to extract a specific portion of a string of text based on the starting position and number of characters. To use the MID function, you will need to follow these steps: Select the cell where you want the result of the MID function…
