Pivot Tables in Google Sheets. Novice to expert tips

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:    • Interactive dashboards in Google sheets  
You can download the example files here: https://www.xlconsulting-asia.com/you...

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