Excel Pivot Tables - Master Data Analysis in just 45 minutes

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):
==========================================

Download the sample files and see all other lessons of my free data analyst course here-

⏱ 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:
============

~

#freedataanalystcourse #fdac #chandoo #excel #pivot

[Kenosha]

Thank Chandoo. Better than learning from a book. BTW, Chandoo in my language means Sunshine

[namrataghosh]

You will always be the best teacher to teach Excel in the most easiest way. Thank you and Big Gratitude Sir.

[peacenluv]

Brother thank you for the tip that you shared for no reason. But that's eye opening for many which you have already applied in your own life.- Life's sandwich method. I consider it as Golden words, the missing tasty bit.❤

[polsecuya]

Thank you so much Mr. Chandoo, really love your videos. It super helps a lot to many❤️. More blessings to you.

[SkyDoesMinecraftX]

I love your way of teaching... contents are on the spot

[SRINIVASSATYANARAYANA-sfqr]

Thanks, Chandoo. You are an encyclopedia. Really love your teaching and I am a great fan of you

[enioyabakin]

Thanks for these.. This really help all the grammars have been hearing on how to use pivot table from others

[isampellisandhyaranisandhy]

Stunning session, iam applying all these in my workarounds turnedup awesome in no time. I request please do more videos which make a even begginer user of excel to pro

[aslamrangrej]

First of all thanks for sharing contents relevant to ms excel and power bi and many more. The information and teaching are crisp and clear and very easy to understand.

But how about the idea like we as user will share our problems and you provide solutions?

New playlists like 'DON'T FEAR CHANDOO IS HERE' or something like that.

[sanketv]

important is to segregate calls that are (1) after sales service(2)New Sales(3)Marketing(features of product)(4)Complains--and on basis of that (a)sales-done on that call or (b)satisfaction-rate do counts.

[ravipunati]

Wow. Thank you chandoojee for your gr8 session of pivots. It's the one of the best videos. Tnq.

[pgkannan]

Thank you so much. It's completely all about pivotal.

[shahbajshekh]

Clear all the concepts of pivot table🤘

[Kartikeya_music]

Hi chandu I have finished MBA. But no working experience and
12 years gap. By watching ur videos.iam getting interest to do something. Will I get job. Suggest something plz

[allaboutpriya]

Thanks Sir for sharing another helpful video 🙏🏻

[surauar-raudhahkempadangse]

Hi Chandoo, Thanks for this awesome video. Anyway, do you have a video about Power Pivot?

[rishabhyadav]

In the chart seems to be husband. 😂😂
By the way great video.

[pavithrav]

Can you please update when will power bi get started?

[MilindPandit-yz]

Hello Chandoo I would like to know about building a pyramid chart based on pivot table in Excel. Please let me know in case we have any video related to that. Kindly help. Thanks

[RaphaelNweke-gv]

Hello, I can't quite get the formular for the financial year.