@laurak5196
I just want to once again thank you for your time and for this beautiful tutorial. It’s well planned and filled with so many great tips. Thank you, sir!
@la9753
Definitely a rich video for anybody starting out as or desiring to be a data analyst.However, I had to reduce the playback speed to 0.75 to catch up with following as he seems to be a fast talker and thus rushing the delivery. Other than this, i find it extremely insightful
@sona_shekhawat
For the challenge in sheet 7: I created three columns: Country, Sales Person, Sum by country Formulas: Country column-> "=SORT(UNIQUE(Data[Geography]))" Sum by country-> "=MAX(SUMIFS(Data[Amount],Data[Geography],F4,Data[Sales Person],UNIQUE(Data[Sales Person])))" Where F4:F9 is the range of the unique values of countries(Geography) Sales Person-> "=XLOOKUP(H4,SUMIFS(Data[Amount],Data[Geography],F4,Data[Sales Person],UNIQUE(Data[Sales Person])),UNIQUE(Data[Sales Person]))" Where H4:H9 is the range of the sum by country column
@magombedzeelizabeth7411
It was helpful however I found it a bit challenging using excel web. But everything is on point. Would appreciate if you will do a tutorial on excel web for some of us. Thanks ❤️
@ItsWithinYou
Chandoo, you have a unique teaching method and clarity of thought. I loved this video and many thanks for sharing it with everyone! May you get lots of success in your work !
@sunilsomanath3208
Excellent explanation and presentation, using very good example exercise
@tanmoyroy3595
Best ever tutorial. Thank you so much Sir for your efforts and sharing your knowledge with us in order to grow in our career. You are Great Sir
@adrienneparis4563
the video is clear and efficient , i learn so much. You' re the best and amazing teacher Thanks for sharing.
@commandofaku
33:14 =SMALL(array), ROWs(designate cell s for out put) --> enter {this only gave me the lowest and did not list the data admittedly...still improving}
@bhartityagi8183
OMG is this my diwali gift from u. Thnk u sir. I just saw the notification and without watching the video i m writing this. U made my day. I m under the weather today and is not able to study. But definitely going to watch it. Sir pls make a video on how to read formula and implement it. As a biggner and hv no technical background I sometimes stuck with understanding them specially nested one.
@ManuRaviMaya
Thank you Chandoo, for the dynamic country level sales by using three pivots i got the desired output with a single geography slicer
@allaboutpriya1996
Thank you @Chandoo 🙏🏻 For all your kind information
@danthewandererboy
Found this video by chance and it turns out to be helpful. I am doing my thesis for master's and this helped me a lot. I was doing everything by individual formulas though.
@ervikasagrawal06
chandoo- love u man... you are so good and great teacher.....before i did so many such cources but you brought a fresh interest...in excel learning
@virginianjerimwaura7611
Best video of the day. Thank you.
@rajvardhansinghpanwar3921
Please post a detailed video on finding and creating report of anamolies.
@andrewdove342
Thoroughly enjoyable
@alexxgalindo8557
Chandoo, you're amazing, thanks a lot for this
@adityamenon2968
Good stuff Chandu anna.
@chandoo_