Beat Excel! Get to next level in Excel!

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...

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....