TOP 10 Excel Formulas to Make You a PRO User
HTML-код
- Опубликовано: 7 июн 2024
- 👉 Learn the top 10 most useful Excel formulas using real-life examples.
Get 25% OFF Financial Edge using code KENJI25: bit.ly/3xNV4VW
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/62ac88...
In this video you'll learn all of the essential excel formulas ranked from easiest to hardest.
In level 1 we'll look at the sequence formula, follow by string functions such as left, mid, and right.
In level 2 we'll go over date functions like weekday, weeknum, or today, alongside an IF statement.
In level 3 we'll go over advanced IF statement formulas such as the SUMIF and the SUMIFS
In level 4 we'll go over vlookup (part of the lookup family) and the IFERROR
In level 5 we'll go over the most complex formulas which are going to be the xlookup, and the index match.
To follow along, you can download the free excel file above!
LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: bit.ly/3Ds47vS
SOCIALS:
📸 Instagram - / kenji_explains
🤳 TikTok - www.tiktok.com/@kenjiexplains...
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Level 1
2:27 - Level 2
5:37 - Level 3
9:29 - Level 4
12:15 - Level 5
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Get 25% OFF Financial Edge using code KENJI25: bit.ly/3xNV4VW
Hi Kenji, does this course cover PowerPoint for investment presentations too?
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
Thank you!! Hopefully does haha 😆
@@KenjiExplains good luck and keep em coming 👍👍👍👍👍👍
× 5
So true
@@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.
I think the formula you have written is something I'll have to work on to understand!
You say match() in your formula, why isn’t there anything filled in?
@@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!
They don’t k know Kenji
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
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?
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!
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
I was taking the excel course for the exam and this definitely helps reviews the formulas again so thanks for the video!!
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!
thank you!
Thanks so much Kenji, you make it look simple, easy to understand. 👏
Thank you for watching!!
Kenji, You are a very good teacher /lecturer and a slick marketer. Wishing you all the best
Thanks Kenji! Very useful content!
Thank you for showing the index match. That is. Exactly what I need.
Great to hear!
I really need a 1 hr video of you explaining these excel analysis. great job bro and much love from kenya
A big thumbs up for this video, those indexmatch functions save my day, thank you!
best thing of your videos is, you keep it simple and short. thanks for sharing knowledge.
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!
Excellent teaching
Hi kenji
I know all, except for the sequence and the strings
Learnt something.
Thank you very much.
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.
Thank you Brian, noted the suggestion :)
@@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.
Hello Kenji ,you are a real tutor.love your lectures
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!
the best excel teacher in youtube, good job.
Thank you make these formulas so easy to understand.
Thank you again Kenji, appreciated!
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 👏👏👏
Thank you for improving my knowledge. :)
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.
I recently discovered power query too, it is indeed a time saver too
Thank you for your video!!!
Fantastic video! Will binge all your vids now , so helpful
Very precise and clearly explained. Thank you!
Glad you enjoyed it!
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 ….😅
It was worth watching it.
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.
CFBR
great tips as alwas keep going kenji i've learned a lot from you thank you
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
Outstanding! Dear Kenji: best regards from Limón, Costa Rica
Amazing video Kenji! Very useful 👏
Thank you!!
today by chance saw your tutorial. thank you for great video.
Kenji really explain
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.
IT WAS A VERY USEFUL VIDEO
your videos keep getting better keep it up!
Thank you man
Thank you !!
thank you for being an amazing teacher !
Just love your content! Thank youuu!
@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.
Fantastic! Thank you.
Thank you master
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 very much. The content was useful for me.
I appreciate your content. Thanks
Acabo de encontrar tu canal, es lo máximo. ¡Muchas gracias!
Good tips + great explanation
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
Thanks!
Knew all but xlookup which I hadn't used before. but great video easy to follow allong.
Really helpful...Thanks a lot.
Index match match is what I didn’t use much and really needed it
Very Helpful!
I knew O out of 10 formulas. THANK YOU!
I've never used the indexmatch, well I learned a new one so thx for that...
Niiiice!Learnt alot Kenji!
You are extremely good 😮
Super do-per!