CP054: Top 10 Pivot Table Tricks for YOU
Failed to add items
Sorry, we are unable to add the item because your shopping basket is already at capacity.
Add to cart failed.
Please try again later
Add to wishlist failed.
Please try again later
Remove from wishlist failed.
Please try again later
Follow podcast failed
Unfollow podcast failed
CP054: Top 10 Pivot Table Tricks for YOU
-
Narrated by:
-
Written by:
About this listen
In the 54th session of Chandoo.org podcast, let’s make you awesome in Pivot Tables.
What is in this session?In this podcast,
- Quick updates
- Top 10 pivot table tricks
- Adding same value field twice
- Tabular layouts
- GETPIVOTDATA & 2 bonus tricks
- Relationships & data model
- One slicer to rule them all
- Show only top x values
- Relative performance
- Show unique count
- Spruce up with conditional formats
- Not so ugly pivot charts
- Resources & Show notes for you
Listen to this session
Click here to download the MP3 file.
Resources for this podcastComprehensive guides on,
- Excel Pivot Tables intro – Podcast
- Excel Pivot Tables an introduction
- Excel Slicers what are they, how to use and advanced tips
- GETPIVOTDATA examples & usage
- Relationships & Data model example & downloadable workbook
- Power Pivot introduction and overview
Pivot Table Tips & Tricks
- Use report filters with VBA
- Structured references for Pivot Tables
- Group data in Pivot Tables
- Matching transactions using Pivot Tables
- Highlight quarters / weekends using styles in Pivot Reports
Now its your turn. Go ahead and share your favorite pivot table tricks in the comments box.
The post CP054: Top 10 Pivot Table Tricks for YOU appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
No reviews yet