Category: Formulas

PV Function

PV Function is used for calculating the present value of a future amount of money. As discussed in Time Value of Money, value of an...

Time Value of Money

This post is a explainatory post for Financial Functions of Excel. In order to understand some of the financial functions, you need to have a...

Extract Text From String

If you need to extract text from string in Excel with a known character, there is an easy way of doing this with just one...

Subtotal Function

Subtotal function is a versatile function that can answer a lot of your needs all by itself. Besides it has some cool tricks in its...