Chandoo.org Podcast - Become Awesome in Data Analytics

CP054: Top 10 Pivot Table Tricks for YOU

Listen Later

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
          View all episodesView all episodes
          Download on the App Store
          Chandoo.org Podcast - Become Awesome in Data AnalyticsBy Chandoo
          • 4.6
          • 4.6
          • 4.6
          • 4.6
          • 4.6

          4.6

          56 ratings