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...
Author: melih
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...
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...
Change Sheet Shortcut
Here is a valuable shortcut for you. It is called Change Sheet. If you are already using Excel mostly without mouse, this shortcut will come...
Using Data Form
Excel has a pretty unknown tool for data input assistance named Data Form. Here is how to benefit from this tool…
Highlight Chart
Here is a Highlight Chart that allows highlighting certain data points by using on-chart controls. In this post, I will explain how to build one....
