Learn Excel Pivot Tables in 10 Minutes - A complete beginner's tutorial

Опис:

Just started your data analyst career? Pivot Tables make your life easy. In this short but PACKED video, let me show you how to make 8 everyday reports using Pivot Tables in Excel. Be sure to download the sample dataset to practice the concepts. 0:00 - Introduction 1:24 - Making your first pivot table 2:33 - Total Sales by Sales Person - Report 1 3:40 - Sales by Person & Geography - Report 2 4:34 - Sales by Person with Geography Filter - Report 3 5:04 - Top 10 Products with Sales - Value Filter - Report 4 6:04 - Interactive Reports with Pivots - Report 5 7:00 - Pivot Charts 7:30 - Interactive Pivot Charts 8:24 - Report 8 - Sales as value & Percentages with bars 9:15 - Refreshing when you have new data 9:49 - What's next? - Advanced Pivot Tables