Excel Pivot Tables - Master Data Analysis in just 45 minutes

  Рет қаралды 35,201

Chandoo

Chandoo

Күн бұрын

Пікірлер: 68
@Kenosha01
@Kenosha01 2 ай бұрын
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
@Ismailfarhang
@Ismailfarhang 25 күн бұрын
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
@namrataghosh111
@namrataghosh111 2 ай бұрын
You will always be the best teacher to teach Excel in the most easiest way. Thank you and Big Gratitude Sir.
@SRINIVASSATYANARAYANA-sf8qr
@SRINIVASSATYANARAYANA-sf8qr 2 ай бұрын
Thanks, Chandoo. You are an encyclopedia. Really love your teaching and I am a great fan of you
@isampellisandhyaranisandhy6214
@isampellisandhyaranisandhy6214 2 ай бұрын
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 2 ай бұрын
Thank you so much Mr. Chandoo, really love your videos. It super helps a lot to many❤️. More blessings to you.
@peacenluv2411
@peacenluv2411 2 ай бұрын
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.❤
@hasnat2130
@hasnat2130 Ай бұрын
Hi Chandoo, I am from Bangladesh, really loving your way of teaching,thank you.
@SkyDoesMinecraftX
@SkyDoesMinecraftX 2 ай бұрын
I love your way of teaching... contents are on the spot
@sanketv1
@sanketv1 2 ай бұрын
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.
@enioyabakin8862
@enioyabakin8862 2 ай бұрын
Thanks for these.. This really help all the grammars have been hearing on how to use pivot table from others
@ravipunati4530
@ravipunati4530 2 ай бұрын
Wow. Thank you chandoojee for your gr8 session of pivots. It's the one of the best videos. Tnq.
@shahbajshekh4492
@shahbajshekh4492 2 ай бұрын
Clear all the concepts of pivot table🤘
@aslamrangrej2714
@aslamrangrej2714 2 ай бұрын
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.
@pgkannan
@pgkannan 2 ай бұрын
Thank you so much. It's completely all about pivotal.
@chrism9037
@chrism9037 2 ай бұрын
Another great video, thanks Chandoo!
@SwarnaShanmugasundaram
@SwarnaShanmugasundaram 2 ай бұрын
Keep going .. Thank you chandoo
@Kartikeya_music
@Kartikeya_music 2 ай бұрын
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
@allaboutpriya1996
@allaboutpriya1996 2 ай бұрын
Thanks Sir for sharing another helpful video 🙏🏻
@MR.JAM_687
@MR.JAM_687 2 ай бұрын
Thank you so much ❤
@deepakmishra-ok1is
@deepakmishra-ok1is 2 ай бұрын
Excellent work..
@saurabh9416
@saurabh9416 2 ай бұрын
Thank you 🙏 😊
@somrajthakur7417
@somrajthakur7417 2 ай бұрын
Great knowlege 😊
@lakshmanvajjakeshavula5380
@lakshmanvajjakeshavula5380 2 ай бұрын
Thanks chandoo
@subratkumarpurohit1935
@subratkumarpurohit1935 2 ай бұрын
awesome concept!!
@pavithrav945
@pavithrav945 2 ай бұрын
Thankyou 😊
@dsync77
@dsync77 2 ай бұрын
Good job
@futuresolution4060
@futuresolution4060 2 ай бұрын
Thank Sir
@surauar-raudhahkempadangse5478
@surauar-raudhahkempadangse5478 2 ай бұрын
Hi Chandoo, Thanks for this awesome video. Anyway, do you have a video about Power Pivot?
@dailyuploads3959
@dailyuploads3959 2 ай бұрын
Thanks sir
@gurmailsingh942
@gurmailsingh942 2 ай бұрын
Thanks..
@muhammadimtiazimtiaz3210
@muhammadimtiazimtiaz3210 2 ай бұрын
Great
@murtaza7617
@murtaza7617 2 ай бұрын
Post more on sql
@devanandsingh3094
@devanandsingh3094 Ай бұрын
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_ Ай бұрын
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/
@ashutoshgovind1877
@ashutoshgovind1877 2 ай бұрын
Great informative vedio
@pavithrav945
@pavithrav945 2 ай бұрын
Can you please update when will power bi get started?
@MilindPandit-y2z
@MilindPandit-y2z 2 ай бұрын
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
@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.
@rishabhyadav3935
@rishabhyadav3935 2 ай бұрын
In the marriage......Pivot chart seems to be husband. 😂😂 By the way great video.
@chandoo_
@chandoo_ 2 ай бұрын
😅
@RaphaelNweke-g2v
@RaphaelNweke-g2v 2 ай бұрын
Hello, I can't quite get the formular for the financial year.
@muhammadtasiu5533
@muhammadtasiu5533 2 ай бұрын
Wow
@xtravengersgaming
@xtravengersgaming 2 ай бұрын
Brilliant video
@malcolmvillanueva5689
@malcolmvillanueva5689 2 ай бұрын
Is the grand total enough for sheet 8?
@BhaskarReddy-bv3ls
@BhaskarReddy-bv3ls 2 ай бұрын
This is data analytics course video?
@chandoo_
@chandoo_ 2 ай бұрын
yes
@akhildharimisetty2767
@akhildharimisetty2767 Ай бұрын
Data set for this?
@michaelt312
@michaelt312 2 ай бұрын
What software are you using for your mouse tracking and on screen marking?
@chandoo_
@chandoo_ 2 ай бұрын
I use Zoomit from sysinternals. You can download it form the Microsoft website for free.
@TapanSarker-k3k
@TapanSarker-k3k 2 ай бұрын
I am not getting the practice file.How can I get that.
@rojalibiswal8975
@rojalibiswal8975 2 ай бұрын
Please provide dataset
@MustafMohamed-q4q
@MustafMohamed-q4q 2 ай бұрын
My dear teacher can you help me how to download tablue program
@Ajay-wu1jg
@Ajay-wu1jg 2 ай бұрын
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 ?
@ragulmarley4900
@ragulmarley4900 2 ай бұрын
Next video when upload
@Ajay-wu1jg
@Ajay-wu1jg 2 ай бұрын
I am interested in data analytics. How to learn?
@oscarjacob9096
@oscarjacob9096 2 ай бұрын
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 2 ай бұрын
Just start here and now. This is GOLD🎉!
@suriyars5662
@suriyars5662 2 ай бұрын
Hi Chandoo , I am observing video audio desync issue after 30 mins of the video
@chandoo_
@chandoo_ 2 ай бұрын
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.
@chiragtyagi8366
@chiragtyagi8366 2 ай бұрын
Where are the sample files used for this particular video?
@chandoo_
@chandoo_ 2 ай бұрын
Check the video description for the link. Or go here - chandoo.org/wp/free-data-analyst-course/
@madhusekhar17
@madhusekhar17 2 ай бұрын
how do i get the above excel files, can any one help me
@chandoo_
@chandoo_ 2 ай бұрын
Visit chandoo.org/wp/free-data-analyst-course and download the lesson files.
@required.
@required. 2 ай бұрын
C0010 is a time waster & R04 rep needs attention
@subhanahmad4808
@subhanahmad4808 2 күн бұрын
How to solve the first question?
Learn Power Query & Automate Boring Data Tasks in 15 Minutes!
18:45
7 Advanced PivotTable Techniques That Feel Like Cheating
16:07
MyOnlineTrainingHub
Рет қаралды 85 М.
ТЫ В ДЕТСТВЕ КОГДА ВЫПАЛ ЗУБ😂#shorts
00:59
BATEK_OFFICIAL
Рет қаралды 4,6 МЛН
Thank you Santa
00:13
Nadir Show
Рет қаралды 29 МЛН
Увеличили моцареллу для @Lorenzo.bagnati
00:48
Кушать Хочу
Рет қаралды 8 МЛН
Best Excel Formulas in an hour - Beginner to PRO Masterclass
1:09:40
Common Excel Pivot Table Features People Miss (and you?)
12:45
Leila Gharani
Рет қаралды 159 М.
6 COOLEST  Excel formulas in 2024
7:57
FM Lifestyle
Рет қаралды 10 М.
The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS)
10:29
MyOnlineTrainingHub
Рет қаралды 94 М.
50 things you didn't know Excel can DO 💡
30:03
Chandoo
Рет қаралды 281 М.
Pivot Table Design Tricks
28:04
Goodly
Рет қаралды 23 М.
Master Pivot Tables in 10 Minutes (Using Real Examples)
11:33
Kenji Explains
Рет қаралды 470 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 322 М.