How to Sort Data Horizontally in Excel
When you have your data arranged in a horizontal table instead of a vertical table, you may need to sort your data horizontally instead of...
Beat Excel! Get to next level in Excel!
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...
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...
