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.
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
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.
@@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
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.
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.
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.
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/
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..
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.
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
Hi Fayyaz... You can use either lookups or Power Query to do this. See this video - ruclips.net/video/Tw7_YYQWx48/видео.html to understand the process.
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.
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/)
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.🥲🥲🥲
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
![NLE Choppa - Or What ft. 41 (Orchestra Mix) [Official Music Video]](http://i.ytimg.com/vi/biOFASEgSOM/mqdefault.jpg)
Well explanind with homor. Thanks Chandoo. You are a good math teacher as well. Could you start anothere tutorial------- Statistics
Started work as an analyst myself and I use averages often. Thank you for showing me the downside and limitations of doing so.
More power to you Dominic ⚡
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.
Hopeless at maths and statistics but your approach to teaching brings a lot of meaning and really good at getting complex concepts across 👍
Thanks Peter. I hated learning Stats in college and skipped most classes. 20 years later, I feel more comfortable with it :)
Yup!! Bill was there with us but left without paying for the drinks.
That is why he is called Bill. Because he looks at the gate, when there is a bill. 🤣
Awsome Chandoo, I was waiting for it... 😊
Hope you enjoyed it!
Excellent explanation thank you.
Thank you chandoo. Every lesson from you is a treasure
Glad to hear that
Hi Chandoo, thanks for the easy/simple explanation. I learn something new with every video that you publish. Please keep them coming. 👏🙏
You are welcome Senpai :)
Great explanation Chandoo sir
Thanks and welcome
This was great, thanks Chandoo!
You are welcome Chris :)
Very well explained sir thank You God Bless You
You are welcome TD :)
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
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.
@@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
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.
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.
Very well explained, thank you Chandoo ;)
Thanks Mr. Chandoo
You are welcome Paul :)
Thanks a lot very well explained 👏
Very informative!
Glad you think so!
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
Welcome to the journey Kardii.
Please see this video to understand the important Excel functions. ruclips.net/video/HgNCvd8IbSc/видео.html
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.
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/
@@chandoo_ Alright, will join then. Thank you so much for the awesome content.
Well explained
Thanks 💪🏾
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..
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.
Thanks so much sir 😊🔥ur awesome n ur making us awesome too..
How to incert new row or new column in power query
Well explained. Thanks 😊
You are welcome Arbaz.
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
Hi Fayyaz... You can use either lookups or Power Query to do this. See this video - ruclips.net/video/Tw7_YYQWx48/видео.html to understand the process.
Many thanks Chandoo always on point.
Always
An addition: AGGREGATE is another function that can be used to calculate average, mean, quartile, percentile and more.
Agreethat.
I enjoy the content. Perhaps a lavalier mic would be an amazing upgrade.
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.
Hi chandhu,
What about Harmonic and Geometric mean.shall we consider using them this kind of situation?
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/)
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.🥲🥲🥲
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
You are welcome Mickael.
Percentile examples please