Hello Kenji, Hope you’re doing great. Watching you from Angola (Africa). I currently do not have a credit card, and I’ll like to take the advance Excel classes as I’ll be needing it to improve on my data analytics skills at work. I can pay via Western Union? Looking forward to hearing from you.
=TRIM(PROPER(D3)) is the most beautiful thing I've seen this week! Thank you, Kenji! Your voice is so soothing it just gives me confidence that I can learn to become an advanced Excel user.
What a time-saver! Your 'Master Data Cleaning Essentials on Excel in Just 10 Minutes' vlog is amazing. The quick and clear tips you shared are pure gold for anyone working with data in Excel. Thanks Kenji for making data cleaning so efficient and easy to understand.
It is facilitating greens sheets. That must be an outcome, to facilitate other services by deleting data and using of unapproved version. That is the whole start basis on the sheet. How can it be continued, whit suck smell and difficulty to understand out ?
Kenji, I am a retired person. But still i love to learn new thins. i loved your simple and concise way of presentation. Great presentation. Keep posting. God bless you with Spectacular success!
I followed along with each step perfectly as a beginner. Now, to learn these by heart and have someone employ me for what I'm sure is a pretty basic skill.
Thank you for your clear concise explanations and visual companion to the steps. I am loving your videos and appreciate the excellent Excel shortcut reminders! You are already saving me tons of time!
For the second client column, you can also use the proper formula. It will capitalize on the first letter and lowercase the rest. Thank you for this video 🙏
I have just watched this video and this is amazing stuff, thanks for your work. To complete the data cleaning, maybe we also could have sorted the date column =)
Thanks, the video is really great, I have truly learned something. It's awesome. Looking forward to watching and practicing other lessons as well. Best wishes Kenji!
Thank you Kenji. ❤ You just simplified what often seems like a Rocket Science 📡 The data you provided was very helpful as it provided an opportunity to follow your Tutorials, step by step 👌🤗🤗🤗🤗 I will register for the course with Career Principles👍!
Thank you for your great teaching. Would you please tell me how to add shape or color during video? Please tell me how to add vodeo effects. Because i need it for questions for explain my situation. Thank you.
they need a new shortcut for PASTE VALUE... I use it so often but hard to put that as a macro in the mouse hotkey or a macro in the keyboard. Only way I found is add the button to the ribbon on top, it does help make it slightly faster
I usually do ctrl+V, then ctrl, down, down and hit select. feels faster to me, though maybe that's just because I've done it for so long that I don't even think about it.
in the if error section , how did you do the select drag without using the mouse ? what shortcut should I use to do that ? especially if I want to drag something with a very large data set sheet ?
Thank you so much Sir. For Department and Region I applied Flash fill method CTRL E. And another thing I used CTRL H and replace blank space with N/A. instead of Go to Special method. Am I wrong? I appreciate your answer. Thanks....
I bookmark ome of your videos for reference in my personal library and this one definitely going in 😂! Thanks so much Kenji! Will best going up for your Power Bi class soon
I really enjoyed and find your videos very helpful in my data work. If I have dataset with different variations of gender pronouns like below: he,him,his He / Him / His HE, HIM, HIS he him his he/ him/his he/him/his he, him, his HE/HIMHIS How can I go about standardizing the above to "He/him/his" using Power Query? Thank you.
Question: Why did the "remove duplicates" function didn't remove the David Rasmussen row, which is also repeated? I had to use Conditional Formatting to find out about it. I'm not judging I'm just truely curious to know about it.
🚀Take our Excel course here: www.careerprinciples.com/courses/excel-for-business-finance
Hello Kenji,
Hope you’re doing great.
Watching you from Angola (Africa).
I currently do not have a credit card, and I’ll like to take the advance Excel classes as I’ll be needing it to improve on my data analytics skills at work.
I can pay via Western Union?
Looking forward to hearing from you.
how do I download RAW DATA to practice on my laptop??
Sir pls tell me how download data u pinned
@@abdulsalambamidele5389visit kaggle
hi
No time waste, no irrelevant talk, just to the point. Keep up the good work.
=TRIM(PROPER(D3)) is the most beautiful thing I've seen this week! Thank you, Kenji! Your voice is so soothing it just gives me confidence that I can learn to become an advanced Excel user.
Indeed!!
Yes for sure
Yes 😊
You're the man, Kenji! I have been using excel for a decade and still find something new for myself in every one of your videos. Best wishes.
Thanks for your message Dan! Really appreciate it glad you find the content useful 👍
Woooooooow the proper/trim combo is a game changer. Thanks!
What a time-saver! Your 'Master Data Cleaning Essentials on Excel in Just 10 Minutes' vlog is amazing. The quick and clear tips you shared are pure gold for anyone working with data in Excel. Thanks Kenji for making data cleaning so efficient and easy to understand.
It is facilitating greens sheets. That must be an outcome, to facilitate other services by deleting data and using of unapproved version. That is the whole start basis on the sheet. How can it be continued, whit suck smell and difficulty to understand out ?
Kenji, I am a retired person. But still i love to learn new thins. i loved your simple and concise way of presentation. Great presentation. Keep posting. God bless you with Spectacular success!
I followed along with each step perfectly as a beginner. Now, to learn these by heart and have someone employ me for what I'm sure is a pretty basic skill.
I only can appreciate you for your time you're putting in for us. You're awesome and keep doing this good work.
You're Teaching Skills Are Awesome And Your Very Descriptive...This Video Is Greatly Appreciated 👏 👏👏👏👏
What an absolute masterpiece! I was searching for such a course like this. Great job, thank you for this :)
Kudos brother. Your an IT specialist. I am looking forward to learning data validation and data Visualization in your next upcoming videos.
When i watch your videos i always learn something knew, your tutorials are always educative
thank you🤗
Thank you for your clear concise explanations and visual companion to the steps. I am loving your videos and appreciate the excellent Excel shortcut reminders! You are already saving me tons of time!
This is so interesting. You made Excel easy to learn and do data analysis.
Glad it was helpful!
In every Excel tutorial I have watched, I learn something new. Adding this to my Excel playlist lol
For the second client column, you can also use the proper formula. It will capitalize on the first letter and lowercase the rest. Thank you for this video 🙏
Hey Kenji bro ! Greatly appreciated this video as I’ve got to know these tricks, and the way you explain it feels to learn more.❤❤❤❤❤❤❤❤
Your new subscriber here was amazed at how you taught us to navigate Excel.
This is awesome. Often we concentrate on other functions and wasting time on data cleaning.
I am so impressed. Learned about text to color,
Wow!! This is so wonderful; all this time i was so scared about data cleaning
Thank you very much! I learned a lot. God bless you.
Master Kenji your explanation is very good and concise and thank you, go ahead to benefit from you.
Mind blown in the first couple of minutes. Never knew about the wildcard in replace or Alt V H H - been searching for that shortcut for years!
And Proper… awesome
And text to column - doh - could’ve used that today instead of finding the hyphen and trimming text doh lol
Glad it was helpful :)
Thank you so much for this video, I really like it. method.
You made everything look very easy. I am following you definitely
Short video with a very good insight in data cleaning
start my Excel trip from here. Thank u
Such simple & easy to remember shortcuts ...thanks kenji
youre back sir keep going
Thank you, I will
Save to watch later. Let me try it tmr morning at work😂 thanks
Wow 👌. I really don't know excel 😅. You've made me love excel, good Job.
I have just watched this video and this is amazing stuff, thanks for your work. To complete the data cleaning, maybe we also could have sorted the date column =)
You can also use power query for cleaning data like to just select information and go to data then select from table range
SUCH A GREAT VIDEO! THE ALGOROTHM BLESSED ME
Thanks a lot, your way of delivering is awesome. I find this video very helpful for me. Thanks again!
Superb explaination man😊 it is very helpful ,THANK YOU !
It helped me alot while cleansing abig data Excel spreadsheet.
I love your teachings, thank you so much
شكرا لك معلومات قيمه يا استاذ ..
This lesson was very insightful. Thank you
thank you for your service to excel learners like me! God bless you!
best vid. so much info in the span of 10mins 👏
Thanks this was a fun exercise!!
Keep up the Good Work🤩
This is pure awesomeness. Thank you!
Thank you for sharing. I like your tutorials.
Thank you so much for sharing!
You are the best Kenji !
Hurray! Super helpful video. Thank you so much for sharing!💯💯💯
Amazing work!
Very great tutorial, learned a lot
Very helpful! Thanks, Kenji☺️
Thanks, the video is really great, I have truly learned something. It's awesome. Looking forward to watching and practicing other lessons as well. Best wishes Kenji!
This is great video for learn new things or skills congrats 😮
Love your work Bro. Appreciate your effort to help people like learn analytics
Thanks great video.. plz make data cleaning for beginner to pro..
This is hands-on!
I cannot thank you enough. ❤
Glad you like it!
Thank you Kenji. ❤
You just simplified what often seems like a Rocket Science 📡
The data you provided was very helpful as it provided an opportunity to follow your Tutorials, step by step 👌🤗🤗🤗🤗
I will register for the course with Career Principles👍!
wow thanks for the practice file. really handy so we could follow your steps. cheers
You are a life saver Kenji
Thanks alot for those useful tricks 😘
Love you Kenji, You're super!!!!
very useful
Great help Sir. Thank you.
It was a really instructive and neat video. 🎉
insightful
Thank you for your great teaching. Would you please tell me how to add shape or color during video? Please tell me how to add vodeo effects. Because i need it for questions for explain my situation. Thank you.
Thak you so much for this interesting video
Thank you!
Thank you so much! it has helped me in so many ways
Appreciate it, brother.
they need a new shortcut for PASTE VALUE... I use it so often but hard to put that as a macro in the mouse hotkey or a macro in the keyboard. Only way I found is add the button to the ribbon on top, it does help make it slightly faster
I usually do ctrl+V, then ctrl, down, down and hit select. feels faster to me, though maybe that's just because I've done it for so long that I don't even think about it.
Try control C to copy then when pasting, right click and press V on your keyboard..
You are really good, thank you.
in the if error section , how did you do the select drag without using the mouse ? what shortcut should I use to do that ? especially if I want to drag something with a very large data set sheet ?
this is a beautiful video
I just recently learned about the wildcard symbols.
Thank you so much Sir. For Department and Region I applied Flash fill method CTRL E. And another thing I used CTRL H and replace blank space with N/A. instead of Go to Special method. Am I wrong? I appreciate your answer. Thanks....
I bookmark ome of your videos for reference in my personal library and this one definitely going in 😂! Thanks so much Kenji! Will best going up for your Power Bi class soon
Thats great to hear Tambah, thanks for supporting!
I really enjoyed and find your videos very helpful in my data work. If I have dataset with different variations of gender pronouns like below:
he,him,his
He / Him / His
HE, HIM, HIS
he him his
he/ him/his
he/him/his
he, him, his
HE/HIMHIS
How can I go about standardizing the above to "He/him/his" using Power Query? Thank you.
this is so good...thanks
Excel course is too expensive bro. $ 149.95 is like R 3,000 in South Africa. I really need to do it thou 😭😭 Time to save
In India it's almost 12000😢😢😢
Coursera has great excel course...and you can audit it for free
@BleuJasper-rb9ei he's being funny 😂😂😂😂
Kyle pew full course is free on a website online
I am providing free advance Excel training daily at 9 PM to 10 PM
Thanks so much
A masterclass in how to put together a video tutorial even if you already knew all those tips (I didn't)
THANK YOUUUUUUUUUUU my brother
Extraordinary!!!
Sir , just a basic question. When every time I type I just on the capslock key for the first capital letter . Any settings in Excel...
what a fantastic keep going, thank you too much.
It’s so interesting watching you! Thanks for what you do!
Thanks for watching!
Great stuff kenji .
Thanks for watching!
@kenjiExplains you are the best
Well done brother.❤
Question: Why did the "remove duplicates" function didn't remove the David Rasmussen row, which is also repeated? I had to use Conditional Formatting to find out about it. I'm not judging I'm just truely curious to know about it.
Hi Kenji, have you ever used or created Accounting Software using Excel?
Too Helpful video
can any one tell me whats the differncr between cleaing data as shown in video and using power query
Thank you bro
thanks bunch man
Thank you
Nice job. 🎉
Guest appearance by T. Rajender :)