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...
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...
Extract Text From String With Known Position
You may need to get a part of a text string from within another text string. If you know starting position of the text you...
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...
