Excel Trim Function Doesn’t Work
On many occasions, Excel trim function doesn’t work when trying to trim numbers pasted into Excel. It can be very frustrating to manually delete all...
Author: melih
Pivot Table Field Name Is Not Valid
If you are receiving the message “ Pivot table field name is not valid ” when you are trying to create a pivot table, that...
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...
Exclude Values in Sumif
Have you ever needed to exclude values in sumif function? This article will show you how to do it.
