New to Data Analysis? Use Pivot Tables to get quick results // Getting Started 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 sample dataset to practice the concepts. Link - https://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: https://chandoo.org/wp/wp-content/uploads/2021/05/awesome-sales-analysis-blank.xlsx
Final reports: https://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 - https://chandoo.org/wp/excel-pivot-tables-tutorial/
Advanced Pivot Tables - Video Playlist - https://www.youtube.com/watch?v=0HU8Hej6ong&list=PLmejDGrsgFyBH0zkiwAXsDLMMyGEO2hsx
How to make pivot tables from LARGE DATASETS - https://youtu.be/u4aeZ4ukrqI
My favourite time saving Pivot Table tips - https://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 👉 https://chandoo.org/wp/excel-school-program/
Видео New to Data Analysis? Use Pivot Tables to get quick results // Getting Started Tutorial канала Chandoo
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/uploads/2021/05/awesome-sales-analysis-blank.xlsx
Final reports: https://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 - https://chandoo.org/wp/excel-pivot-tables-tutorial/
Advanced Pivot Tables - Video Playlist - https://www.youtube.com/watch?v=0HU8Hej6ong&list=PLmejDGrsgFyBH0zkiwAXsDLMMyGEO2hsx
How to make pivot tables from LARGE DATASETS - https://youtu.be/u4aeZ4ukrqI
My favourite time saving Pivot Table tips - https://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 👉 https://chandoo.org/wp/excel-school-program/
Видео New to Data Analysis? Use Pivot Tables to get quick results // Getting Started Tutorial канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Data cleaning in Excel - 10 tricks *PROs* use all the timeBeginner to Pro FREE Excel Data Analysis Course5 key skills you need to become a GREAT Data Analyst ~ Lessons from 15 years of analytics experienceThe *ONLY* 10 Excel keyboard shortcuts you need to masterMake an awesome Project Management Dashboard with Excel (Free download ~ Part 1)Advanced Pivot Table Techniques (to achieve more in Excel)How to use Excel Slicers like a PRO: Basics + 5 Advanced Tricks10 Advanced IF formulas every analyst should knowExcel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)I used these 8 tactics to learn & master Excel quickly5 *Advanced* lookup tricks that Data Analysts need to knowWant to learn VBA? Here is a simple but in-depth tutorial (you will make 2 useful apps by end)How to Make $99,000+ Per Year With FREE Google CertificationsVBA vs. Python - Which one should you learn first? // For data peopleExcel's INDEX + MATCH - How to use it // 7 real-world examples & tipsTop 30 *Advanced* Excel Tips to make you awesome ⚡💡The truth about Power BI (and how to learn it properly)10 awesome things you can do in Excel - WITHOUT any formulas or pivotsTalking to my wife about her Power BI analyst job (how it started, the hardest part, salary ...)Create a Pivot Table from Multiple Sheets in Excel | Comprehensive Tutorial!