Hey Kenji, love your contents. A few questions though. 1. How do people reach out to you? 2. Your courses are very practical. Can you please get audited and get some sort of credit on your courses? So that when the user gets your certification it gets recognized? Or you think it is not necessary? Cheers.
Currently watching you Excel for Business and Finance playlist to prepare for my internship at BofA in a few weeks! Thank you Kenji for providing knowledge like this for free while I'm in college!
you don't need to write concatenate, you could have used just the expression inside brackets =D3&" "&E3. Both work but when dealing with complex models, shorter formulas always help for auditing the model. Keep up the great work! I didn't know about the unique formula nor the camera function in your quick access video, great stuff! ;)
From my perspective the most useful formuals are IF, VLOOKUP, INDEX&MATCH, SUMIF/SUMIFS and IFERROR :). Afterwards cube formulas referring to data model, if some more advanced stuff needs to be done, maybe also unpivot function in power query. There never was time during work with excel when these things weren't enough to solve the issue (obviously things like find&replace, clear formatting, remove duplicates, conditional formatting and text to columns are sometimes required as well). Xlookup - I've never found practical use for, it was always easier to go with index&match or sumif...
Hey Kenji! Thanks for the great video! You covered a lot of great formulas and I wanted to know where you learned them if possible. Thanks again for the great videos!
The concatenate example is probably over kill ... you can drop the entire function and just do the exact same thing with =D3&" "&E3 ... the '&' alone signify concatenate i.e. A&B = concatenate(a,b)
thanks for this video. i think there’s a better way to make header and to fill the data in SUMIFS session. You can use transform combined with unique function to make the header, and using hashtag to fill the data. that way you only insert functions in 3 cells, and the table will expand automatically as the number of regions grow.
Thanks Kenji! Those shortkeys for different functions using CTRL + "" (such as formatting a line under or above the cell, entering a cell etc.) - could you possibly do a video on the most important shortcuts? :)
Thank you so much for this video Sir Kenji! I'm a graduating student next year, right now I'm building up my Excel skills. This eill really boost drastically my Excel skillset. 🤗✨💖
I'm new to this and so I'm struggling to understand your accent. But what's even more troubling is the spreadsheet Part 2 came with a couple errors when I get to the date 3/2/2022. I don't know what the numbers are supposed to be. When I tried working to your suggestion, my answers don't match yours.
Hi Kenji, thank you once again, however, I do have one question, during the selection of range and for giving absolute selection we are inserting a $ sign, not able to populate same by advised short cut I am doing it manually. any advice?
When I put in =TODAY() in the "choose date" for part 2 it's saying that it doesnt match the data validation restrictions for the cell (I guess because today's date is well beyond the reach of the data range in the column?)
Do you have a course or video explaining how to build a financial/fiscal sales comparison that is based on a Monday through Sunday week? My Fiscal year began on Monday, 12/26/2022. That was day 1, period 1, quarter 1 of year 2023. Building reporting based on a retail calendar like this is extremely difficult and I can find no help anywhere on the web. Excel doesn't support fiscal calendars in pivot tables. Thank you.
Hi kanji, your videos are amazing, I enjoy them very much indeed. I am just comment here to see if you could explain a bit thorough regarding to the formula SUMIF, because I tried to do the same as you shown in the video and what comes up was a warning saying (”you’ve entered too many arguments for this function”) don’t understand why is that. If you could explain that to me that would be fab.
Hi Kenji, I am currently a workforce specialist with at least 4 months of experienced and I know I still lack experienced especially in excel that we are using on our daily driver. Can you recommend me the course for "Excel for Business and Finance"?
Hey Christopher, if you're looking to improve your excel skills, especially for a real-world environment I think it makes sense! (I'm obviously biased though, as I (and some other colleagues) made the course :)
Hey Kenji, I would like to thank you so much for making such incredible videos for us; it has helped me a ton! However, I have a question- at 2:25, when you used 'SUMIFS,' you got the correct answer; I tried using the XLOOKUP and INDEX MATCH, but excel is throwing me an error. I have double-checked my referencing but still can't get to the answer. Can you please help me understand why it's not working with XLOOKUP and INDEX MATCH?
That's because you actually need the sum of the quantity, xlookup does not get you the sum only the corresponding value and since there are multiple similar values in the data for eg Iphone 11 is repeated it'll show an error. I think that is the reason.
Hi, I’m new to Excel and I was wondering if someone can help. I want to know how to create a formula that will subtract whatever number I enter into a cell, from two different cells. For example; In cell A1, let’s say I have the number 10, and in cell B1, I have the number 10. When I enter a number in cell C1, I want it to subtract from cell A1 and B1. The number I enter in cell C1 could be any number. Thank you!
Hi kenji unrelated to this vid but u mentioned in your previous vids that u interned at Marriot International. Did u intern at the Marriot International inc. office or at a hotel owned by Marriot? If the latter is the case, on ur internship certificate/recommendation, did it say Marriot International or just the hotel's name? Cuz I currently have an internship offer with the Westin (under Marriott International) and I'm not sure if i should pursue the offer or not. If i do intern there, can i say i interned @ Marriott International? E.g. is the below ok for my resume? Xyz Intern Marriott International (the Westin, xyz resort)
Hey it was a hotel managed by Marriott, not the Marriott offices. My contract was with Marriott International, that's why I Marriott International as the header. For the title I just put my position and the hotel name.
I love your videos but I wish they were slower. you go so fast. I get lost. If you took it a bit slower you would be so much better to follow as we work.
Dude can you please speak a little bit slowly. Slowing down the video makes it too slow and as a biggner, the normanl video is a bit fast for me. Thaxx
👉 Use my link bit.ly/KenjiExplainsMTMar22 and code KENJI15 to get 15% off MeisterTask PRO or Business and align your team like never before!
Hey Kenji, love your contents. A few questions though.
1. How do people reach out to you?
2. Your courses are very practical. Can you please get audited and get some sort of credit on your courses? So that when the user gets your certification it gets recognized? Or you think it is not necessary?
Cheers.
Bro how to know when to use xlookup, vlookup or sumifs?
Currently watching you Excel for Business and Finance playlist to prepare for my internship at BofA in a few weeks! Thank you Kenji for providing knowledge like this for free while I'm in college!
you don't need to write concatenate, you could have used just the expression inside brackets =D3&" "&E3. Both work but when dealing with complex models, shorter formulas always help for auditing the model. Keep up the great work! I didn't know about the unique formula nor the camera function in your quick access video, great stuff! ;)
From my perspective the most useful formuals are IF, VLOOKUP, INDEX&MATCH, SUMIF/SUMIFS and IFERROR :). Afterwards cube formulas referring to data model, if some more advanced stuff needs to be done, maybe also unpivot function in power query. There never was time during work with excel when these things weren't enough to solve the issue (obviously things like find&replace, clear formatting, remove duplicates, conditional formatting and text to columns are sometimes required as well).
Xlookup - I've never found practical use for, it was always easier to go with index&match or sumif...
My new favorite youtuber. I am using all of this stuff from now on!
Yesss love to hear it! 🙌
Great illustration, thank you Kenji
Thank you so much for this! I am about to take a little Excel test for a job and this was very helpful for it.
how do you find ur work?
Hey Kenji! Thanks for the great video! You covered a lot of great formulas and I wanted to know where you learned them if possible. Thanks again for the great videos!
Thanks! I was a teaching assistant at university mainly teaching Excel so I learned most of them from that actually
Your videos are super powerful. Don't just stop. Keep it up.
thank you so much! That's the plan :)
Your uploading these with perfect timing, I’ve been trying to learn all these excel function in the past week
Great to hear!
Wow, concatenate is actually very useful
Thank you Kenji for the shortcuts and Xlookup formula. Please elaborate the use of Xlookup too.
These excel videos are really interesting. Thank you very much
The concatenate example is probably over kill ... you can drop the entire function and just do the exact same thing with =D3&" "&E3 ... the '&' alone signify concatenate i.e. A&B = concatenate(a,b)
thanks for this video. i think there’s a better way to make header and to fill the data in SUMIFS session. You can use transform combined with unique function to make the header, and using hashtag to fill the data. that way you only insert functions in 3 cells, and the table will expand automatically as the number of regions grow.
No dejo de ver tus videos. He aprendido mucho en estos últimos días. GRAN CONTENIDO. Saludos desde México
Muchas gracias José, un saludo!
Thank you Kenji
Thanks Kenji! Those shortkeys for different functions using CTRL + "" (such as formatting a line under or above the cell, entering a cell etc.) - could you possibly do a video on the most important shortcuts? :)
he already uploaded a video regarding excel shortcuts
noted!
Great Job! This was really good
To the point! Most useful finance videos on yt after Shkreli's finance streams, great job!
Thank you!
Very useful video, thank you so much for teaching us.
Cool explanation Kenji, thanks for sharing!
Excellent video
thanks so much!
Very nice tips!! Thanks Kenji
Could you do a video on the new function of excel Lambda?
Excellent work great 👍 help👍
Thank you so much for this video Sir Kenji!
I'm a graduating student next year, right now I'm building up my Excel skills. This eill really boost drastically my Excel skillset. 🤗✨💖
Thanks for watching and good luck with your final year!
Love your Content
Thank you!
We can use index match instead of xlookup.....
Anyway great content....
Great video - good coverage on some fundamental excel exercises!
Many thanks!
Awesome video, thanks for the explanations
This is a fantastic video🎉
Kenji, your content is so great, keep it up!!!
thx Kenji again
Cheers!
thank youu😊
Great video as always! Thanks Kenji
Glad you enjoyed it!
amazing video
Ah, control shift down...takes me back
Informative 👌🙏
Thank you very much!! 😁
You're welcome!
What will us Accounting & Finance experts do without Excel lol. Nice Video Kenji
I'm new to this and so I'm struggling to understand your accent. But what's even more troubling is the spreadsheet Part 2 came with a couple errors when I get to the date 3/2/2022. I don't know what the numbers are supposed to be. When I tried working to your suggestion, my answers don't match yours.
The entire section on SumIf could have been accomplished by leveraging a pivot table in much less time.
Let's see Paul Allen's pivot table.
Hi Kenji, thank you once again, however, I do have one question, during the selection of range and for giving absolute selection we are inserting a $ sign, not able to populate same by advised short cut I am doing it manually. any advice?
V nicely explained
Thank you so much 🙂
Bro how u guys so good on this. Im fuckup
First half can be done with a pivot table
Great Chanel ✌️
Glad you enjoy it!
When I put in =TODAY() in the "choose date" for part 2 it's saying that it doesnt match the data validation restrictions for the cell (I guess because today's date is well beyond the reach of the data range in the column?)
Amazing
Hi kenji, do you have tutorial on MS Access, to build simple databases for financial information?
Please can you create aging report for warehouse
Do you have a course or video explaining how to build a financial/fiscal sales comparison that is based on a Monday through Sunday week? My Fiscal year began on Monday, 12/26/2022. That was day 1, period 1, quarter 1 of year 2023. Building reporting based on a retail calendar like this is extremely difficult and I can find no help anywhere on the web. Excel doesn't support fiscal calendars in pivot tables. Thank you.
Hi Kenji, I am not able to access those excell worksheets by using the link for download. How should I do that ?
Nice, but what is the point of using so many different formulas to create this table, when you can do it in couple of seconds with PivotTable?
The greatest
Can someone explain why it's necessary to press the F4 key while completing the SUMIFS formula? What is it doing?
Nice..!
Man, I’m going to have to watch this video a million times because I have no idea what to lock and what not to lock
Please can you send me the link to download the data you used for the tutorial.
I can see how a windows OS can really be efficient for using MS office with all those alt key shortcuts that my Mac doesn't utilise
Yeah sorry i cant make a video that works for both!
Is the red book behind the intelligent investor ?
Hi kanji, your videos are amazing, I enjoy them very much indeed.
I am just comment here to see if you could explain a bit thorough regarding to the formula SUMIF, because I tried to do the same as you shown in the video and what comes up was a warning saying (”you’ve entered too many arguments for this function”) don’t understand why is that. If you could explain that to me that would be fab.
you should type SUMIFS to take multiple arguments not sumif
Hey, Where and how did you gain your excel
Skills. Did you take classes, learn from RUclips etc??
Hey, mix of university, at work, and the internet!
Excel creates pivote tables for you
Can we get a Mac version of these any time soon???
not able to access free excel file....its something else there
My excel does not have the Unique Function tho. What other formula can I use which can do the similar function?
plz tell where is this excel sheet available for practice
What version of excel are you working with. The unique and =TODAY function doesn't work on mine...smh. It's time for an upgrade.
Hello, If I don't have Xlookup formula what is the substitute of it?
#MY STRENGTH'S
-Mininum Client Face
-Long Planning
-Analysis
-Logic
-Strategy
-Organized
Which Job Is Best For Me ?
😊
Can't seem to download the practice excel file.....
Unique formula is not appearing on my excel. How do I apply it?
Standard Deviation.
Hey Kenji, curious, what do you use to edit and put together you videos? They look great!
premiere pro!
what to do if anyone don't have Xlookup fn in the excel? Please reply Thanks
Hi Kenji, I am currently a workforce specialist with at least 4 months of experienced and I know I still lack experienced especially in excel that we are using on our daily driver. Can you recommend me the course for "Excel for Business and Finance"?
Hey Christopher, if you're looking to improve your excel skills, especially for a real-world environment I think it makes sense! (I'm obviously biased though, as I (and some other colleagues) made the course :)
Thank you Kenji, I'll consider this and saved to buy this your course. I live in philippines by the well, do you have other students live in here too?
When you work in marketing, you basically live inside Excel… my bread & butter! 😁
Hey Kenji, I would like to thank you so much for making such incredible videos for us; it has helped me a ton! However, I have a question- at 2:25, when you used 'SUMIFS,' you got the correct answer; I tried using the XLOOKUP and INDEX MATCH, but excel is throwing me an error. I have double-checked my referencing but still can't get to the answer. Can you please help me understand why it's not working with XLOOKUP and INDEX MATCH?
That's because you actually need the sum of the quantity, xlookup does not get you the sum only the corresponding value and since there are multiple similar values in the data for eg Iphone 11 is repeated it'll show an error. I think that is the reason.
Thanks Kenji, one question: why the "UNIQUE" function is not available in my excel?
Could be because you have an older version?
Please share me this sample excell file for practice
i am getting value error even when i apply the formula just the way you did. any suggestions to fix it.
you need to press tab not " ( "or just have the formula on all caps
The first part could’ve easily be done by using/inserting a pivot table
I used office 2016. It seems not all Microsoft office have this formulas .
Hi,
I’m new to Excel and I was wondering if someone can help. I want to know how to create a formula that will subtract whatever number I enter into a cell, from two different cells. For example; In cell A1, let’s say I have the number 10, and in cell B1, I have the number 10. When I enter a number in cell C1, I want it to subtract from cell A1 and B1. The number I enter in cell C1 could be any number.
Thank you!
=A1-b1
u just do "=A1-B1"
How can I download the data
Hi kenji unrelated to this vid but u mentioned in your previous vids that u interned at Marriot International. Did u intern at the Marriot International inc. office or at a hotel owned by Marriot? If the latter is the case, on ur internship certificate/recommendation, did it say Marriot International or just the hotel's name? Cuz I currently have an internship offer with the Westin (under Marriott International) and I'm not sure if i should pursue the offer or not. If i do intern there, can i say i interned @ Marriott International?
E.g. is the below ok for my resume?
Xyz Intern
Marriott International (the Westin, xyz resort)
Hey it was a hotel managed by Marriott, not the Marriott offices. My contract was with Marriott International, that's why I Marriott International as the header. For the title I just put my position and the hotel name.
Unable to download excel free one
COULDN'T DO THE SAME SHOWN IN 4.01 TO 4.05.
Bro transpose function doesn't works like u mentioned in the video
The entire section about sorting product by region could've been done in 2 seconds with a pivot table
i can't use unique syntax
hi sir every thing oki except music we cant hear good from we are Arabic nationality .thank you go head
I love your videos but I wish they were slower. you go so fast. I get lost. If you took it a bit slower you would be so much better to follow as we work.
you can slow it down yourself in the settings just adjust the playback speed
❤
My excel does not have the UNIQUE formula
Bruh just insert a pivot table
You’re 12. What business/finance roles have had?
Dude can you please speak a little bit slowly. Slowing down the video makes it too slow and as a biggner, the normanl video is a bit fast for me. Thaxx