Pivot tables are a brilliant way to aggregate by category without using formulas. In this video I showcase everything that Pivot tables can currently do. I showcase how beginners can create their first ever Pivot, how to transition from Excel and advanced tips for slicers, filters, sorting, COUNTUNIQUE etc.
Interactive dashboards in Google Sheets: https://youtu.be/8owuRQcSHH8
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/socials.html
00:00 Introduction
00:52 Creating Pivots
02:54 Which fields go where to avoid pitfalls
04:08 Working with dates
04:34 COUNTUNIQUE, AVERAGE, % total
05:47 Show values in rows
06:00 Double click breakdown
07:20 Filters & slicers