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

Learn Excel Pivot Tables in 10 Minutes - A complete beginner's tutorial10:15

Download information and video details for Learn Excel Pivot Tables in 10 Minutes - A complete beginner's tutorial

Uploader:

Chandoo

Published at:

5/17/2021

Views:

375.9K

Description:

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