@lisalittle7367
Thanks! You have helped me take my new position from analog to digital!
@rolisingh2597
Your videos gave me direction and clarity about what I wanted to work for in life. You've no idea but you're a lifesaver, truly an angel to me. I hope you read this and this brings a bright smile to your face as you have brought to mine.💖
@chuckt8246
I've been using Excel for...ages...and I can't tell you how many times I've said "I didn't know you could do that" in this tutorial. Great work!
@mariaakpoduado
This is one of the best data analysis tutorials I've ever watched. So easy to follow. You are a great tutor, Chandoo
@nabeelahmed4220
Lots of love My grandpa used to learn from your blogs and videos, Now I'm learning from you. Good bless you sir.
@Kingco245
A good teacher is known by his ability to explain complex concepts in simple language. I believe in my heart that you’re indirectly putting food on many people’s tables by making your tutorials easy to follow, and by extension less frustrating. Thanks, Chandoo. You are a star. I'm not familiar with why and how you generated the KPIs(not sure this is the right word)used in the video. I'm a complete beginner in the world of analysis. Could you recommend a beginner-friendly course that would help me grasp the underlying concepts of Data Analysis, first; then, how to analyze data with Excel? Thanks.
@xplosionbox
you are "Excel Superstar" This is awesome. Thanks for being generous enough to share your knowledge.
@manjunathnaganna9970
Hi Chandoo sir, it's simply a superb video, and the way you explain the concepts is very much understandable to everyone. Your videos are made me learn more concepts. I have taken ur challenge to find the best salesperson by country using formulas and this is the way I did, Step1, I have taken the distinct of salesperson based on every geography and created a separate table like Geography, Salesperson and Amount. Step 2, I have summed up the amount of each salesperson to their every Geography location using sumifs function. Step 3, Taken the distinct of Gegrophy location and created table like Geography, Salesperson and Amount and find out the top 1 amount based on Geography using max and if condition and using the index, match, max and if condition findout the salesperson.
@gorihajirabee123
NAMASTE CHANDOO SIR🙏. I HAVE COMPLETED YOUR EXCEL DATA ANALYSIS COURSE. THANK YOU VERYMUCH.I HAVE WORKED AS A GOVT HIGH SCHOOL MATH TEACHER AND THEN AS A HEADMATER FOR 24 YEARS AND NOW GOING TO TAKE VRS.I'M PLANNING TO LEARN SOME SOFT SKILLS AS IT WAS MY DREAM TO BECOME A SOFTWARE.I WAS ADVISED BY SOMEONE TO GO FOR "SAP".I'M LEARNING EXCEL NOW. YOU ARE VERY DEDICATED.THANK YOU ONCE AGAIN FOR HELPING ME UNDERSTAND EXCEL BETTER🙏
@saswatakundu1284
Hello Sir, I took the challenge and tried to solve it using formula. I did the following steps: 1. I extracted a unique list of sale persons in a column and a unique list of countries in a row. 2. Then I calculated the sum of sales for each country by every sales person using sumifs function. In this way, i got a table of values. 3. Finally, for each country, I got the sales person generating the maximum sales by using xlookup function ( in which I nested the max function ).
@Optimus9617
It is the most detailed, clear and inspiring review of all the most important and useful functions and tools in Excel I've ever seen. Thanks a lot.
@tariqmahmood9278
Respected Sir Chandoo, love your method and respect your mentoring. I got a lot that could not be achieved yet. I will continue and do a lot like my Sir "Chandoo".
@Nicolaslazar
Systematic and clear like always. Thank you Chandoo. This video is my new Data Analysis Bible.
@shivsharma9153
at 3:30, sir i have first used that "LARGE" function to find the first highest value in the amount section, then I applied v-lookup formula to find the name of sales person that correspond with that amount, the answer was - gigi which had the highest amount score of 16,184
@anuragkumargupta8313
Hi Chandoo, Just did the analysis by myself. It was really helpful. USing your tutorial, I am able to say that my excel skills is good. I just need to understand business terms and metrics so that I can start to understand what data should I fetch from the original dataset.
@afolabigold1363
I took the challenge of the Dynamic Country-Level Sales Report. In my case, I assigned a target value to each country and used the IF statement to measure whether the selected country met the target or not and I also integrated it with conditional formatting to show Green when target is met and Red when is met.
@siddhu.s5182
Hi Chandoo great content its really helpful CHALLENGE 7: Step 1 :Have a copy the Geography and sales person column then remove the duplicates. Step 2 :Make separate table for each Geography with sales person. Step 3 :Then use =sumifs(<table name>[Amount],<table name>[geography],Column of the geography to be filtered, <table name>[Sales person],Column of the Sales person to be filtered. Step 4 :Sort each table largest to smallest and filter with top 1 and bottom 1.
@shreyanshdangi4366
this is the first video and from today i am starting the data analytics
@christophernjenga6708
It's a pleasure to have a tutor like you chandoo. Your committed work has made it real for me. Congrats 👏
@chandoo_