17 Amazing Features of Excel Tables

Well, most of the time, any arrangement data is referred as a table in excel but they are not. You need to format your data as table on excel to get t...

Dynamic Pivot Table

Your pivot report not detecting new rows and columns automatically ? Want to make it dynamic? Don’t worry, after reading this article you’ll...

Excel GETPIVOTDATA Function

So, one day I was working on pivot report and I wanted to do some operation with pivot data. I started writing the formula and as I clicked on pivot...

Remove Data Validation Using Paste Special in Excel

In Excel, we can prevent user from entering their stuff in cell by using data validation. In this article, we will get rid of data validation list in ...

How to Compare Two Lists In Microsoft Excel

In this article, you will learn comparing two lists using Conditional Formatting. The common cities will get highlighted. We will use Conditional F...

Show Hide Field Header In Pivot Table in Excel 2016

In this article, we will learn how to show hide Field Header in pivot table in Excel 2016. For that first, we need to understand how the pivot tabl...

Pivot Table Report Grouping Date Field in Microsoft Excel 2010

To make use of grouping the date field by quarter in pivot table report, we can use a combination of MOD, CEILING & MONTH functions to get the out...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube