How to use Pivot Tables in Excel - A Step-by-step guide
291.1 هزار بار بازدید -
3 سال پیش
-
Just started your data analyst
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 - https://chandoo.org/wp/wp-content/upl...
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: https://chandoo.org/wp/wp-content/upl...
Final reports: https://chandoo.org/wp/wp-content/upl...
LEARN MORE on PIVOT TABLES: Videos & Articles
=========================================
Getting started with Pivot Tables - Article - https://chandoo.org/wp/excel-pivot-ta...
Advanced Pivot Tables - Video Playlist - Easily link Slicers to more than one ...
How to make pivot tables from LARGE DATASETS - How to make pivot tables from large d...
My favourite time saving Pivot Table tips - 6 Massively time saving Pivot Table t...
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 👉 https://chandoo.org/wp/excel-school-p...
Be sure to download sample dataset to practice the concepts.
Link - https://chandoo.org/wp/wp-content/upl...
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: https://chandoo.org/wp/wp-content/upl...
Final reports: https://chandoo.org/wp/wp-content/upl...
LEARN MORE on PIVOT TABLES: Videos & Articles
=========================================
Getting started with Pivot Tables - Article - https://chandoo.org/wp/excel-pivot-ta...
Advanced Pivot Tables - Video Playlist - Easily link Slicers to more than one ...
How to make pivot tables from LARGE DATASETS - How to make pivot tables from large d...
My favourite time saving Pivot Table tips - 6 Massively time saving Pivot Table t...
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 👉 https://chandoo.org/wp/excel-school-p...
3 سال پیش
در تاریخ 1400/02/27 منتشر شده
است.
291,199
بـار بازدید شده