Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

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 […]

➲ Continue Reading

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. You will learn a superb trick to create some interactive […]

➲ Continue Reading

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, […]

➲ Continue Reading

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 […]

➲ Continue Reading