Category: Formulas

Volatile Functions in Excel

There are some functions that can generate a different result with each recalculation even when none of its arguments changed. Let’s see what the volatile...

Excel Formula Exercises 1

I am starting a new series of posts for you to sharpen your skills with Excel formulas. Each post will include 4-5 excel formula exercises...

Hiding Excel Formulas

Sometimes you may not want users to see your formulas for a number of reasons. If that is the case, I have good news for...

Rate Function

Rate function is used calculating interest rate per period for a loan.

Nper Function

Nper Function is used for calculating number of periods for an investment based on periodic, constant payments and constant interest rate.