Evaluate Formula
Evaluate formula tool helps you figure out what is wrong with your formula. When you are confused about a formula in a worksheet, or is...
Beat Excel! Get to next level in Excel!
Add Chart Element
Many people does not know how to restore chart axis after accidentally delete it. In this article, I will show you how you can add...
Exclude Values in Sumif
Have you ever needed to exclude values in sumif function? This article will show you how to do it.
Excel Changes Last Digit to Zero
When you paste or type a number with a certain length into Excel, Excel changes last digit to zero. This happens when the number is...
Get Rid of GetPivotData
Almost everybody I know wants to get rid of GetPivotData function. Because when you are writing a formula and use a cell reference from a...
Don’t Count Columns for Vlookup
If you are using Vlookup function like everybody, you are likely to count columns while writing your formula. Don’t count columns for Vlookup anymore, because...
