CP054: Top 10 Pivot Table Tricks for YOU

from Chandoo.org Podcast - Become Awesome in Data Analytics

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.

Episode details come from the podcast's RSS feed.

Embed this episode

Attribution link and audio player

Ready to play

CP054: Top 10 Pivot Table Tricks for YOU

0:00 34:49

No transcript yet.

Requests help us decide what to transcribe next.

Share this episode

Similar podcasts

French Your Way Jessica: Native French teacher founder of French Your Way Boost your French listening skills and test your comprehension with this one of a kind series of podcasts. Get the chance to listen to a real conversation between native speakers talking at normal speed AND customise your learning experience through carefully designed sets of questions (2 levels of difficulty) available for download at www.frenchvoicespodcast.com. All interviews also come with the transcript. French teacher Jessica interviews native speakers of French from around the world who share a bit of their life and passion. Where else would you meet in one same place a French yoga teacher based in Melbourne, a soap manufacturer from Provence, or a couple cycling around the world?

Frequently asked questions

How long is this episode of Chandoo.org Podcast - Become Awesome in Data Analytics?

This episode is 34 minutes long.

When was this Chandoo.org Podcast - Become Awesome in Data Analytics episode published?

This episode was published on March 31, 2016.

Can I download this Chandoo.org Podcast - Become Awesome in Data Analytics episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.