Pivot Tables in Google Sheets. Novice to expert tips
HTML-код
- Опубликовано: 12 июл 2024
- 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...
You can download the example files here: 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 Авто/Мото