FREE Data Analyst Course - Excel Pivot Tables - Master Data Analysis in just 45 minutes

👉 Check out my complete Excel course - https://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 https://chandoo.org/wp/wp-content/uploads/2024/09/sample-data-pivots-blank.xlsx Completed file + all other lessons of my free data analyst course https://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 - https://chandoo.org/wp/excel-school-program/ Why I stopped using Pivots - https://youtu.be/SPFQX82X03Q (1.3 mn views) Don't make these pivot table mistakes - https://youtu.be/6A3e3s9YBgo Learn Pivot Tables in 10 minutes - https://youtu.be/aofsdpjvK7w How to make pivot reports when you have too much data - https://youtu.be/u4aeZ4ukrqI FREE Data Analyst Course (playlist) - https://www.youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO ~ #freedataanalystcourse #fdac #chandoo #excel #pivot