🚀Take our Excel course here: www.careerprinciples.com/courses/excel-for-business-finance

@sabisabss1507

Жыл бұрын

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.

@abdulsalambamidele5389

11 ай бұрын

how do I download RAW DATA to practice on my laptop??

@shivanandsoodi8854

6 ай бұрын

Sir pls tell me how download data u pinned

@themajestyjoshua

6 ай бұрын

​@@abdulsalambamidele5389visit kaggle

@muhammadlimanmahdi3934

2 ай бұрын

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.

@stevenashley2626

3 ай бұрын

Indeed!!

@TheShadowgaming01

7 күн бұрын

Yes for sure

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.

@KenjiExplains

11 ай бұрын

Thanks for your message Dan! Really appreciate it glad you find the content useful 👍

I only can appreciate you for your time you're putting in for us. You're awesome and keep doing this good work.

What an absolute masterpiece! I was searching for such a course like this. Great job, thank you for this :)

Woooooooow the proper/trim combo is a game changer. Thanks!

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!

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!

Such simple & easy to remember shortcuts ...thanks kenji

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.

@Potencyfunction

5 ай бұрын

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 ?

Kudos brother. Your an IT specialist. I am looking forward to learning data validation and data Visualization in your next upcoming videos.

It helped me alot while cleansing abig data Excel spreadsheet.

This lesson was very insightful. Thank you

Great video, and very easy steps to follow

thank you for your service to excel learners like me! God bless you!

Love your work Bro. Appreciate your effort to help people like learn analytics

Hurray! Super helpful video. Thank you so much for sharing!💯💯💯

In every Excel tutorial I have watched, I learn something new. Adding this to my Excel playlist lol

You are a life saver Kenji Thanks alot for those useful tricks 😘

Thanks a lot, your way of delivering is awesome. I find this video very helpful for me. Thanks again!

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!

wow thanks for the practice file. really handy so we could follow your steps. cheers

Short video with a very good insight in data cleaning

Welcome back KEnji. Helpful tutorial. Thanks!

@KenjiExplains

Жыл бұрын

Thank you for supporting!

Master Kenji your explanation is very good and concise and thank you, go ahead to benefit from you.

You managed to cover most of the data cleasing in just 1 video 👏🏻👏🏻👏🏻

Thank you so much! it has helped me in so many ways

This is pure awesomeness. Thank you!

Man, great video! So much info in a short clip. Your videos are my newest addiction as I'm new to this world Cheers and congrats! 🎉

@KenjiExplains

9 ай бұрын

Thank you Victor! Glad you like them

I love your teachings, thank you so much

Wow!! This is so wonderful; all this time i was so scared about data cleaning

Very helpful! Thanks, Kenji☺️

start my Excel trip from here. Thank u

You are the best Kenji !

Thak you so much for this interesting video

best vid. so much info in the span of 10mins 👏

SUCH A GREAT VIDEO! THE ALGOROTHM BLESSED ME

This is awesome. Often we concentrate on other functions and wasting time on data cleaning.

this is a beautiful video

Thank you for sharing. I like your tutorials.

شكرا لك معلومات قيمه يا استاذ ..

T R Thala ❤❤., neega intha video le irukinga😅 . Love from Tamil Nadu - India

This is so interesting. You made Excel easy to learn and do data analysis.

@KenjiExplains

Жыл бұрын

Glad it was helpful!

Wow 👌. I really don't know excel 😅. You've made me love excel, good Job.

Great help Sir. Thank you.

Well done brother.❤

Love you Kenji, You're super!!!!

THANK YOUUUUUUUUUUU my brother

Very great tutorial, learned a lot

You are really good, thank you.

Thanks so much

It was a really instructive and neat video. 🎉

@kenjiExplains you are the best

Great job. You got it. awesome job.

Hi Kenji, I love your video content, and very useful in handling my data, however, incident reports both human-induced and natural such as landslides, felled, and uprooted trees. Do you have any dashboard that could fit this data, Thank you very much....

youre back sir keep going

@KenjiExplains

Жыл бұрын

Thank you, I will

brilliant man keep on!!!

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 =)

this is so good...thanks

Appreciate it, brother.

Great tutorial!! Cheers

@KenjiExplains

Жыл бұрын

Glad you liked it!

thank you so much

Thanks bro. Too good.

Thank you bro

Thank you

Thanks great video.. plz make data cleaning for beginner to pro..

Too Helpful video

thanks

what a fantastic keep going, thank you too much.

Nice job. 🎉

thanks bunch man

Very impressive tutorial from Kenji...have gathered more skills of navigating Excel......bravo bro,,Am from kenya,Machakos county

@KenjiExplains

11 ай бұрын

Great to hear that! Thanks for watching!

Thankyou !!!

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!

@mowburnt

Ай бұрын

And Proper… awesome

@mowburnt

Ай бұрын

And text to column - doh - could’ve used that today instead of finding the hyphen and trimming text doh lol

@KenjiExplains

Ай бұрын

Glad it was helpful :)

MERCI KENJI

Thank You.....

Great stuff kenji .

@KenjiExplains

Жыл бұрын

Thanks for watching!

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.

very useful

Hi Kenji, have you ever used or created Accounting Software using Excel?

You're good!!

Loving it

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

@KenjiExplains

Жыл бұрын

Thats great to hear Tambah, thanks for supporting!

It’s so interesting watching you! Thanks for what you do!

@KenjiExplains

Жыл бұрын

Thanks for watching!

This is hands-on! I cannot thank you enough. ❤

@KenjiExplains

Жыл бұрын

Glad you like it!

@princedestinyugo5514

Жыл бұрын

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👍!

Thanks brother 🫂

Awesome

A masterclass in how to put together a video tutorial even if you already knew all those tips (I didn't)

3:46 nice template

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....

hi thanks for this video but i cant seem to do the replace part.

I'd like to add CTRL + SHIFT + V does the same as ALT H V V

I just recently learned about the wildcard symbols.

Kenji!!!🙌

Hey I’ve signup on your course. It’s 🎉

@KenjiExplains

Жыл бұрын

Awesome! Thank you Cobby

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.

Can this process be automated using macro?

Thanks for the simple video

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

@dantherman4202

11 ай бұрын

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.

@preeteshramdas3651

11 ай бұрын

Try control C to copy then when pasting, right click and press V on your keyboard..