Chandoo.org Podcast – Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel

starstarstarstarstar

Become Awesome in Excel by Chandoo.org – A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.

RSS Feed URL

Chandoo.org Podcast – Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel navigateright Episode

CP054: Top 10 Pivot Table Tricks for YOU

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


The post CP054: Top 10 Pivot Table Tricks for YOU appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.