Get 25% OFF Financial Edge using code KENJI25: bit.ly/3xNV4VW

@zachjo1457

2 жыл бұрын

Hi Kenji, does this course cover PowerPoint for investment presentations too?

@blaiseization

11 ай бұрын

Hi Kenji, on the excle sheet when I was practicing there was an error and I don't know where it originated from. My calculation for time of arrival was showing show negative all the way down. e.g -225 What could be the cause of this? Thank you again for your cooporation

This video is so underrated, it should've reached 100000 views by now

@KenjiExplains

2 жыл бұрын

Thank you!! Hopefully does haha 😆

@basilabedallah5797

2 жыл бұрын

@@KenjiExplains good luck and keep em coming 👍👍👍👍👍👍

@Thetiredman

Жыл бұрын

× 5

@tapiwanalwimba6065

11 ай бұрын

So true

@4061earthabcdesong

7 ай бұрын

​@@KenjiExplains Thank you so much, Kenji 😊😊👍👍👍 You're our HERO 🙇🙇🙇🙇‍♀️🙇‍♀️🙇‍♂️🙇‍♂️🙇‍♀️🙇‍♀️🙇‍♀️

You by far have the best tutorial videos. Thank you for providing so many helpful videos.

Thanks for the video. A few comments: you can use CTRL + ~ to toggle show formulas on and off if you prefer keyboard vs the mouse click option. I would say that there is a level 6 or higher lookup formula that was not mentioned. Its a combination of indirect + index match. This lets you dynamically select the array in question as opposed to having to choose the array manually. The formula would look like index(indirect(concatenate("C", match(),":","C", match()), False),match(),match()). In this example, you can specify criteria by dynamically creating an array address and then looking up a value within that address based on separate criteria. It's definitely a complex scenario but I've come across this before and needed to break free from hard coding the initial array of the index.

@salala182

Жыл бұрын

I think the formula you have written is something I'll have to work on to understand!

@joukenienhuis6888

Жыл бұрын

You say match() in your formula, why isn’t there anything filled in?

@roomtemperature7096

10 ай бұрын

@@joukenienhuis6888 it's for your data

WOW KENJI! I'm improving a lot my EXCEL skills thanks to your courses. My workmates are hallucinating how fast I apply formulas and how quickly I finish my assignments! CHEERS!

@doctordan1668

Жыл бұрын

They don’t k know Kenji

@AlexisKasperavicius

Жыл бұрын

Careful! Management will often get rid of them, give you double-work and pay you the same! That's when you need to become a consultant! :-)

I can't thank you enough. You break each point down and put it in context. Although it's not rocket science, some tutorials make it very much so!

Thank you so much for sharing this, it is about 25 years since I did my Excel training, so this has been a brilliant refresher; as well as learning so much more. Many blessings.

I am 46 and still learning excel, you have been of immense help. I knew some of these formulas but not all. Thank you kenji

@KenjiExplains

Жыл бұрын

Awesome to hear Antony :)

I love your videos! Learning excel for free at home and I feel so confident!

Thanks for the bonus tip. I am beginner it helps a lot for me 😄

Thanks for the course. Didn’t know the xlookup. You are a clear and straightforward instructor.

Thanks Kenji! Really did not expect Index -- Match could be used so efficiently. Learned another tip for except from you today!

Wow! Bonus tips are life savers when working with complex project files. Thanks!

Hey Kenji amazing content as usual. If you could make a video on how do we take assumptions in financial models , it would be helpful?

@KenjiExplains

2 жыл бұрын

Noted thank you!

Thanks Kenji, great video. You make complex formulae easy to follow and understand.

Thank you, Kenji! Insightful, clear and concise.

I love how you explain everything. Easy to understand. Thank you,

Always learning new skills and tricks in Excel, since I started with spreadsheets back with Lotus 123 rel 3.01 a long time ago, and back when you were limited to a lot less columns and rows. I used to use the string functions to extract data from a single column that I stored information in.

Excellent work, one of the most helpful excel tutorials i've ever seen.

Thank you so much for this, it was incredibly useful and well made. You're a great teacher!

@KenjiExplains

Жыл бұрын

Thank you!

This video was outstanding! We have been using some new programs that are adding more complex material, and this was so helpful in ways to assimilate the data. This is useful for beginners or intermediates who need some refresher training. Thank you!

Hi, I didn't know the bonus tips. Really useful. I knew a few of the formulas. I knew of them all but hadn't had the need to use them. Now I can see that they would be useful in my work: especially "Index - Match". Thanks

Thanks sir for the lecture and for indirectly reminding me of what should be done to iron things in the future in particular.

Excellent video. As someone who wrote their own accounts programme in Excel and VBA, I knew all the formulas but didn’t know the level one stuff. Sequence, CTRL, shift down arrow and using the F4 key to lock in the $ sign. Well done!

@KenjiExplains

Жыл бұрын

thank you!

I was taking the excel course for the exam and this definitely helps reviews the formulas again so thanks for the video!!

Thanks so much Kenji, you make it look simple, easy to understand. 👏

@KenjiExplains

2 жыл бұрын

Thank you for watching!!

Thanks Kenji! Very useful content!

Kenji, You are a very good teacher /lecturer and a slick marketer. Wishing you all the best

Thank you for showing the index match. That is. Exactly what I need.

@KenjiExplains

2 жыл бұрын

Great to hear!

I really need a 1 hr video of you explaining these excel analysis. great job bro and much love from kenya

best thing of your videos is, you keep it simple and short. thanks for sharing knowledge.

A big thumbs up for this video, those indexmatch functions save my day, thank you!

This was awesome thank you! I love these short vids.

Thank you, its the first time ive understood some of the more complex formula's

thanks! I didnt know the xlookup and was always confuse on how to use index match. it was very clear

you are the first who attach the file with which I can practice! thanks! you deserve my subscribe.

Thank you for this video. It is a great video for "refreshing" Excel knowledge! Looks like others have made recommendations for high levels. I look forward to it!

Excellent video, so useful, and sure will be handy on a day to day use. Thank you for sharing, I am so grateful.

THANK YOU SO MUCH SIR KENJI. MORE STRENGHT TO CREATE INFORMATIVE AND VERY HELPFUL VIDEOS REGARDING EXCEL!

Hi Kenji, would love to see a video following up your one on PE. Could touch on carry, co-invest,waterfalls, etc.

Nice video. Up to the point. I use all of aforementioned formulas and I found it helpful for a quick reference/reminder

Great job with this collection of formulas/functions!

Hi kenji I know all, except for the sequence and the strings Learnt something. Thank you very much.

Excellent teaching

This is so awesome. I knew a lot of the formulas but not all. I will definitely watch this and make notes. @kenji you should have a PDF summary for all formulas covered.

@KenjiExplains

Жыл бұрын

Thank you Brian, noted the suggestion :)

@bthogo

Жыл бұрын

@@KenjiExplains Sell the summary for 2-3 dollars. You have many viewers who benefit from your videos. You should benefit as well. If you manage 200,000 sales by the end of the year at 2 dollars each…quick 400? Food for thought. I would gladly pay two dollars for this video’s summary.

Good teacher!!!

hayee Kenji, Your videos are really helpful.

Wow! Great video. I knew some of the 1 to 3 stars and vlookup formula. Very useful video as well as bonus tips. Thanks for sharing!

Hello Kenji ,you are a real tutor.love your lectures

Thank you make these formulas so easy to understand.

Thank you again Kenji, appreciated!

the best excel teacher in youtube, good job.

Very useful video thank you! I do use all these functions for my accounting job

You sir! Hats off for crisp n precise tutorial! 😊👍

Very well done 👏👏👏

Thanks for your video. I don’t use index match but the others are frequent flyers. Xlookup is a great replacement. Prior we had to do helper columns if our data was was in left to right. So many new features to include power Query which is a godsend. Nice job on your channel content.

@joukenienhuis6888

Жыл бұрын

I recently discovered power query too, it is indeed a time saver too

Thank you for improving my knowledge. :)

Thank you for your video!!!

Fantastic video! Will binge all your vids now , so helpful

Hey a few things to try. Xlookup replaces ALL functions of Vlookup and IndexMatch and Hlookup, so if you are using any of these functions in any way Xlookup can do it. If you want to look up 2 values you need to use &. Example =XLOOKUP(lookup_value & lookup_value, lookup_array & lookup_array, return_array,””,0,1) this would be used for a vertical data set like in your example. You can also have 2 lookups used in a table format to return the cell in the table where the two cells meet at. =XLOOKUP(lookup_value1,AH3:AH13,XLOOKUP(lookup_value2,AI2:AM2,AI3:AM13,"",0,1),"",0,1) I left the cell references in, but you can get the picture. Also don’t forget about returning non adjacent rows =XLOOKUP(lookup_value2, lookup_array,INDEX(return_array,SEQUENCE(ROWS(return_array)),{1,3,4}),"",0,1) These are just a few examples of what you can do. Great video, but I have to admit that I was more then a little upset with the title of the video being “Make You a PRO User” and then not to learn anything new. I am an average excel user so ….😅

Hi Kenji, your videos are so great and instructional. I really appreciate your efforts and your sharing. Could I ask you please to include some videos related to Insurance companies business, cash flows, Income statements, balance sheets, actual vs. target, sales people tracking.... thanks a ton in advance.

@ceterisparibus8966

Жыл бұрын

CFBR

Very precise and clearly explained. Thank you!

@KenjiExplains

Жыл бұрын

Glad you enjoyed it!

great tips as alwas keep going kenji i've learned a lot from you thank you

It was worth watching it.

Great video, thank you! I’m 57 and I used Lotus 1-2-3 on DOS where you had to tell it how many rows and columns you wanted. I’ve been using Microsoft Office since 1998 and the formulas and features that Excel has is always growing, but it continues to be glitchy. I have to use the Trim(Substitute formula to convert cells to where I can get rid of leading spaces and format them as currency or whatever I want. Your channel has great content but I’m pretty sure you’d get extra subs and a lot of views if you did a video on the 10 best Excel workarounds and how to auto save and find xlsb files that aren’t in Recover files. Those are the things that save time and frustration!

This is awesome. Thank you very much. The presentation is top notch.

Great video thank you

today by chance saw your tutorial. thank you for great video.

Amazing video Kenji! Very useful 👏

@KenjiExplains

2 жыл бұрын

Thank you!!

Hi Kenji, I am learning a lot from your video tutorial. I appreciate your content or subject matter. Another thing is the courses you introduced where we can enroll to. These are great concerns to increasing knowledge.

Thanks for those great tips. Appreciate and subscribed.

Thank you for your excellent videos. Supper helpful and clear 🙏🙏

You absolute legend. Thank you.

Kenji really explain

Outstanding! Dear Kenji: best regards from Limón, Costa Rica

IT WAS A VERY USEFUL VIDEO

your videos keep getting better keep it up!

@KenjiExplains

2 жыл бұрын

Thank you man

Thank you !!

thank you for being an amazing teacher !

Just love your content! Thank youuu!

Fantastic! Thank you.

Great explanation. thank you for your videos.

Thank you soo much..I thought I knew excel but I was humbled quick..This video is so amazing.Learned a lot.Gonna watch the others too ❤🤩

Thank you.

Thank you master

Good tips + great explanation

@KenjiExplains The content you produce is very practical and useful for working with finance. Thank you very much for sharing. I have a question, I am interested in the LBO valuation model, can you create a video on this topic? Thank you in advance.

I appreciate your content. Thanks

Thank you very much. The content was useful for me.

Acabo de encontrar tu canal, es lo máximo. ¡Muchas gracias!

So going by this video I'm an excel pro. Great. Please Kenji do a video explaing the Offset function that's one formular I'm yet to understand

I knew O out of 10 formulas. THANK YOU!

Thanks!

Index match match is what I didn’t use much and really needed it

Knew all but xlookup which I hadn't used before. but great video easy to follow allong.

Really helpful...Thanks a lot.

Very Helpful!

I've never used the indexmatch, well I learned a new one so thx for that...

Niiiice!Learnt alot Kenji!

this video was eye-opening for me, learnt some new formulas here. cheeers