Save Prompt Without Any Changes
Sometimes when you open an Excel file and then close it without making any changes on it. But to your surprise, Excel pops a dialog...
Beat Excel! Get to next level in Excel!
Insert Hyperlinks from Text (VBA)
When you need to insert a series of hyperlinks into an excel sheet from a list of links, this small macro named “insert hyperlinks from...
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...
Monthly Chart Template
You can distinguish weekends on this monthly chart template with ease. Here is a downloadable chart after a while. I hope you like it.
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...
Updating Single Column Formulas
While working in manual calculation mode, you may need to test your formulas occasionally. When this happens, updating single column formulas instead of whole worksheet...
