Author: melih

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

Task Manager with Conditional Formatting

This task manager with conditional formatting will show you practical ways of using conditional formatting other than comparing numbers, etc. It is lightweight and very...