Excel Pivot Tables - Master Data Analysis in just 45 minutes
👉 Check out my complete Excel course - https://chandoo.org/wp/excel-school-p...
While Excel formulas are powerful, you also need to plan and think hard before writing them to solve business problems. This is why I love Pivot tables. They are really easy to make and provide the biggest bang for buck. We can use Pivots to analyze data and answer business questions effectively and elegantly in short amount of time.
In this lesson, learn how to:
◉ Create a pivot table from your data
◉ Using the fields panel to construct your "dream" pivot
◉ Work with report filters, top 10 filters and sort options
◉ Change calculation in the pivot
◉ Set up slicers to "interact" with pivot tables
◉ Create "groups" in pivots
◉ Make pivot charts to analyze trends
◉ Calculate Cumulative "running" totals in Pivots
◉ Use conditional formatting with Pivots
◉ Percentage analysis with Pivots
◉ Set up advanced pivot tables to solve business problems
📁 Sample files (blank and completed workbooks):
==========================================
Blank data file
https://chandoo.org/wp/wp-content/upl...
Completed file + all other lessons of my free data analyst course
https://chandoo.org/wp/free-data-anal...
⏱ Video Topics & Timestamps:
==========================
0:00 - Introduction to the data and 10 problems
0:51 - Total calls by customer pivot
5:16 - Customer Satisfaction pivot
7:34 - Top 10 customers with value filters
11:19 - Using Report Filters to see top 10 customers for a specific representative
12:45 - Slicers are better than Report Filters
15:01 - Call duration analysis (grouping in Pivots)
20:32 - Trend analysis with Pivots (using dates)
24:40 - Year to Date Totals (cumulative or running totals in Pivots)
27:50 - YTD totals with financial year start in July
31:43 - Which days are busiest (conditional formatting with Pivots)
36:12 - Link between call duration and satisfaction (2-way pivots)
44:49 - Should we hire extra stuff in any months?
47:25 - Home work problems to practice Pivot Tables
48:30 - Coming up next in the free data analysis course
👩💻 Learn more:
============
💥 Check out my advanced Excel course to up your skills - https://chandoo.org/wp/excel-school-p...
Why I stopped using Pivots - • I don't use PIVOT tables anymore... I... (1.3 mn views)
Don't make these pivot table mistakes - • DON'T Make These 5 Pivot Table Mistakes
Learn Pivot Tables in 10 minutes - • Learn Excel Pivot Tables in 10 Minute...
How to make pivot reports when you have too much data - • How to make pivot tables from large d...
FREE Data Analyst Course (playlist) - • FREE Data Analyst Course
~
#freedataanalystcourse #fdac #chandoo #excel #pivot
Watch video Excel Pivot Tables - Master Data Analysis in just 45 minutes online without registration, duration hours minute second in high quality. This video was added by user Chandoo 10 September 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 26,916 once and liked it 1 thousand people.