Top Excel Tips
This will be an ever improving Top Excel Tips post. I’ll be adding new tips every couple of days until total count reaches 100 tips....
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...
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...
