👉 Check out my complete Excel course - chandoo.org/wp/excel-school-program/
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
chandoo.org/wp/wp-content/uploads/2024/09/sample-data-pivots-blank.xlsx
Completed file + all other lessons of my free data analyst course
chandoo.org/wp/free-data-analyst-course/
⏱ 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 - chandoo.org/wp/excel-school-program/
Why I stopped using Pivots - youtu.be/SPFQX82X03Q (1.3 mn views)
Don't make these pivot table mistakes - youtu.be/6A3e3s9YBgo
Learn Pivot Tables in 10 minutes - youtu.be/aofsdpjvK7w
How to make pivot reports when you have too much data - youtu.be/u4aeZ4ukrqI
FREE Data Analyst Course (playlist) - youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO
~
#freedataanalystcourse #fdac #chandoo #excel #pivot
- Excel Pivot Tables - Master Data Analysis in just 45 minutes ( Download)
- Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1) ( Download)
- Master Excel Pivot Tables, Excel Slicers and Interactive Excel Dashboards - FULL COURSE! ( Download)
- Learn Microsoft Excel PivotTable in just 45 minutes and become a pro in 2024 (full video) ( Download)
- Pivot Table Pro in Microsoft Excel: Master Data Analysis | Beginner to Expert in 10 minutes ( Download)
- Advanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel Course ( Download)
- Master Excel Pivot Tables, Excel Slicers and Interactive Excel Dashboards - IN 1 HOUR! ( Download)
- ☑️ Top 25 Advanced Pivot Table Tips & Tricks For Microsoft Excel ( Download)
- Excel Pivot Tables ( Download)
- Office 2013 Class #42: Excel Basics 24: Pivot Tables for Data Analysis (21 Examples) ( Download)
- Excel Formulas and Functions | Full Course ( Download)
- Data Analysis with Excel ( Download)
- Excel Time-Savers - 5 Hidden Features for Busy People ( Download)
- Excel for Beginners - The Complete Course ( Download)
- 8 strategies I used to learn & master Excel in a short time ( Download)
