@chandoo_

GOT AN ERROR ⛔  "CAN'T CHANGE PART OF ARRAY" 
Here is a fix 👉 https://chandoo.org/wp/errors-with-data-analysis-course/

@lisalittle7367

Thanks!  You have helped me take my new position from analog to digital!

@nabeelahmed4220

Lots of love 

My grandpa used to learn from your blogs and videos,

Now I'm learning from you.

Good bless you sir.

@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.💖

@mariaakpoduado

This is one of the best data analysis tutorials I've ever watched. So easy to follow. You are a great tutor, Chandoo

@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!

@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.

@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🙏

@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.

@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.

@xplosionbox

you are "Excel Superstar" This is awesome. Thanks for being generous enough to share your knowledge.

@christophernjenga6708

It's a pleasure to have a tutor like you chandoo. Your committed work has made it real for me. Congrats 👏

@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.

@Nicolaslazar

Systematic and  clear like always. Thank you Chandoo. This video is my new Data Analysis Bible.

@TanmoyTheDeadBoy

Thank you so much sir. I took crazy amount of time on this video due to my laziness(kept pausing and continuing for 3 weeks) But I've learned a lot. Idk if these will be sufficient to start a job But It increased my confidence. I'll keep watching your other videos and practicing (already watched many during pausing this one). Keep up the good work! God Bless you!

@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!

@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.

@nikitasinha8181

Thank you so much for making me feel like a data scientist within these 49 minutes sir

@BlizzyAcademy

I thought I am a guru in data analysis with excel, until I came across your channel. 
Thanks so much for adding more knowledge to my skills ..

@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".