Author: melih

Ungroup Pivot Table Fields

Excel pivot table groups your dates into years, quarters and months by itself when you drag them into a rows or columns. Many users don’t...

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

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

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