👉 Use my link bit.ly/KenjiExplainsMTMar22 and code KENJI15 to get 15% off MeisterTask PRO or Business and align your team like never before!
@sauleazyei6212 жыл бұрын
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.
@muntaza56222 жыл бұрын
Bro how to know when to use xlookup, vlookup or sumifs?
@devinmorton7390 Жыл бұрын
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!
@gusboy202 жыл бұрын
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! ;)
@Beneficiis2 жыл бұрын
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...
@Redsoxman9991 Жыл бұрын
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.
@fanprojfanproj30096 ай бұрын
how do you find ur work?
@tonyanderson60852 жыл бұрын
My new favorite youtuber. I am using all of this stuff from now on!
@KenjiExplains2 жыл бұрын
Yesss love to hear it! 🙌
@Luis-oc6ml2 жыл бұрын
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!
@KenjiExplains2 жыл бұрын
Thanks! I was a teaching assistant at university mainly teaching Excel so I learned most of them from that actually
@osolikandombi80697 ай бұрын
Great illustration, thank you Kenji
@devmodi64662 жыл бұрын
Your videos are super powerful. Don't just stop. Keep it up.
@KenjiExplains2 жыл бұрын
thank you so much! That's the plan :)
@dvdmarkable2 жыл бұрын
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.
@ashleygarvin71772 жыл бұрын
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)
@AnkitSingh-cb1gh2 жыл бұрын
Thank you Kenji for the shortcuts and Xlookup formula. Please elaborate the use of Xlookup too.
@ProdigyShard2 жыл бұрын
Your uploading these with perfect timing, I’ve been trying to learn all these excel function in the past week
@KenjiExplains2 жыл бұрын
Great to hear!
@frodewilkensen2 жыл бұрын
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? :)
@florianrec49132 жыл бұрын
he already uploaded a video regarding excel shortcuts
@KenjiExplains2 жыл бұрын
noted!
@i1234569876542 жыл бұрын
Wow, concatenate is actually very useful
@joseandrespena19202 жыл бұрын
No dejo de ver tus videos. He aprendido mucho en estos últimos días. GRAN CONTENIDO. Saludos desde México
@KenjiExplains2 жыл бұрын
Muchas gracias José, un saludo!
@SharronFortune-x7h Жыл бұрын
Great Job! This was really good
@vheisshu2 жыл бұрын
Thank you Kenji
@mrCetus2 жыл бұрын
These excel videos are really interesting. Thank you very much
@markbernardo51642 жыл бұрын
Very useful video, thank you so much for teaching us.
@lazzagoal962 жыл бұрын
Very nice tips!! Thanks Kenji Could you do a video on the new function of excel Lambda?
@joseernestosabatercalvet1810 Жыл бұрын
Cool explanation Kenji, thanks for sharing!
@mr.sophisticated.79512 жыл бұрын
We can use index match instead of xlookup..... Anyway great content....
@max-gl2si2 жыл бұрын
To the point! Most useful finance videos on yt after Shkreli's finance streams, great job!
@KenjiExplains2 жыл бұрын
Thank you!
@arauf9632 жыл бұрын
Excellent work great 👍 help👍
@datadrivenbusinessinsights Жыл бұрын
Excellent video
@raylensibanico55072 жыл бұрын
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. 🤗✨💖
@KenjiExplains2 жыл бұрын
Thanks for watching and good luck with your final year!
@michaelquach70462 жыл бұрын
Great video - good coverage on some fundamental excel exercises!
@KenjiExplains2 жыл бұрын
Many thanks!
@vmahdavi Жыл бұрын
thanks so much!
@RohitThakur-en7qw2 жыл бұрын
Love your Content
@KenjiExplains2 жыл бұрын
Thank you!
@leon.se33672 жыл бұрын
Awesome video, thanks for the explanations
@cfoleverage11252 жыл бұрын
What will us Accounting & Finance experts do without Excel lol. Nice Video Kenji
@cogwheelLearning2 жыл бұрын
This is a fantastic video🎉
@camlex63102 жыл бұрын
Great video as always! Thanks Kenji
@KenjiExplains2 жыл бұрын
Glad you enjoyed it!
@serlasco2 жыл бұрын
Kenji, your content is so great, keep it up!!!
@GraciaEdhyta Жыл бұрын
thank youu😊
@arpandoshi98782 жыл бұрын
Informative 👌🙏
@willzinner88132 жыл бұрын
thx Kenji again
@KenjiExplains2 жыл бұрын
Cheers!
@i1234569876542 жыл бұрын
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
@danielmwabila80642 жыл бұрын
Thank you very much!! 😁
@KenjiExplains2 жыл бұрын
You're welcome!
@hisokaamorou42112 жыл бұрын
amazing video
@giorgiastamadze1672 жыл бұрын
Great Chanel ✌️
@KenjiExplains2 жыл бұрын
Glad you enjoy it!
@muntaza56222 жыл бұрын
Bro how u guys so good on this. Im fuckup
@gurharkrishanbureau1872 жыл бұрын
V nicely explained
@KenjiExplains2 жыл бұрын
Thank you so much 🙂
@kaykay50812 жыл бұрын
Hey, Where and how did you gain your excel Skills. Did you take classes, learn from KZbin etc??
@KenjiExplains2 жыл бұрын
Hey, mix of university, at work, and the internet!
@ahmetcoskunca8968 Жыл бұрын
Hi Kenji, I am not able to access those excell worksheets by using the link for download. How should I do that ?
@Fr.VeniceLAI2 жыл бұрын
Nice..!
@GavinBull12 жыл бұрын
First half can be done with a pivot table
@mustafaraza15562 жыл бұрын
#MY STRENGTH'S -Mininum Client Face -Long Planning -Analysis -Logic -Strategy -Organized Which Job Is Best For Me ? 😊
@bakutamathew2441 Жыл бұрын
Amazing
@Thesasquatchsgt2 жыл бұрын
The entire section on SumIf could have been accomplished by leveraging a pivot table in much less time.
@Chironex_Fleckeri2 жыл бұрын
Let's see Paul Allen's pivot table.
@hasanmohammed22842 жыл бұрын
Please can you create aging report for warehouse
@TeriWhitaker Жыл бұрын
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.
@daviddaniel82 жыл бұрын
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.
@rahuliron16352 жыл бұрын
you should type SUMIFS to take multiple arguments not sumif
@micahsnow3466 ай бұрын
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?)
@mohittripathi40262 жыл бұрын
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?
@FrozenGravy2 жыл бұрын
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
@KenjiExplains2 жыл бұрын
Yeah sorry i cant make a video that works for both!
@eMKeaL2 жыл бұрын
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?
@alohagirrl Жыл бұрын
Can someone explain why it's necessary to press the F4 key while completing the SUMIFS formula? What is it doing?
@i1234569876542 жыл бұрын
Ah, control shift down...takes me back
@embererik71052 жыл бұрын
Hey Kenji, curious, what do you use to edit and put together you videos? They look great!
@KenjiExplains2 жыл бұрын
premiere pro!
@solomonbhandari-young41542 жыл бұрын
The greatest
@chq012 Жыл бұрын
Please can you send me the link to download the data you used for the tutorial.
@ericc98602 жыл бұрын
Hi kenji, do you have tutorial on MS Access, to build simple databases for financial information?
@paulpullia7840 Жыл бұрын
Excel creates pivote tables for you
@norayrhayruni26222 жыл бұрын
Is the red book behind the intelligent investor ?
@AI-sz2qm Жыл бұрын
Can we get a Mac version of these any time soon???
@michaelgyan-rz9jq Жыл бұрын
Standard Deviation.
@dexplorer20072 жыл бұрын
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.
@johnwatson3521 Жыл бұрын
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.
@Zovi-kanu Жыл бұрын
plz tell where is this excel sheet available for practice
@alexander1912972 жыл бұрын
When you work in marketing, you basically live inside Excel… my bread & butter! 😁
@christoperjohnsanopo20492 жыл бұрын
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"?
@KenjiExplains2 жыл бұрын
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 :)
@christoperjohnsanopo20492 жыл бұрын
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?
@Sewrk1ses29 күн бұрын
not able to access free excel file....its something else there
@sinb561 Жыл бұрын
My excel does not have the Unique Function tho. What other formula can I use which can do the similar function?
@ALIRAZA-gi6hc Жыл бұрын
Unique formula is not appearing on my excel. How do I apply it?
@naregbas462 жыл бұрын
Hello, If I don't have Xlookup formula what is the substitute of it?
@SportsNStocks2 жыл бұрын
Can't seem to download the practice excel file.....
@imsu07142 жыл бұрын
Thanks Kenji, one question: why the "UNIQUE" function is not available in my excel?
@KenjiExplains2 жыл бұрын
Could be because you have an older version?
@aditya2819502 жыл бұрын
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?
@Farmerjo0072 жыл бұрын
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.
@richardbeardsley37814 ай бұрын
i am getting value error even when i apply the formula just the way you did. any suggestions to fix it.
@RetroHZ3 ай бұрын
you need to press tab not " ( "or just have the formula on all caps
@brianhaj48452 жыл бұрын
The first part could’ve easily be done by using/inserting a pivot table
@KrishnaShah-hp7su2 жыл бұрын
what to do if anyone don't have Xlookup fn in the excel? Please reply Thanks
@haramishtiaq722 Жыл бұрын
Please share me this sample excell file for practice
@sujjiaa Жыл бұрын
Unable to download excel free one
@yohannaagbanaji8012 Жыл бұрын
I used office 2016. It seems not all Microsoft office have this formulas .
@jamesknight66302 жыл бұрын
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!
@sylvias51612 жыл бұрын
=A1-b1
@jamesbrown78852 жыл бұрын
u just do "=A1-B1"
@tigeryt6372 жыл бұрын
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)
@KenjiExplains2 жыл бұрын
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.
@peternelson942 жыл бұрын
How can I download the data
@hafizhmaulana6494 Жыл бұрын
i can't use unique syntax
@ganapathic8510 Жыл бұрын
Bro transpose function doesn't works like u mentioned in the video
@sanjanarahman8933 Жыл бұрын
COULDN'T DO THE SAME SHOWN IN 4.01 TO 4.05.
@Gofaw2 жыл бұрын
The entire section about sorting product by region could've been done in 2 seconds with a pivot table
@jessicamatias1130 Жыл бұрын
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.
@juanramirez89668 ай бұрын
you can slow it down yourself in the settings just adjust the playback speed
@salmaalaa61582 жыл бұрын
hi sir every thing oki except music we cant hear good from we are Arabic nationality .thank you go head
@jayceedelajoga707 Жыл бұрын
❤
@G3MKnight2 жыл бұрын
My excel does not have the UNIQUE formula
@P_hillyАй бұрын
You’re 12. What business/finance roles have had?
@ABHINAVSINGH-jy3jz2 жыл бұрын
U moved too fast …difficult to understand…please go step by step for beginners like us …I know you are pro pro