KNOW the difference between AVERAGE // MEDIAN // QUARTILES - Easy explanation 👌

[@ryanyang2486]

Well explanind with homor. Thanks Chandoo. You are a good math teacher as well. Could you start anothere tutorial------- Statistics

[@sudipmitra9]

Yup!! Bill was there with us but left without paying for the drinks.

[@chandoo_]

That is why he is called Bill. Because he looks at the gate, when there is a bill. 🤣

[@devashishkutemate7316]

Sir, very I am very very depress, I want work online by using Excel work. I know work pickup from upwork, fiverr, Linkin, etc. But my way not clear sir, confusion lots for me,. Also In my computer excel (Office 2003) are installed 2003. Am I able to work or fullfil requirements for clients need. Suggest me sir. I orginal language is Marathi sir, Hope you shall understand me and my problem. Thank you sir.🥲🥲🥲

[@calisthenics_karnataka]

Hi Sir I'm your biggest fan from India and want to buy your course and want to be data analyst like you and I'm from commerce background advice me still I can learn data analyst without technical knowledge and advice me how I can buy in rupee

[@chandoo_]

You are welcome Mickael.

[@dcharles7]

Started work as an analyst myself and I use averages often. Thank you for showing me the downside and limitations of doing so.

[@chandoo_]

More power to you Dominic ⚡

[@fayyazahmad1794]

Hi I am very confused with my data. I have the same data(Pizza category, each pizza quantity, price) in two different sheets. in one sheet pizza with quantity & in other pizza with price but pizza name is shuffled. I want to match the pizza and their price. Any video

[@chandoo_]

Hi Fayyaz... You can use either lookups or Power Query to do this. See this video - kzbin.info/www/bejne/iqiakIyPhryrapo to understand the process.

[@MitchelDZ]

I enjoy the content. Perhaps a lavalier mic would be an amazing upgrade.

[@chandoo_]

Thanks for the suggestion. I am using Rode mic with the camera, but in this video as I move away from the camera when writing the sound was mixed. I will try with a lav mic next time.

[@Gopal_DekTej]

Hi Chandoo, I learned lot of things in excel by following you. I need one help, Everyday I have to add the data from excel into respective google sheets. Can you please help to automate this. Its save a lot time to me.

[@chandoo_]

Thanks for learning from me Gopal. I do not use GS much. So I don't know how to do the thing you mentioned. Please use other resources to figure it out.

[@surajvishwakarma9199]

Excellent explanation thank you.

[@muzniahamed5887]

How to incert new row or new column in power query

[@peterdallyn6440]

Hopeless at maths and statistics but your approach to teaching brings a lot of meaning and really good at getting complex concepts across 👍

[@chandoo_]

Thanks Peter. I hated learning Stats in college and skipped most classes. 20 years later, I feel more comfortable with it :)

[@kavyabb8454]

Percentile examples please

[@dineshchaudhari2294]

Hi Chandoo your are really blessed with Excellect teaching skills and amazing sense of humour... me who use to run away from statistics suddenly started having interest in it. Thank you.

[@FemiDanalyst]

Thank you chandoo. Every lesson from you is a treasure

[@chandoo_]

Glad to hear that

[@Chiragk23]

Hey, I think you did a paid power bi course live and recorded on Nov 6. Im wondering is it still available for purchase. I didn't have windows desktop to run power bi then so I couldn't attend live.

[@chandoo_]

Hi Chirag... sorry brother. I am not selling the recording alone. I plan to re-run the course in March. You can join then. Alternatively, you can also join the Power BI Course (pre-recorded) here - chandoo.org/wp/power-bi-course/

[@Chiragk23]

@@chandoo_ Alright, will join then. Thank you so much for the awesome content.

[@charlidavid5592]

Awsome Chandoo, I was waiting for it... 😊

[@chandoo_]

Hope you enjoyed it!

[@mickaell3451]

Very well explained, thank you Chandoo ;)

[@chrism9037]

This was great, thanks Chandoo!

[@chandoo_]

You are welcome Chris :)

[@gokulsumu4677]

Thanks so much sir 😊🔥ur awesome n ur making us awesome too..

[@senpai.5517]

Hi Chandoo, thanks for the easy/simple explanation. I learn something new with every video that you publish. Please keep them coming. 👏🙏

[@chandoo_]

You are welcome Senpai :)

[@TSSC]

An addition: AGGREGATE is another function that can be used to calculate average, mean, quartile, percentile and more.

[@chandoo_]

Agreethat.

[@Syed48]

People get so engrossed in your content your editing skills are always masked behind it😂 I love your content but i wish people also took time to acknowledge your editing skills more often. I’m taking the lead here..

[@chandoo_]

Thanks Syed for the love 😍 I enjoy video creation and editing process a lot. This is the first video I edited with Premiere pro. I am exicited to learn the software and eager to use it in other videos too.

[@gurupradeep9648]

Hi chandhu, What about Harmonic and Geometric mean.shall we consider using them this kind of situation?

[@chandoo_]

I have never used them after school (well, I did use them once to figure out average speed of a road trip - chandoo.org/wp/what-is-the-average-speed-of-this-road-trip-solution-discussion/)

[@michailmarkou1995]

Very informative!

[@chandoo_]

Glad you think so!

[@wilsonpaul2085]

Thanks Mr. Chandoo

[@chandoo_]

You are welcome Paul :)

[@bokambissalendoyechandrydo1568]

Thanks a lot very well explained 👏

[@kardiiobi321]

Please sir I am new to excel and power bi please I would love a video on all the formulas and the meaning and what problem is used for them

[@chandoo_]

Welcome to the journey Kardii. Please see this video to understand the important Excel functions. kzbin.info/www/bejne/fpixdKmaba6VicU

[@Bashir_Kano]

You have been really really helpful and resourceful to the YT Excel community. Pls my problem is I can't convert hours to days and have the remaining as hours instead of a percentage of the day. e.g, 26:00 hrs = 1 days 2 hours. How can I achieve that in excel? Thank you

[@chandoo_]

You can use a format code to do this. Select the cell with the data, go to format cells (CTRL 1) and select "Custom" format. type the code [d]:hh:mm:ss and you should see days and hours.

[@Bashir_Kano]

@@chandoo_ Very well. Thank you master. Do you have videos on format codes so that I can watch? And please how can I have access to your live presentation at the Excel Global Submit holding next year? Thanks

[@taizoondean689]

Very well explained sir thank You God Bless You

[@chandoo_]

You are welcome TD :)

[@atilolaabiodun3687]

Well explained Thanks 💪🏾

[@alfredtomiamubiaya3330]

Many thanks Chandoo always on point.

[@chandoo_]

Always

[@parusharamudugunaganti2658]

Great explanation Chandoo sir

[@chandoo_]

Thanks and welcome

[@arbazahmad7177]

Well explained. Thanks 😊

[@chandoo_]

You are welcome Arbaz.