Excel Pivot Tables - Master Data Analysis in just 45 minutes

  Рет қаралды 31,641

Chandoo

Chandoo

Күн бұрын

Пікірлер: 67
@Kenosha01
@Kenosha01 Ай бұрын
Thank Chandoo. Better than learning from a book. BTW, Chandoo in my language means Sunshine
@maryumtufail7883
@maryumtufail7883 Ай бұрын
H1: analysis by customer ids, count of calls and sum of purchase amount and sort purchase amount in decending order, H2 : analysis by reps and count of their satisfaction rating and in all months
@isampellisandhyaranisandhy6214
@isampellisandhyaranisandhy6214 Ай бұрын
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
@polsecuya6296
@polsecuya6296 Ай бұрын
Thank you so much Mr. Chandoo, really love your videos. It super helps a lot to many❤️. More blessings to you.
@SRINIVASSATYANARAYANA-sf8qr
@SRINIVASSATYANARAYANA-sf8qr Ай бұрын
Thanks, Chandoo. You are an encyclopedia. Really love your teaching and I am a great fan of you
@hasnat2130
@hasnat2130 12 күн бұрын
Hi Chandoo, I am from Bangladesh, really loving your way of teaching,thank you.
@SkyDoesMinecraftX
@SkyDoesMinecraftX Ай бұрын
I love your way of teaching... contents are on the spot
@namrataghosh111
@namrataghosh111 Ай бұрын
You will always be the best teacher to teach Excel in the most easiest way. Thank you and Big Gratitude Sir.
@peacenluv2411
@peacenluv2411 Ай бұрын
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.❤
@Ismailfarhang
@Ismailfarhang 7 күн бұрын
H1: Analysis by customer IDs, count of call numbers and sum of purchase amount and sort purchase amount in descending order, H2 : Analysis by reps and count of their satisfaction rating and in all months with conditional formatting
@shahbajshekh4492
@shahbajshekh4492 Ай бұрын
Clear all the concepts of pivot table🤘
@SwarnaShanmugasundaram
@SwarnaShanmugasundaram Ай бұрын
Keep going .. Thank you chandoo
@chrism9037
@chrism9037 Ай бұрын
Another great video, thanks Chandoo!
@pgkannan
@pgkannan Ай бұрын
Thank you so much. It's completely all about pivotal.
@ravipunati4530
@ravipunati4530 Ай бұрын
Wow. Thank you chandoojee for your gr8 session of pivots. It's the one of the best videos. Tnq.
@aslamrangrej2714
@aslamrangrej2714 Ай бұрын
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.
@saurabh9416
@saurabh9416 Ай бұрын
Thank you 🙏 😊
@enioyabakin8862
@enioyabakin8862 Ай бұрын
Thanks for these.. This really help all the grammars have been hearing on how to use pivot table from others
@MR.JAM_687
@MR.JAM_687 Ай бұрын
Thank you so much ❤
@pavithrav945
@pavithrav945 Ай бұрын
Thankyou 😊
@lakshmanvajjakeshavula5380
@lakshmanvajjakeshavula5380 Ай бұрын
Thanks chandoo
@deepakmishra-ok1is
@deepakmishra-ok1is Ай бұрын
Excellent work..
@somrajthakur7417
@somrajthakur7417 Ай бұрын
Great knowlege 😊
@allaboutpriya1996
@allaboutpriya1996 Ай бұрын
Thanks Sir for sharing another helpful video 🙏🏻
@surauar-raudhahkempadangse5478
@surauar-raudhahkempadangse5478 Ай бұрын
Hi Chandoo, Thanks for this awesome video. Anyway, do you have a video about Power Pivot?
@sanketv1
@sanketv1 Ай бұрын
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.
@xtravengersgaming
@xtravengersgaming Ай бұрын
Brilliant video
@futuresolution4060
@futuresolution4060 Ай бұрын
Thank Sir
@dsync77
@dsync77 Ай бұрын
Good job
@gurmailsingh942
@gurmailsingh942 Ай бұрын
Thanks..
@dailyuploads3959
@dailyuploads3959 Ай бұрын
Thanks sir
@subratkumarpurohit1935
@subratkumarpurohit1935 Ай бұрын
awesome concept!!
@Kartikeya_music
@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
@pavithrav945
@pavithrav945 Ай бұрын
Can you please update when will power bi get started?
@devanandsingh3094
@devanandsingh3094 28 күн бұрын
Hi Chandoo Big Fan of your explanations but just a suggestion or or call it a gap, Finding the sample excel files are very difficult to find
@chandoo_
@chandoo_ 28 күн бұрын
Thanks for the suggestion. As this video is part of my course playlist, I have put a link to the course page where you can find all the downloads, rest of the lessons and relevant material. There is a table of contents on that page too. Please use it to learn better - chandoo.org/wp/free-data-analyst-course/
@michaelt312
@michaelt312 Ай бұрын
What software are you using for your mouse tracking and on screen marking?
@chandoo_
@chandoo_ Ай бұрын
I use Zoomit from sysinternals. You can download it form the Microsoft website for free.
@MilindPandit-y2z
@MilindPandit-y2z Ай бұрын
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
@malcolmvillanueva5689
@malcolmvillanueva5689 Ай бұрын
Is the grand total enough for sheet 8?
@murtaza7617
@murtaza7617 Ай бұрын
Post more on sql
@RaphaelNweke-g2v
@RaphaelNweke-g2v Ай бұрын
Hello, I can't quite get the formular for the financial year.
@muhammadimtiazimtiaz3210
@muhammadimtiazimtiaz3210 Ай бұрын
Great
@akhildharimisetty2767
@akhildharimisetty2767 19 күн бұрын
Data set for this?
@BhaskarReddy-bv3ls
@BhaskarReddy-bv3ls Ай бұрын
This is data analytics course video?
@chandoo_
@chandoo_ Ай бұрын
yes
@TapanSarker-k3k
@TapanSarker-k3k Ай бұрын
I am not getting the practice file.How can I get that.
@MustafMohamed-q4q
@MustafMohamed-q4q Ай бұрын
My dear teacher can you help me how to download tablue program
@Ajay-wu1jg
@Ajay-wu1jg Ай бұрын
Brō nāku data analytics mīda iṇṭresṭ undi. Ānlain insṭiṭyūṣan lō jāyin avvāli anukuṇṭunnānu ēdaitē ṭesṭō ceppaṇḍi plīj ?
@Ajay-wu1jg
@Ajay-wu1jg Ай бұрын
I am interested in data analytics. How to learn?
@oscarjacob9096
@oscarjacob9096 Ай бұрын
There are many scams running stay safe, best is get a free roadmap and learn from youtube, don't go for placement guarantee courses, they are scam
@talknow2859
@talknow2859 Ай бұрын
Just start here and now. This is GOLD🎉!
@suriyars5662
@suriyars5662 Ай бұрын
Hi Chandoo , I am observing video audio desync issue after 30 mins of the video
@chandoo_
@chandoo_ Ай бұрын
Thanks for letting me know. Due to a computer issue, I lost 13 seconds of audio (video was there) during the recording. We tried to cover it by adjusting the recording. The issue lasted for 2-3 minutes, but after that the video is in sync with audio.
@madhusekhar17
@madhusekhar17 Ай бұрын
how do i get the above excel files, can any one help me
@chandoo_
@chandoo_ Ай бұрын
Visit chandoo.org/wp/free-data-analyst-course and download the lesson files.
@rojalibiswal8975
@rojalibiswal8975 Ай бұрын
Please provide dataset
@chiragtyagi8366
@chiragtyagi8366 Ай бұрын
Where are the sample files used for this particular video?
@chandoo_
@chandoo_ Ай бұрын
Check the video description for the link. Or go here - chandoo.org/wp/free-data-analyst-course/
@suriyanarayananr9652
@suriyanarayananr9652 Ай бұрын
@psycho... maha Prabhu.. neega ingaium vanthuteengalaa.. video vs audio lag irukey.. namma CR Infotech web-ex recording maari.. 😅
@chandoo_
@chandoo_ Ай бұрын
There is a few seconds lag in the middle but it lasted no more than a minute and we were able to sync the audio up again. Happened due to a software glitch.
@ragulmarley4900
@ragulmarley4900 Ай бұрын
Next video when upload
@muhammadtasiu5533
@muhammadtasiu5533 Ай бұрын
Wow
@ashutoshgovind1877
@ashutoshgovind1877 Ай бұрын
Great informative vedio
@rishabhyadav3935
@rishabhyadav3935 Ай бұрын
In the marriage......Pivot chart seems to be husband. 😂😂 By the way great video.
@chandoo_
@chandoo_ Ай бұрын
😅
@required.
@required. Ай бұрын
C0010 is a time waster & R04 rep needs attention
Power Query - Beginner to PRO Masterclass in 30 minutes
35:17
This dad wins Halloween! 🎃💀
01:00
Justin Flom
Рет қаралды 63 МЛН
REAL MAN 🤣💪🏻
00:35
Kan Andrey
Рет қаралды 10 МЛН
Common Excel Pivot Table Features People Miss (and you?)
12:45
Leila Gharani
Рет қаралды 153 М.
Pandas Library Full Course in 3.5 hours | Data Analysis with Python
3:50:53
Coding News Today
Рет қаралды 1,4 М.
Pivot Table Excel | Step-by-Step Tutorial
8:36
Kevin Stratvert
Рет қаралды 39 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 299 М.
7 Advanced PivotTable Techniques That Feel Like Cheating
16:07
MyOnlineTrainingHub
Рет қаралды 75 М.
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 468 М.
10 Advanced XLOOKUP Tips & Tricks
21:04
Chandoo
Рет қаралды 34 М.
This dad wins Halloween! 🎃💀
01:00
Justin Flom
Рет қаралды 63 МЛН