Our journey of data analysis with Excel in your hand. We saw you really active from past six months. Thank you for your dedication and hard work by heart. Please don't let down us with basic to advance of Excel or any shortcut tips. It is your responsibility to teach us everything in practical way. And again thank you very much.
Hi Anand... I have been making Excel + data content for over 12 years. There is all sorts of content on the channel and my website. I am not sure what you mean by "let us down". But my duty is to only make content that I enjoy creating. It is your responsibility to take it or leave it.
@@chandoo_ when he says don’t let us down.. he meant you shouldn’t let us down in creating these amazing contents. Time in time, we will run to your Chanel to drink from your fountain of knowledge. Thank you sir.
Chandoo - you are such a lovely man. Your videos are so clear and your teaching style is perfect! I, (a 75 year old grandmother retiree from the Uk), am teaching myself Excel and your videos are just superb!
Chandoo...Thank God I found you!!! This is the first time I actually understand Excel in the first 5 minutes and not tempted to watch Kdrama or Netflix. Anyone wanting to learn Excel quickly and not fall asleep..this guy your man ^^. Cheers mate! P.S, Do you have a video for those of us using Excel on Macs or just add in your vids short cuts for Macs if there are any. TQ
You are providing an excellent content Please Keep it up. I started learning Excel and Found it as a most powerful software which we used to ignore in our school days
Keeping your customer database clean is a lot like maintaining your car: if you don't do it regularly or with the right tools, it's just going to get worse. Luckily, there are some easy things you can do that will help you keep your customer data clean and organized. Aside from what Chandoo shared, we also suggest data appending for those who are not really techy. It serves as data enrichment and data cleansing tool. 🙏
OMG! Thank you very much for this. You were clear concise and it was easy to follow and understand I’m a save this video because I’m just now learning how to do this and you seem to be the best teacher so far. Thank you very much.
Chandoo your videos are wonderful! Especially the ones dealing with Power Query! You convinced me to really try to learn it, so I started using it recently and after a decade of working with Excel I feel like a fool for not doing so sooner! I deal with repeated, periodic reports and often the original source is so messy. I really appreciate that I can use PQ, set it up once, and NEVER have to manually clean up the same report for the thousandth time (literally)! Just the other day I took a daily file that is over 500MBs (don't ask!) and cut it down to under 50, and I'm not even done yet! Spectacular tool!
Wow.. .what a transformation (excuse the pun). Power Query is one of the first things I teach in my classes now a days. That alone can save a lot of downstream headaches.
@@chandoo_ Yes! I love the idea of "you gave me this, but what is relevant is this, and what is useful to my recipients is actually THIS, presented in this way" :)
Sir I have completed 71 years of my age. I am interested in learning something related to IT. Pl guide me what I should learn at the beginning. Thank you Kulkarni
Hi Shriram ji. First of all, it is inspiring to see your curiosity. I suggest learning either Python or VBA (if you use Excel alot). They are simple languages and you will certainly enjoy the challenge.
Hi sir, Actually I started my Career as a Research Analyst in 2011 then become Android Reverse Engineer (from 2014 - till 2019) Then Become Team Lead (till 2021 ) of Android Development , Then Become Business Analyst in IT company where I am handling same Mobile Team & Clients, NOW I Want to go with Data Analyst or Data Engineer JOB, Should I do this Please Give me some sight about this career change!! , Is it Fruitful ?
Sir these all Excel video is enough for data analytics sir please comment because I m very confuse because lot,s of video available in UA-cam please suggest is it enough for me kindly help 🙏
Hi sir, hope you are doing well! Sir i have a question. Currently I'm using MS Excel 2013. I want to practice power query. But i think it isn't built-in in my current version. I also tried to add in through Microsoft website but they have mentioned that they no longer provide Power query add- in to Ms excel 2010 or 2013 version. What i want from you is, Is there any other way that i could use power query? Plz do answer, its a Request.
Hi Chandoo, It was a great video as usual, thanks for teaching us in a simpler method where everyone can understand. I also found a mistake while cleaning the data by copy pasting the new values, so it shows the column gender where we changed null value to other but it shows zero in your video. Can you please look into the video again and explain why it is showing zero again instead of other. Thank you 😊
Hi, I guess you are talking about the part around 14:15. From the tab named "Table1" he switched back to the half clean data set, specifically the tab named "PQ Data" which was not affected by Power Query. It was left there unmodified, Power Query ran some processes and then created a new tab with the clean data. He just went back in the video to look at and therefore to show us the original, dirty data on PQ Data tab, that's why we still see NULLs there.
Thanks Chandoo. I try step by step, following your instruction. But when i try on power Querry, after split columns of ID. The number ID is not the same especially when the number begin with zero. The zero number is dissapear. Could you explain why? or there is a settings for those columns should be done first before split the columns.
Sir , My flash fill option isn't working . I have pressed ctrl+e , double clicked the value . but my flash fill isn't working ? I am using ms Excel 2016
Hi Chandoo, I just started seeing your videos and you are awesome. Thanks. What version is your excel please? Cause my doesn't have some of the function....
Who inspired you with that cleaner thing in the begining? Thought it was pretty novel.. good content as usual. was aware of most of it. Flash fill at times has been very handy & saved me from writing complex formulas.
Great content as always! Please sir,can you send us the link to download the Datasets you used. Without a similar or same Datasets,some practices on the useful tips won't do much.. Kindly help with the Datasets sir
Hello Dear, I never miss your any of the videos and you are absolutely amazing in this. Well, i have one query if you could guide me here, - Let's say i have load query from folder and i have multiple files available in that folder belongs to every month sales and let's say i have built one report and loaded in excel using power query. - Now after deleting a few files from folder, how could i keep old file data in excel where i have loaded the query besides that file get removed from folder? - as we know after refracing of query it would load fresh data only in model. basically, i want to preserve old data also in my excel where i have load the query. Thanking you in advance.
Start with this video ua-cam.com/video/F7aPazuS8QY/v-deo.html Then watch this: ua-cam.com/video/v2oNWja7M2E/v-deo.html If you want more step by step things, go for my course - chandoo.org/wp/excel-school-program/
I use a mix of explanation styles in my videos. But if you find them too fast, feel free to pause, rewind the video. Also refer to the example workbooks to understand the concept better.
Chando one small doubt, as flash fill dont till automatically, if we convert the range in to table (including flashfill coloumn), is it update automatically....
Hi thks u. i thing i got the point with how fast flash fill can help us filling the table but i did not got how iit usefull for the cleaning purpose. Help Thks
Hi, I have a question. The dates column is inconsistent. IN the video you used power query to clean the dates column. Can you please give me solution on how to do it without using powerquery please?
![19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]](http://i.ytimg.com/vi/Q8fghk3DQxY/mqdefault.jpg)
You are my plug when it comes to Excel....... Thanks💖
You're welcome 😊
hold on, imho, I believe some other words exist to replace you are my "plug" 🙃
Most sensible and Experienced data analyst ever seen in UA-cam
Your Excel capabilities are out of this world. I'm glued to this channel.
Our journey of data analysis with Excel in your hand.
We saw you really active from past six months.
Thank you for your dedication and hard work by heart.
Please don't let down us with basic to advance of Excel or any shortcut tips.
It is your responsibility to teach us everything in practical way.
And again thank you very much.
Hi Anand... I have been making Excel + data content for over 12 years. There is all sorts of content on the channel and my website. I am not sure what you mean by "let us down". But my duty is to only make content that I enjoy creating. It is your responsibility to take it or leave it.
@@chandoo_ when he says don’t let us down.. he meant you shouldn’t let us down in creating these amazing contents. Time in time, we will run to your Chanel to drink from your fountain of knowledge. Thank you sir.
Chandoo - you are such a lovely man. Your videos are so clear and your teaching style is perfect! I, (a 75 year old grandmother retiree from the Uk), am teaching myself Excel and your videos are just superb!
Your videos are like a gem to me every time I look to get updated about my skills. Awesome & amazing techniques. Thanks
Thanks Azhar... 😀
Chandoo...Thank God I found you!!! This is the first time I actually understand Excel in the first 5 minutes and not tempted to watch Kdrama or Netflix. Anyone wanting to learn Excel quickly and not fall asleep..this guy your man ^^. Cheers mate! P.S, Do you have a video for those of us using Excel on Macs or just add in your vids short cuts for Macs if there are any. TQ
Your starting with lines of S.T. Coleridge inspires me more for becoming DATA ANALYST!!! Thamnkss
You are providing an excellent content Please Keep it up. I started learning Excel and Found it as a most powerful software which we used to ignore in our school days
👏👏👏 That's awesome!!
Gem of a person..... so peaceful lectures...a big thank you
Keeping your customer database clean is a lot like maintaining your car: if you don't do it regularly or with the right tools, it's just going to get worse. Luckily, there are some easy things you can do that will help you keep your customer data clean and organized.
Aside from what Chandoo shared, we also suggest data appending for those who are not really techy. It serves as data enrichment and data cleansing tool. 🙏
Facts 🙂👏
OMG! Thank you very much for this. You were clear concise and it was easy to follow and understand I’m a save this video because I’m just now learning how to do this and you seem to be the best teacher so far. Thank you very much.
Chandoo your videos are wonderful! Especially the ones dealing with Power Query! You convinced me to really try to learn it, so I started using it recently and after a decade of working with Excel I feel like a fool for not doing so sooner! I deal with repeated, periodic reports and often the original source is so messy. I really appreciate that I can use PQ, set it up once, and NEVER have to manually clean up the same report for the thousandth time (literally)! Just the other day I took a daily file that is over 500MBs (don't ask!) and cut it down to under 50, and I'm not even done yet! Spectacular tool!
Wow.. .what a transformation (excuse the pun). Power Query is one of the first things I teach in my classes now a days. That alone can save a lot of downstream headaches.
@@chandoo_ Yes! I love the idea of "you gave me this, but what is relevant is this, and what is useful to my recipients is actually THIS, presented in this way" :)
It is always amazing to watch your videos… you give accurate, on point and no nonsense information… Thank you Chandoo sir
Loving the insightful way you explain the data cleaning feature.
Enjoying like a movie🤩🤩, impressed the way of your explanation. Thank you so much for sharing knowledge sir..🙏🙏
The best and easy to understand video on Excel.
You are awesome! Complex concepts explained with simplicity and loads of examples. Kudos.
You are amazing, Chandoo. Thanks for all your labour of love!
Thank you sir, you made my day with this video. I`m taking Google Data Analytics Professional certification
Thank you Chandoo! I hope there are more people like you.
Your video is very helpful bro.
I gained plenty of knowledge in Excel by your videos.
Glad to hear that Pro.. :)
Woah!! Thank you for this amazing video Chandoo. Never thought we can do so much in power query 🤩
All of that ... and MORE
PQ is the bees knees.
AMEN to that brother...
What a professional teaching style. Really useful tutorial. Subscribed.
I am really thankful to all the tutorials you have. It saves me a ton of time and work. Keep it up🤟🤟🤟
thanks you, i am poor and i had to practice with google sheets and i had to figure things out but it is equally fun to follow, thanks!
Sir
I have completed 71 years of my age. I am interested in learning something related to IT. Pl guide me what I should learn at the beginning.
Thank you
Kulkarni
Java programing.
Hi Shriram ji. First of all, it is inspiring to see your curiosity. I suggest learning either Python or VBA (if you use Excel alot). They are simple languages and you will certainly enjoy the challenge.
@@chandoo_ Sir
I believe I should learn Excel first, then think of other languages as suggested by you.
Thanks a lot.
Your content learnings is like a movie to watch😍😍 Interesting and addictive...
Thanks Chandoo Sir❤️
Glad to hear that
You´re the best my friend, when i going to wacth a video with a powerfull tips you´re first option for ever.
nice demonstration.....Respect from Pakistan
Wow! what a wonderful way to teach the data cleaning in Excel. Thank U Sir.
Explained Wonderfully! Thank you
Hi sir, Actually I started my Career as a Research Analyst in 2011 then become Android Reverse Engineer (from 2014 - till 2019) Then Become Team Lead (till 2021 ) of Android Development , Then Become Business Analyst in IT company where I am handling same Mobile Team & Clients, NOW I Want to go with Data Analyst or Data Engineer JOB, Should I do this Please Give me some sight about this career change!! , Is it Fruitful ?
This is very helpful. Those data cleaning techniques are extremely useful for our daily excel work.
Glad to hear that OT :)
This guy is really good! And his ability to create a video is getting better and better. I love it
Thank you Frank 😀
Chandoo bahe is a blessing
When ever i see excel tutorial videos, you always come to my mind. Did Chandoo taught this : oh yeah!!
Thanks Arun 😀
You guys are friends right?
your way of teaching is awsome sir, i like this this video
you are great in excel + your sense of humour amkes it more interesting....i call you BOSS of excel
This was another great video, thanks Chandoo!
Glad you enjoyed it Chris.
PS: I also want to thank you for watching and commenting on most videos 😍
@@chandoo_ sure, they’re great!
Sir these all Excel video is enough for data analytics sir please comment because I m very confuse because lot,s of video available in UA-cam please suggest is it enough for me kindly help 🙏
Hi sir, hope you are doing well!
Sir i have a question. Currently I'm using MS Excel 2013. I want to practice power query. But i think it isn't built-in in my current version. I also tried to add in through Microsoft website but they have mentioned that they no longer provide Power query add- in to Ms excel 2010 or 2013 version.
What i want from you is, Is there any other way that i could use power query?
Plz do answer, its a Request.
GOOOOOD stuff!
Wow Oz... Thank you 😎
Thanks, Chandooooo! You are brilliant
New learning again..... Thanks..
Hi Chandoo! Support in every videos you publish! Thanks for your tips! 🇮🇹
Thanks Giovanni...
I think power query is the best and quickest way to cleaning data....👌👌
Yes, true
finished watching nd practicing
My friend refeered me to you and i just subscribed without even watching a single video😱😀
Excellent tutorial.
This is just Fantastic learning material and that is for free for everyone 👍👍👌👌
Another amazing video! Explained so wonderfully well !!!! Thank you 🌸
You are so Awesome thanks Chandoo for imparting these tricks to us... More power to your channel...
this was beautiful. thanks
Thanq soo much Chandoo.. This video helps me a lot. Lots of love from INDIA 😍
You are welcome Bharat 😊
This is Awesome !! Its like a new updates installed onto myself.
Great to hear!
Thank you so much Chando.
Many many thanks to you for this nice video on data cleaning.
Hi Chandoo, It was a great video as usual, thanks for teaching us in a simpler method where everyone can understand. I also found a mistake while cleaning the data by copy pasting the new values, so it shows the column gender where we changed null value to other but it shows zero in your video. Can you please look into the video again and explain why it is showing zero again instead of other. Thank you 😊
Hi, I guess you are talking about the part around 14:15. From the tab named "Table1" he switched back to the half clean data set, specifically the tab named "PQ Data" which was not affected by Power Query. It was left there unmodified, Power Query ran some processes and then created a new tab with the clean data. He just went back in the video to look at and therefore to show us the original, dirty data on PQ Data tab, that's why we still see NULLs there.
thanks...once again maestro
My fears of excel is vanishing, Thanks to you!!!
Excellent!
Thanks Chandoo.
I try step by step, following your instruction. But when i try on power Querry, after split columns of ID. The number ID is not the same especially when the number begin with zero. The zero number is dissapear. Could you explain why? or there is a settings for those columns should be done first before split the columns.
What a quote on data ✌️✌️✌️
This was amazing!
Sir , My flash fill option isn't working . I have pressed ctrl+e , double clicked the value . but my flash fill isn't working ? I am using ms Excel 2016
Power Query is a must have/know tool.
Very helpful video 👍🏼👍🏼👈
Lajawaab 👌👌
Hi Chandoo, I just started seeing your videos and you are awesome. Thanks. What version is your excel please? Cause my doesn't have some of the function....
Thanks Latha and welcome to the channel.
I am using excel 365 in most of my videos (including this one).
@@chandoo_ omg.. You are so fast in replying... So you can be many people's online guru and savior. Thanks so much ya.....
Big thanks from 🙏☀️ 🇮🇳 jai hind
I love you man, you are amazing!
Awsome Chandoo..!
Wonderful!!! Thank you so much.
You are so welcome!
Thank you ❤️ this is helpful.
Thanks Chandoo!
Thank you for sharing nice vedio
Great one Chandoo! Always entertaining and useful. Thumbs up!!
Thanks Chandoo. Very Helpful videos especially me like people who started career in midlife
It's my pleasure Latha. More power to you :)
Thank you chief!
Hi Chandoo, thanks for the great video as always. But it seems that flash fill doesn't work on Mac. Is there a way to address it? Thanks
Who inspired you with that cleaner thing in the begining? Thought it was pretty novel.. good content as usual. was aware of most of it. Flash fill at times has been very handy & saved me from writing complex formulas.
I was thinking about various hooks for this video and suddenly I had a splash of wisdom (excuse the pun).
Great content as always!
Please sir,can you send us the link to download the Datasets you used.
Without a similar or same Datasets,some practices on the useful tips won't do much..
Kindly help with the Datasets sir
The dataset is in the video description. Not sure what else you need.
You are the best 👏 thank you so much for all your help.
Hello Dear,
I never miss your any of the videos and you are absolutely amazing in this.
Well, i have one query if you could guide me here,
- Let's say i have load query from folder and i have multiple files available in that folder belongs to every month sales and let's say i have built one report and loaded in excel using power query.
- Now after deleting a few files from folder, how could i keep old file data in excel where i have loaded the query besides that file get removed from folder?
- as we know after refracing of query it would load fresh data only in model.
basically, i want to preserve old data also in my excel where i have load the query.
Thanking you in advance.
You are welcome :)
Hi , i am new to this Chanel , which playlist i should follow to learn excel from the basics?
Start with this video ua-cam.com/video/F7aPazuS8QY/v-deo.html
Then watch this: ua-cam.com/video/v2oNWja7M2E/v-deo.html
If you want more step by step things, go for my course - chandoo.org/wp/excel-school-program/
@@chandoo_ Thank you very much 🕺
Hi! I am a new subscriber. Just found out you already have this data cleaning playlist. loving all your videos!!!!
Welcome!!
Thanks Chandoo Sir... but have a little bit slow pace while teaching this valuable teachings....
I use a mix of explanation styles in my videos. But if you find them too fast, feel free to pause, rewind the video. Also refer to the example workbooks to understand the concept better.
Amazing!
very very helpful
Chando one small doubt, as flash fill dont till automatically, if we convert the range in to table (including flashfill coloumn), is it update automatically....
Very useful 👍 vedio
wow man woderful job so smooth!!!!!!!!!!!
Thanks a lot!
Thank you so very much
Thank u sir great video
I am becoming an Excel Pro with Chandoo!
Hi thks u. i thing i got the point with how fast flash fill can help us filling the table but i did not got how iit usefull for the cleaning purpose. Help Thks
Hi,
I have a question. The dates column is inconsistent. IN the video you used power query to clean the dates column. Can you please give me solution on how to do it without using powerquery please?
I like your editing video 👍
Chandoo sir! will you please make videos for doing same tasks in Google Sheets?
Wow....just wow to your content...❤️
Thank you so much 😀
The best.