Category: Formulas

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.

PMT Function

Pmt function is used for calculating payment of a loan based on constant payments and constant interest rate. In other words, it helps you calculate...