Fuzzy Lookup is brilliant. Somehow i always get to learn something new from your videos. Btw still waiting for SQL part 3. That series helped me get invested in learning SQL.
Kenji, there’s an error in the Datedif results at 9:01 mins in. The Charles Koch age should be 89. I’ve suffered the same error before using the Datedif function and therefore rarely use it. Appreciate the other tips though. Keep up the good work!
Liked. In data cleaning, can I use power query to combine last name first name? The total column to separate debit and credit for positive and negative? Can we use power query to match two files? Regarding Aggregate, how to fix if the total don’t add the new row amount?
hello sir kenji i would like to ask if do you have a month by month comparison like (last month VS this month? im doing a progress report hope you can help and i appreciate it
is it possible to apply fuzzy matching and merging based on multiple columns? i am reconciling trades based on vba checking each cell but due to typos, it is really easy to missmtach. therefore fuzzy matching could be a great way to solve this issue.
On Microsoft word a function called sentence case, it helps to the data typing, but not default in Excel. So each time Capslock on and off after and before, hope you can fix my problem.
You have provided us various videos on excel But if it was in order then it will be of great help I am a finance Student and want to learn to do analysis through excel So can you make a video a short video in which you will only tell about the order in which we have to learn all this through your videos Like first starting with this topic and you can see my this video for this and then next step From beginner to advanced or starting to end. When we learn in a systematic way we learn it more efficiently.
👉 Take our Data Analyst Program: www.careerprinciples.com/career-track/the-data-analyst-program
Thanks a lot for the video! I really like the Aggregate Functions and Fuzzy Matching feature.
I feel like I've been seeing excel even in my dreams lately 😅 thanks a lot Kenji, this was great!
Fuzzy Lookup is brilliant. Somehow i always get to learn something new from your videos. Btw still waiting for SQL part 3. That series helped me get invested in learning SQL.
Kenji, you are the best!!
I am loving his excel course. Great video Kenji!
That's awesome thank you!
Much love Mr Kenji. Akways bell-on for your videos ❤
your videos are very helpful. I always learn couple of new tips from your videos even though I've been using Excel for a while. Thank you
Thank you Kenji
Thank you Kenji. I’ll try this after lunch hehe!!!
Awesome thanks for watching :)
Very Helpful..
Brother Could you provide some Excel videos that are useful for supply chain management and operations roles? Please make a video on this topic. ❤❤❤❤❤
Same I need
up thisss!!!! 😂
Yessss, Pleasssse!! I work in supply chain and this would be so amazing ❤
Kenji, there’s an error in the Datedif results at 9:01 mins in. The Charles Koch age should be 89. I’ve suffered the same error before using the Datedif function and therefore rarely use it. Appreciate the other tips though. Keep up the good work!
Neat tricks!!
Thank you!
Fuzzy Lookup is a very useful tool in data cleaning. Could you do a separate in-depth tutorial with various samples. Thanks.
nice
very good
please make a separate video on advance Power Query
I'll keep your suggestion in mind :)
@@KenjiExplains thanks 👍
Liked. In data cleaning, can I use power query to combine last name first name? The total column to separate debit and credit for positive and negative? Can we use power query to match two files?
Regarding Aggregate, how to fix if the total don’t add the new row amount?
hello sir kenji i would like to ask if do you have a month by month comparison like (last month VS this month? im doing a progress report hope you can help and i appreciate it
is it possible to apply fuzzy matching and merging based on multiple columns? i am reconciling trades based on vba checking each cell but due to typos, it is really easy to missmtach. therefore fuzzy matching could be a great way to solve this issue.
On Microsoft word a function called sentence case, it helps to the data typing, but not default in Excel. So each time Capslock on and off after and before, hope you can fix my problem.
Hi kenji please upload this Sunday's video, eagerly waiting 😂
Greetings. Great content as always. Do you have Data Analystics course in linkedin Learning?
Thank you! We don't have courses on linkedin. All our courses can be found here: www.careerprinciples.com/all-courses
How you add duration using powerquery?
Kenji ur amazing ❤😁
Thank you :)
hello sir how enable data type option in excel 2021
Hello, I would like to contact you privately regarding practical training in data analysis..
You have provided us various videos on excel
But if it was in order then it will be of great help
I am a finance Student and want to learn to do analysis through excel
So can you make a video a short video in which you will only tell about the order in which we have to learn all this through your videos
Like first starting with this topic and you can see my this video for this and then next step
From beginner to advanced or starting to end.
When we learn in a systematic way we learn it more efficiently.
3:42 ,didn't get it
Sir why are you not dulpaded yours yesterday video ????
Back next week thanks for asking:)
Just took some time off
@@KenjiExplains I eagerly wait for your videos.
And I want to get classes from you , but I don't have enough money 😔
is fuzzy lookup new?
it's been around for a good few years!
Pls brother provide 4k resolution pls pls...
Hey thanks for the suggestion. Are there things you struggle to see in 1080 HD? Seems decent with my 27inc screen but let me know!
Because this is educational content, if you provide it in 4K resolution, I think it will be very helpful for everyone. Please consider my suggestion.
I can't seem to download the free excel file for this video ☹😢
just checked seems to be working correctly, please check your email inbox :)
@@KenjiExplains Just did but i didn't recieve any mail
I thought Fuzzy match was when i had to much to drink at lunch.
😂