POWER USER PRO TIP
By default, PivotTables allow you to filter a given field based on either labels (text) or values, but not both. Want to show customers named “Tim” who purchased at least 10 bananas? Not with default filters, you won’t.
But not to worry, in this tip I’ll show you a simple way to activate multiple filters in your PivotTables, and use both text- and value-based criteria to explore your data.
COMMON USE CASES:
- Applying complex or custom PivotTable filters
- Filtering individual fields based on both text and value-based criteria
Interested in learning more?
Sign up for the Pro Tips for Power Users online course today to unlock exclusive project files and resources.
The full course includes PDF eBooks and Excel project files containing every demo & dataset covered in the course — ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick access.
It’s time to start working smarter, not harder. If you’re looking to maximize efficiency, supercharge productivity, and become an Excel POWER USER, this is the course for you.
Exclusive Offer – Full Course Access
Excel Pro Tips for Power Users
Full Price $199 Today’s Price 75% OFF!
75+ Excel tips to help you work smarter, boost productivity and become a certified power user. You’ll receive lifetime access to:
-
10+ hours of high-quality video content
-
Downloadable eBook & Excel project files (with solutions)
-
Course quizzes to test your knowledge
-
1-on-1 expert support
-
100% satisfaction guarantee (no questions asked)
