Confused by Pivot Tables in Excel? Watch this

Pivot Tables are the #1 analysis tool in the world, they represent how Excel users can master their field by being able to analyse data in a non-formula-based approach. Beginners often get confused because the way to build them is quite different from the rest of Excel, but I cover tips and the most common issues which beginners face, if in doubt just untick all your fields and go back to a bank Pivot Table. I also go through slicers, categories, dates, and aggregation types (% of totals, % month-on-month change). I finally cover some common issues and errors from updating to the wrong data input format etc. Links: Analyse data: https://youtu.be/zlrS6foEpXw Interactive dashboard in Excel: https://youtu.be/vYJ3XMwApGw Example files can be found here: www.xlconsulting-asia.com/youtube-files Chapters: 0:00 Start 0:57 Building a Pivot 2:04 2 dimensional Pivot 3:56 Biggest mistake from beginners 4:32 Pivot logic explained 6:59 Group dates in Pivots 8:38 Aggregations (SUM vs COUNT % total etc.) 11:25 Slicers & filters 13:54 Troubleshooting & good practice 17:25 Set up data for Pivots

Видео Confused by Pivot Tables in Excel? Watch this автора Бухгалтерский учет в Экселе: шаг за шагом