Home>Blogs>Excel Tips and Tricks>Pivot Table Super Tips in Excel
Pivot Table Super Tips
Excel Tips and Tricks

Pivot Table Super Tips in Excel

In this article, we have used two excel super tips for pivot table. You can use this tips in your excel report wherein you use pivot table.

Below are the Pivot table super tips:

Add Search box in Excel Slicer:

In this pivot table tip we have created a Slicer of employee name which is connect with a pivot chart. Since we have a long list of employee so it is not easy to find the desired employee name in the slicer although they are in order. We have added a search box using pivot filter and fixed the slicer position.

Add Search box in Excel Slicer
Add Search box in Excel Slicer

Cross filter in two Pivot tables:

In the second pivot table super tip we have established a cross filter feature between two pivot tables. We have created two slicers for Market and Name and connected with both the pivot tables. We have make slicer hidden after connect with both tables. Now cross filter is established between both tables. You can use this tip for multiple pivot table also.

Cross filter in two Pivot tables
Cross filter in two Pivot tables

Watch the step by step video tutorial:

Click here to download this practice file.


Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!