Category: Formulas

Editing Multiple Formulas

Here is a very useful tip about editing multiple formulas at once. This one will save you a lot of time and effort whenever you...

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.