I don't know how to thank you enough. When I started watching your videos years ago, I was completely new to the field of data analysis. Now, thanks to your valuable knowledge and insights, I have achieved so much. I truly appreciate all your help!
The way we got new features has changed the pace and amount of effort involved in learning and using it. With Power query user think doing the task with it. With Dynamic array almost all formula are now supported. LAMBDA functions. Regex, Python. Pivotby group by etc.
Chandooo Bhai, Growing up physically and excelly by seeing your vidoes... Getting maturity of excell only bcz of your videos. Thanks Chandoo bhai... Loved the way you explain from Basics to high levels skills. You are encyclopedia of Excel. Thanks again...❤❤
I came across your channel and you won't believe how happy I am. Finally finally I got what I was looking for. Thankyou so much for your wonderful videos.
I really get confused sometimes, how can a person be so knowledgeable? This video of his is worth a million bucks to me. I love you Chandu. Love to you from Bangladesh.❤😊✌
Thank you Sir,,I am on a career break since the past 1 year to take care of my family and have been upskilling myself in the meantime ..Your content is very valuable and helping me to build my resume to get back into the workforce .I have worked with both PBI and Excel dashboards as a Business Intelligence consultant in a MNC for the past 7 years and must say your content has made me realise there is so much more to learn and build excellency .I would appreciate if you could please make a video how to manage focus and improve personal productivity (any hacks from your personal experiences) as this is one area I am struggling with,Many thanks!
Currency convertor example is awesome. Spill array calculation is available in Office 2021 too. Thank you for making my life easier. I learnt Power Query from your videos. You are an awesome teacher 👌
The playlist is in the sequence. I don't want to add sequence to the title or thumbnail as these videos are designed to be consumed individually also (very little or no connection to prior video, other than data). With sequence numbers, the videos become less attractive in search and browse tabs of RUclips.
Hi chandoo sir. Thank you for this amazing playlist. My doubt is Can I use google spreadsheet instead of excel to learn data analysis. Are the concepts and formulas are same in both?
Thank you so so much Chandoo Sir, it was very useful, awesome and you made it very easy to understand the complexity to simplicity, also its very crisp and clear. Wonderful, Thank you once again for all your dedicated and sincere efforts, God bless you Sir.
Thanks for amazing video Chandoo!! please contiue this series and make sure to have indepth videos (like this only) and also mainly used for DA purpose. Thank you
Thank you for your video's they are very helpful. The sound did go in and out, so it was hard to hear at times, but it was still a great video. Upgrade the audio recording equipment and keep the video's coming. Thank you again
Unc Chandoo, for the array functionality in the older versions of Excel for the money converter, can't we first highlight the entire range D46:H51 first, just start typing the formula and use the old CTRL+ Shift+Enter after entering the formula ??
Thank you Sir Chandoo I have an issue: when I added the box and whisker only a single box plot appears. Regardless of selecting both salary and gender column. What could be the reason? And how can I address it? You’re amazing 🎉 Thanks for being consistent with this transformative channel ❤
sir , is Data analyst role will replace by AI in future , please answer this question , many video's and articles are saying that , I am starting my carrier now it is a right path to sustain as data analyst , please make a video on this or please reply
I am tamil students but I understand English okk ... So this class how many days this section and how to get certificate sir please reply me🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Sir, I would be very greatful if you give me a solution to count meals separately Breakfast, lunch, diner from one date to another for example Check in date 05-09-2024 LUNCH & Check out date 09-09-2024 DINER Formula should count meals like a person had 4nos breakfast (e.g. 6B,7B,8B,9B), 4nos Lunches & 5nos Diners Only meals count required
Sorry about the sound. I had the microphone placed differently for this video and only realized it after the recording. I did my best to improve the audio in post, but it is what it is. You can increase the volume and hopefully you will hear it good.
You can't get Excel for free. There are a few options to get it for low fees or use the online version (for free). See this video. ruclips.net/video/Rzm0_YzG5sM/видео.html
I don't know how to thank you enough. When I started watching your videos years ago, I was completely new to the field of data analysis. Now, thanks to your valuable knowledge and insights, I have achieved so much. I truly appreciate all your help!
Wow.. good to hear such success stories. More power to you ⚡
When Chatgpt suggests your channel for advanced topics you know you doing it right!
Great sir, Thank you so much
Thank you Chandoo, stay blessed with your loved ones.
Thanks Chandoo . You are always my go to person when it comes to anything to everything in Excel
The way we got new features has changed the pace and amount of effort involved in learning and using it. With Power query user think doing the task with it. With Dynamic array almost all formula are now supported. LAMBDA functions. Regex, Python. Pivotby group by etc.
Many many Thanks Chandoo, always stay blessed. Can't thank you enough.
Hello folks. Spillable formula works in MS2021 pro... Thanks again Chandoo!
Great to hear!
Chandooo Bhai, Growing up physically and excelly by seeing your vidoes... Getting maturity of excell only bcz of your videos. Thanks Chandoo bhai... Loved the way you explain from Basics to high levels skills. You are encyclopedia of Excel.
Thanks again...❤❤
I came across your channel and you won't believe how happy I am. Finally finally I got what I was looking for. Thankyou so much for your wonderful videos.
Super Knowledge worth it watching... Thank You Sir
Most awaited video chandoo.Thank u
Thank you, sir. Learning Excel has become much clearer thanks to your explanation.
Chandoo, it is an excellent learning and thank you for providing a free of cost. God Bless You
I really get confused sometimes, how can a person be so knowledgeable? This video of his is worth a million bucks to me. I love you Chandu. Love to you from Bangladesh.❤😊✌
Wow, thank you!
Thank you Sir,,I am on a career break since the past 1 year to take care of my family and have been upskilling myself in the meantime ..Your content is very valuable and helping me to build my resume to get back into the workforce .I have worked with both PBI and Excel dashboards as a Business Intelligence consultant in a MNC for the past 7 years and must say your content has made me realise there is so much more to learn and build excellency .I would appreciate if you could please make a video how to manage focus and improve personal productivity (any hacks from your personal experiences) as this is one area I am struggling with,Many thanks!
Currency convertor example is awesome. Spill array calculation is available in Office 2021 too. Thank you for making my life easier. I learnt Power Query from your videos. You are an awesome teacher 👌
Thank you So much. What a super explanation!!!!! Salute you🙏
Thanks a lot sir ..❤❤❤
Thanks for this course brother. You are true gem ❤
Its a Really Great Initiative , Keep it up chandu garu
Thanks for this amazing video
Glad it helped! 🙂
Awesome... 😘 beautifully explained...
Awesome Anna mutual fan of You and Subbarao
Chandoo garu chala thanks andi❤
Thankyou too😍
Thank youuuuuuuuuuuu ❤
Thanks brother...
Dear Sir, Seeing your work has made my heart happy! You have worked very hard. Will you also praise my work after seeing it?🙏
Thankyou sir. You are master and I think to the point. Please arrange or make a long video 3hrs for pivot table only . With example . Thankyou
Excellent job! I'd love to hear your thoughts on my work.👍
Thanks Chandoo!
Awesome, Thank you Chandoo!! One suggestion, If you add sequence numbering for classes, It makes easy for people who watch later
The playlist is in the sequence. I don't want to add sequence to the title or thumbnail as these videos are designed to be consumed individually also (very little or no connection to prior video, other than data). With sequence numbers, the videos become less attractive in search and browse tabs of RUclips.
Thank you Chandoo garu
Hi chandoo sir. Thank you for this amazing playlist. My doubt is Can I use google spreadsheet instead of excel to learn data analysis. Are the concepts and formulas are same in both?
Hello Sir, Kindly cover VBA and Macros for Data Analysis because now a days many companies are asking it.
i am really enjoying the series.
Thank you so so much Chandoo Sir, it was very useful, awesome and you made it very easy to understand the complexity to simplicity, also its very crisp and clear. Wonderful, Thank you once again for all your dedicated and sincere efforts, God bless you Sir.
You are most welcome
I must say the background music was also as good as your teaching in terms of concentrating more 😅.....
You are #AWESOME ....
@Chandoo Sir 🙏🏻🙇🏻♀️
Thank you chandoo anna😊
Yeahhh anna❤🎉
Thanks for amazing video Chandoo!! please contiue this series and make sure to have indepth videos (like this only) and also mainly used for DA purpose. Thank you
That's the plan!
Thank you for your video's they are very helpful.
The sound did go in and out, so it was hard to hear at times, but it was still a great video.
Upgrade the audio recording equipment and keep the video's coming. Thank you again
Have been following ur excel & power bi playlist & I have created 3 dashboards today. Plz guide about what projects to add in resume?
always you fan thanks
Hi Anna, How are you? your Explanation is very nice of all the things which is important. The backend music is good.
Thank you so much 🙂 I am doing Great brother.
Unc Chandoo, for the array functionality in the older versions of Excel for the money converter, can't we first highlight the entire range D46:H51 first, just start typing the formula and use the old CTRL+ Shift+Enter after entering the formula ??
You can use that. Or just drag (copy paste) the formulas over the range.
@@chandoo_
Thanks Unc
Sir is it compulsary to get aws or azure certifications to get a job
Mid X is median i think - not average. Good video though . Thank you
Please check again. The middle line represents the median (as each line is one quartile). The x would then be average.
Which screen recording app u using sir
I use Camtasia
Thank you Sir Chandoo
I have an issue: when I added the box and whisker only a single box plot appears. Regardless of selecting both salary and gender column. What could be the reason? And how can I address it?
You’re amazing 🎉
Thanks for being consistent with this transformative channel ❤
Follow these steps:
1) Select the gender column and then hold CTRL and select the salary column.
2) Go to Insert ribbon and add a box plot
@@chandoo_
Yeah I got it now.
Thank you Sir 🙏💯
sir , is Data analyst role will replace by AI in future , please answer this question , many video's and articles are saying that , I am starting my carrier now it is a right path to sustain as data analyst , please make a video on this or please reply
No
If tenure is 2 years, then both
Yes, exactly
Sir increase audio quality
hello sir how enable data type option in excel 2021
Hi sir in this vedio I am getting issue how can I approach u
unable to download the data you used in vdo
I am tamil students but I understand English okk ... So this class how many days this section and how to get certificate sir please reply me🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Sir, I have excel Work book Cotains four sheets. How Could i Paste as Value Each Sheet of Column E at once?
Did you figure out?
Can anybody tell me why my slicer is not working in the another sheet
Sir I want tobe became data analyst choose me right path bottem to top
Any update videos On your braces?
You are seeing my new look in this video. I got them off mid June. Very happy with the treatment and my new smile.
There are some issues with voice , check it please
My slicer is not getting pasted in another sheet😅
disturbance in sound
in last moment of video, my slicer is not working with box plot as you shown, i use excel in mac os, where i am going wrong?
I am not sure if there is a compatibility issue with Mac. Does the chart update if you manually filter the table?
Please check the audio anna. It's not consistent throughout, there are some dips where it's becoming difficult to hear.
Hi Chandoo -- your live audio is too low and not clear -- aren't you well ? -- hope you are doing good, mate!
Sir, I would be very greatful if you give me a solution to count meals separately Breakfast, lunch, diner from one date to another
for example
Check in date
05-09-2024 LUNCH &
Check out date 09-09-2024 DINER
Formula should count meals like a person had 4nos breakfast (e.g. 6B,7B,8B,9B), 4nos Lunches & 5nos Diners
Only meals count required
Check in 5-Sep 11:50
Check out 9-Sep 21:00
Break fast Time Lunch Time Dinner Time
8:00 12:00 21:40
5-Sep 0 1 1
6-Sep 1 1 1
7-Sep 1 1 1
8-Sep 1 1 1
9-Sep 1 1 0
4B 5L 4D
in the beginning, i thought i'm in Marvel Universe
First :-D
voice volume is fluctuating
Please remove background music as its disturb the concentration on the main topic.
Thanks
the sound of this video is so low quality, you should improve your voice quality.
Sorry about the sound. I had the microphone placed differently for this video and only realized it after the recording. I did my best to improve the audio in post, but it is what it is. You can increase the volume and hopefully you will hear it good.
It’s free, remember! Rather appreciate his effort and address your comments politely.
@@ETEXCEL i don’t mean to hard him. I am a big fan of him and i know a good friend always correct his friend fault to make him strong not to make fun.
Love the way chandoo sings excel , pretty clear
How to get Excel in free
Do you mean free Excel installation?
Do you mean free Excel installation?
@@ajayshivpuje3797 yes for me it's asking premium
You can't get Excel for free. There are a few options to get it for low fees or use the online version (for free). See this video. ruclips.net/video/Rzm0_YzG5sM/видео.html