🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/y21 Correction: Profit Margin % should be gross profit / revenue NOT revenue / gross profit as I did it in the video. Sorry for the mistake!
good morning sir can I ask aside using control f is there any ways on finding data inside a formulated cell sample inside the A1 cell the formula inside was =B1+c1+d1+e1+F1+g1 then I want to find the d1 what ways in excel can I used
What an amazing video ! I have come to the conclusion that those that simplify sophisticated matter like excel are those who have mastered it to the fullest. wow! just wow!
"I just watched Kenji's video on the Top 10 Essential Excel Formulas for Analysts in 2023, and I have to say, it was incredibly helpful! As someone who's always looking to upskill in Excel, I appreciate how clear and concise his explanations were. The formulas he covered were definitely essential for any analyst, and I learned some new tips and tricks along the way. Thanks for sharing your expertise, Kenji!"
Honestly all these are mindblowing. As a guy thats been using excel for my new position for about 1 year now and so many steps are tedious knowing i can implement some of these lessons is a gift from the excel gods 😂
Great videos! Anyone have a system for recording and/or remembering these so they are easier to recall and use? I've taken lots of excel classes but remembering everything is a challenge.
I really appreciate your videos! I was wondering if you could use a drop down menu instead of typing the month or data in those dynamic formulas. Fabulous videos. They are very helpful with my college assignments. I plan to watch all of videos. Thank you for sharing your dynamic talents and skills with us! Ciao!
Hi Kenji, great videos you are making! Love to watch.. in this Excel vid with your #1 to find your result maybe an easier formula to use is by using twice the XLOOKUP function? like =XLOOKUP(B14,B3:B11,XLOOKUP(C14,C2:J2,C3:J11))
Great Video. In your example of using the large function at 6:50 in how would I pull the top 5 results in column C along with the names that go with the result from column B so it shows both in column F and G. Also my source table is on another work sheet in the same work book. Thanks
Sir,"Textjoin" is also a better function instead of "and" function -if we had more cells to join in case of Country, City example-Trust this Learn with Kenji sir is always value +++ added
Your videos are so very hopefull, thanks! I just cant understand how are you choosing the correct cells for the function using the arrows? whenever i start typing a function i cant move bewtween cells..
Awesome video! I have a question. I resolved it. I can share my Excel spreadsheet with you. However, I want to find a more straightforward formula. I have a spreadsheet with several TABs. In TAB 1, the general info, sales order, original date, expiration date, how much is still open, etc. In the TAB 2 I have a Database with details of each item in each sales order (sales order / item / Quantity / price / etc.) I want to click the sales order from TAB 1 (general info) and go to TAB 2 (sales order details) and point it. Not sure if I was clear...
Hi, actually, the first example: Profit margin is calculated by taking the GROSS PROFIT and this is divided by REVENUE, not the other ay around. Other than that perfect video! :) You are wonderful!
Hi, Thank you for taking time to enlighten the masses. However, i encountered one problem as i tried to practice. My excel could not bring formulas like xlookup, sequence, filter, etc after typing = and the first 2 or 3 letters. When i type 'filter', it brings 'filterxml' instead. What could be the problem?
Thank you for the video. I'm preparing a teaching program where I need excel to calculate each letter "A" (section A, B or C) as a number and do the total sum of "A"s as numbers?
I I don't know what I'm doing wrong. My sequence looks like yours =SEQUENCE(50,,DATE(2023,1,1),7) I added the 0s but every time i hit enter they disappear. I really like that you include a spreadsheet that we can download and do with you. I'm having a hard time remembering what function, etc to use when.
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/y21
Correction: Profit Margin % should be gross profit / revenue NOT revenue / gross profit as I did it in the video. Sorry for the mistake!
Hey dude, I need your help at my excel sheet to get sum products
good morning sir
can I ask
aside using control f
is there any ways on finding data inside a formulated cell
sample
inside the A1 cell
the formula inside was
=B1+c1+d1+e1+F1+g1
then I want to find the d1
what ways in excel can I used
Thanks so much for this very useful link and information. Your videos are very informative detailed and easy to understand. Thanks again👍
That gives 64% 59% and 48%
good job
I want this video to burn into my retina permanently, you're saving analyst lives out here man
I got my job as a financial analyst. This helped so much, thank you from the bottom of my heart.
How much experience did you have when you applied? I'm wondering because I'm also looking for a job as a FA and dont have much experience :/
LARGE and SMALL functions were new to me. Also I learnt the SUMIFS in a different manner. Thank you!
All 10 are very good. I especially appreciated the 2nd example for the SUMIFS function.
Just Amazing. You are the GIFT who was given by youtube for us. Thanks for everything Kenji
It’s so crazy how in depth you can get using excel , I never would’ve imagined . I remember when I first started using excel back in the third grade !
the =index(filter()) pattern works beautifully too.
If you have not yet subscribed to this amazing channel, what are you waiting for. Great job, man!
What an amazing video ! I have come to the conclusion that those that simplify sophisticated matter like excel are those who have mastered it to the fullest. wow! just wow!
the first formula in this video is wrong :) Profit Margin %= (GP/Revenue) . Hope it helps. Overall the iferror concept is perfect .
Hey you're right! Thanks for pointing it completely missed it :)
I like that he's human after all. More relatable and projects authenticity.
Excel has fill function if we convert the data to table that can be used instead of string function
Hi Kenji... Which of your course is best for data analysis? I am trying to switch career to data analytics
1- cost/revenue will be handy
Agree. There are some basics formulas that you always use
"I just watched Kenji's video on the Top 10 Essential Excel Formulas for Analysts in 2023, and I have to say, it was incredibly helpful! As someone who's always looking to upskill in Excel, I appreciate how clear and concise his explanations were. The formulas he covered were definitely essential for any analyst, and I learned some new tips and tricks along the way. Thanks for sharing your expertise, Kenji!"
Is this written by ChatGPT?
@@saukashObviously😁😁
Honestly all these are mindblowing. As a guy thats been using excel for my new position for about 1 year now and so many steps are tedious knowing i can implement some of these lessons is a gift from the excel gods 😂
I really needed the magic in 9:46 😊
Thank you so much Kenji. This is very useful and Amazing Video.
This was amazing! I just got hired as a programmatic specialist and this helps so much 😩
Thank you Kenji! This is very useful information.
Great videos! Anyone have a system for recording and/or remembering these so they are easier to recall and use? I've taken lots of excel classes but remembering everything is a challenge.
Thanks Kenji, you are always adding value .Thanks
Thank you kenji learning excel is not confusing anymore.I am new subscriber
Love from India 🇮🇳
Great lesson Kenji, very well presented and simply explained
Thank you so much. It was really helpful. Best :)
well... you need a bit more than these functions but your title is a very good HOOK !
I really appreciate your videos! I was wondering if you could use a drop down menu instead of typing the month or data in those dynamic formulas. Fabulous videos. They are very helpful with my college assignments. I plan to watch all of videos. Thank you for sharing your dynamic talents and skills with us! Ciao!
Certainly, by using data validation.
Thanks a lot dear Kenji for your great work. If possible make a video about NPV and IRR with detailed examples. God bless you.
Great video! I utilize most of these for my work and love them all. I didn't know about Large and Small so thank you!
Hi Kenji, great videos you are making! Love to watch.. in this Excel vid with your #1 to find your result maybe an easier formula to use is by using twice the XLOOKUP function? like =XLOOKUP(B14,B3:B11,XLOOKUP(C14,C2:J2,C3:J11))
Nested lookups are not always a good idea and I would only really want to use them in very specific sceanrios.
@@Cydia0 I use nested lookups too when looking for two criteria, would like to know why Index-Match is superior/preferred.
@@CP-zb3kyI think the index match match is just easier than two lookups. It’s just personal preference
@@willcarroll9762 I prefer two xlookups, but understand people are animals of old habits, also for older window users xlookup isn't available to them.
You don't even have to use two xlookups but just use & in both lookup values and lookup array and it should give you the same result as Index Match.
A great video as always.
I have just one question!
How do you know the exact excel tool to use when you are being given a problem?
Experience
5:24 I get an error when I use this formula, it gives me a number value. I followed you step by step
Many new formulas that I didnt know about! Very interesting!
Great to have your video , that is exactly what I am looking for, thank you so much.
kevin you beauty. best thing is you always include practice file..
Nicely done. Thanks!
Your videos are awesome. Thank you so much
some very nice tricks not only in this video but ur other videos too
Great video! Very Well Explained. Can you please show how to automate some report used for Analyst and Financial role. It will be greatly appreciated.
Great job
Is there a formula to inclune axes of a chart. I need to plot on axes with an angle ie not vertical and horizontal.
Thanks
Best excel class ever
Thank u. It's really helpful and not even an analyst ❤
Thanks. You made my life easier.
super powerful kenji 💥💫 keep going
Ang galing ma try sa office hehehe
Hi, very great info , im realy stuck to calculate the sales for each sales person everyday of this month . it is around 1000 tall column can you help
Great Video. In your example of using the large function at 6:50 in how would I pull the top 5 results in column C along with the names that go with the result from column B so it shows both in column F and G. Also my source table is on another work sheet in the same work book. Thanks
Thank you for this great video tutorial.Edate was used to specify a sequence of dates by month, what can be use for the days or years pls .thanks
Hi Kenji, do you think index match and xlookup are much the same?
Hi Kenji. Thanks! For me the best is the last one: Index + Match, but the other is good as well:)
Index and match is now the xlookup formula I believe...way more user friendly
I'm watching this vlog always
Sir,"Textjoin" is also a better function instead of "and" function -if we had more cells to join in case of Country, City example-Trust this Learn with Kenji sir is always value +++ added
Indexmatch formula is amazing. Thanks 😊
Indirect function is very useful too.
Kenji, you rock! Thank you.
Thank you, Kenji!
Your videos are so very hopefull, thanks! I just cant understand how are you choosing the correct cells for the function using the arrows? whenever i start typing a function i cant move bewtween cells..
dude you're the best, totally time saving!
Glad I could help!
thanks for explaining
very insightful, thanks
Very useful 👌 Thanks for the information
Thanks for this useful information
Sir can we use data validation in here?
This is pretty interesting to learn while in my business stats 1 class
Those Templates are pretty
Love your videos, thank you!!!
Awesome video! I have a question. I resolved it. I can share my Excel spreadsheet with you. However, I want to find a more straightforward formula. I have a spreadsheet with several TABs. In TAB 1, the general info, sales order, original date, expiration date, how much is still open, etc. In the TAB 2 I have a Database with details of each item in each sales order (sales order / item / Quantity / price / etc.) I want to click the sales order from TAB 1 (general info) and go to TAB 2 (sales order details) and point it. Not sure if I was clear...
Can you do a video explaining excel advance absolute,relative and mix reference?
On the Filter formula should you have it as => for the criteria in case something matches the amount being searched?
Hi, actually, the first example: Profit margin is calculated by taking the GROSS PROFIT and this is divided by REVENUE, not the other ay around. Other than that perfect video! :) You are wonderful!
As someone on Excel 2019, I’m infinitely envious of the xlookup function (but not enough to subscribe to 365 lol)
Love love love KENJIE
Fantastic!!!!!!!!!!!
Concise and informative
I like sequence with date function.
Thank you so much.
Really amazing videos !!!
this was great thank you!
You are a gift Kenji! Thanks
Hi Kenjie! Can you tell me if only free template available just for one video or I could get for others as well? 🙏
this is beautiful thank you
very useful - thanks
Thank you for sharing Doris The Coder!!!
Great Video!
So we can use either xlookup or index match since both are returns the same right????
Very helpful 👌
I had no idea that edate even existed! Thanks!!!
Mark
Awesome Mark thanks for watching!
Hi,
Thank you for taking time to enlighten the masses.
However, i encountered one problem as i tried to practice. My excel could not bring formulas like xlookup, sequence, filter, etc after typing = and the first 2 or 3 letters. When i type 'filter', it brings 'filterxml' instead. What could be the problem?
the problem is that you use a version of excel that does not support those functions at the moment. You can look up online how to solve it.
Nice, thanks Kenji.
thank you kenji
Hey! Please help me. How can I validation some column that's will show always in metric ton.
great ! very useful, tks !
Great Thanks
nice one,learnt alot
Thank you for the video. I'm preparing a teaching program where I need excel to calculate each letter "A" (section A, B or C) as a number and do the total sum of "A"s as numbers?
Good job! Great video.
I like this guy👍🏾
Subtotal formula very handy
How do you do the EDATE in weeks or days?
Indirect nested in index-xmatch is also pretty useful
wow nice thank you🥰
I I don't know what I'm doing wrong. My sequence looks like yours =SEQUENCE(50,,DATE(2023,1,1),7) I added the 0s but every time i hit enter they disappear.
I really like that you include a spreadsheet that we can download and do with you. I'm having a hard time remembering what function, etc to use when.
Thanks for this video