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 sample dataset to practice the concepts.
Link - chandoo.org/wp/wp-content/uploads/2021/05/awesome-sales-analysis-final.xlsx
In this video:
==========
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
Sample Data & 8 Reports:
=====================
Blank data file: chandoo.org/wp/wp-content/uploads/2021/05/awesome-sales-analysis-blank.xlsx
Final reports: chandoo.org/wp/wp-content/uploads/2021/05/awesome-sales-analysis-final.xlsx
LEARN MORE on PIVOT TABLES: Videos & Articles
=========================================
Getting started with Pivot Tables - Article - chandoo.org/wp/excel-pivot-tables-tutorial/
Advanced Pivot Tables - Video Playlist - youtube.com/watch?v=0HU8Hej6ong&list=PLmejDGrsgFyBH0zkiwAXsDLMMyGEO2hsx
How to make pivot tables from LARGE DATASETS - youtu.be/u4aeZ4ukrqI
My favourite time saving Pivot Table tips - youtu.be/YK4IDGz46bc
COMPLETE DATA ANALYSIS COURSE
===============================
If you want a complete hands-on course to master DATA ANALYSIS with EXCEL, check out my Excel School Program. To date, more than 10,000 people around the world have gone thru this course and became AWESOME at their work.
Go here 👉 chandoo.org/wp/excel-school-program/
- Learn Excel Pivot Tables in 10 Minutes - A complete beginner's tutorial ( Download)
- Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!) ( Download)
- Master Pivot Tables in 10 Minutes (Using Real Examples) ( Download)
- Pivot Table Excel Tutorial ( Download)
- Learn Pivot Tables in under 10 Minutes 😲 (Microsoft Excel) ( Download)
- Excel PivotTables for Beginners (2024) ( Download)
- Excel Pivot Table Tutorial for Beginners ( Download)
- Learn Pivot Tables in 6 Minutes (Microsoft Excel) ( Download)
- How to Create Pivot Table in Excel ( Download)
- Learn Excel Pivot Tables in 6 Minutes! [BEGINNER TUTORIAL!] ( Download)
- Pivot Tables in Excel | Excel Tutorials for Beginners ( Download)
- Excel Pivot Tables For Beginners - Complete Course ( Download)
- Excel Tutorial for Beginners ( Download)
- Learn Pivot Table in 10 minutes ⏰⏰ ( Download)
- Learn the Basics of Pivot Tables in 10 Minutes! ( Download)
