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.
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
👉 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.
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
I am loving his excel course. Great video Kenji!
That's awesome thank you!
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!
Kenji, you are the best!!
Fuzzy Lookup is a very useful tool in data cleaning. Could you do a separate in-depth tutorial with various samples. Thanks.
Much love Mr Kenji. Akways bell-on for your videos ❤
Thank you Kenji
Thank you Kenji. I’ll try this after lunch hehe!!!
Awesome thanks for watching :)
Very Helpful..
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?
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 ❤
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
very good
please make a separate video on advance Power Query
I'll keep your suggestion in mind :)
@@KenjiExplains thanks 👍
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.
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
Neat tricks!!
Thank you!
nice
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 😂
How you add duration using powerquery?
Hello, I would like to contact you privately regarding practical training in data analysis..
hello sir how enable data type option in excel 2021
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 😔
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.
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.
Kenji ur amazing ❤😁
Thank you :)
is fuzzy lookup new?
it's been around for a good few years!
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
3:42 ,didn't get it
I thought Fuzzy match was when i had to much to drink at lunch.
😂