Category Archives for Pivot Tables

Apply Conditional Formatting to a Pivot Table

 You know that pivot table is one of the most important tools to analyze and summarize data. You can create instant reports using pivot tables. And to make it more appealing to your users, you can apply conditional formatting to a pivot table. Just look at below where I have applied conditional formatting in a pivot table to […]

How to Link/Connect a Single Slicer with Multiple Pivot Tables in Excel

Sometimes using more than one pivot table is a mess. But it’s not a mess if you connect all the pivot tables with a single slicer. So do you know how to link a slicer with multiple pivot tables?If you don’t know then follow this post and you will learn a superb trick to create some interactive […]

10 Useful Tips To Customize Your New Born Pivot Table In Excel

Most of us customize our pivot tables as per requirement. Whenever we create a new pivot table, some customization is always required. Some users add calculations, customize the layout, add a report filter, etc. There are lots of options in pivot tables to make best out of it. Today I’m going to discuss ten simple, […]

How To Insert Calculation In Pivot Table With Custom Field & Item

Using calculation in the pivot table is like a custom calculation which not exists in the source data but works like other fields. In simple words, these are the calculations within the pivot table. Excel gives us two options for calculation in a pivot table, one is calculated field & other is calculated item. In […]