 ## ROW Formula in Excel

How to Use the ROW Formula in Excel The ROW formula in Excel is used to find out the number of a row where a reference cell is located in the worksheet. This is a commonly used function or formula that you use in advanced financial modelling if you have got a large... ## LEFT, RIGHT Formula in Excel

How to Use the LEFT, RIGHT Formula in Excel The left, right formula in Excel displays a specified number of characters from the left/right hand side of a piece of text. They are useful if you want to extract part of the contents of a cell. Formula Explanation: text:... ## COLUMN Formula in Excel

How to Use the COLUMN Formula in Excel The Column formula in Excel is used to find out the number of a column where a reference cell is located in the worksheet. This is a commonly used function or formula that you use in advanced financial modeling if you have got a... ## RATE Formula in Excel

How to Use the RATE Formula in Excel The RATE formula in Excel is used to calculate the interest rate per period of an annuity. The Rate formula can also come in handy when you are trying to really identify that interest rate or rate of return when you have several... ## OFFSET Formula in Excel

How to Use the OFFSET Formula in Excel The OFFSET formula in Excel is used to return a range that is a specified number of rows and columns from a reference cell or range. This is a unique formula in the sense that it is not often used by a lot of people, and it is...