Show Notes
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 podcast
Comprehensive 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
What are your favorite Pivot Table tricks?
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.
More from Chandoo.org Podcast - Become Awesome in Data Analytics
Bill Jelen is one of my most favorite people on earth. That is why I wanted to have him as my first guest when I restarted the podcast. Even though I recorded this few weeks ago, only now I got around to publishing it. Please enjoy the conversation with Bill.
On the left side, we have a veteran warrior with 37 years of data battle scars and redundant six pack. They call him SQL.
Power BI is one of the best data analytics platform in the world. But it is not all roses and honey. There are some ugly parts to this amazing software. In this podcast episode, let me share 4 of my frustrations with the software / platform.
So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job.
Ladies & gentlemen… I have an exciting announcement. I am relaunching my podcast!!!