ACOS Function
The ACOS Function returns the inverse cosine of a number in radians. The number must be between -1 and 1. If the number is outside -1 to 1, […]
Excel
Learning Excel has never been easier. Review hundreds of Excel tutorials geared towards beginners all the way to experts.
Relative Reference in Excel
Relative Reference in Excel points to a cell or range of cells. However, this is pointed to cell is not locked like an absolute referenced cell. In Excel,
Relative Reference in Excel Read More »
Absolute Reference in Excel
Absolute reference in Excel refers to a cell reference that is “locked.” This means that the rows and columns won’t change when copied within a spreadsheet (or sheets).
Absolute Reference in Excel Read More »
Coil Steel Price per ft and in
Learn how to quickly calculate the coil steel price per ft and the coil steel price per in. For a quicker option, download the demonstration file. Coil Steel
Coil Steel Price per ft and in Read More »
Split String by colon, semi-colon, comma, or delimiter
This quick example will demonstrate how to split a string by a colon, semi-colon, comma, or delimiter in Excel. The example below will split a name from the
Split String by colon, semi-colon, comma, or delimiter Read More »
IPMT Function
The IPMT function in Excel is used to calculate the interest portion of a loan given a specified payment period. Syntax: Arguments: rate – Interest rate per period.