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...
HLOOKUP Formula in Excel
How to Use the HLOOKUP Formula in Excel The HLOOKUP formula in Excel is used when you have a specific item you’d like to lookup in a table and there is only one of that item in the table i.e. it is unique and you want to reference something that exists within a...
