QuickBooks 30-day free trial + 30% off for 12 months:
[ Ссылка ]
(30% discount offer to expire 9/30/2021)
Basic Tutorial on Pivot Tables, Plus new features in 2016:
-Auto Detect Table Relationships
-Automatic Data Grouping
Topics contained in this video:
00:00:42 – What is a pivot table
00:01:42 – Basic pivot table functions
00:03:23 – Working with multiple tables and automatically detecting fields that has relationships from other tables (how it works example)
00:05:30 – Creating pivot table
00:06:07 – How to grab other tables (example step by step)
00:07:46 – Auto-detect relationships
00:08:54 – Automatic grouping of dates
by Hector Garcia, CPA
![](https://i.ytimg.com/vi/MhUgEW4SLPU/maxresdefault.jpg)