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 🙏
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!
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 =)
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.
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.
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👍!
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....
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, 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....
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