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: [ Ссылка ]
You can download the example files here: [ Ссылка ]

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

свернуть