Excel Formulas YOU NEED for Business & Finance Roles

[@KenjiExplains]

👉 Use my link bit.ly/KenjiExplainsMTMar22 and code KENJI15 to get 15% off MeisterTask PRO or Business and align your team like never before!

[@sauleazyei621]

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.

[@muntaza5622]

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!

[@gusboy20]

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! ;)

[@Beneficiis]

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.

[@fanprojfanproj3009]

how do you find ur work?

[@tonyanderson6085]

My new favorite youtuber. I am using all of this stuff from now on!

[@KenjiExplains]

Yesss love to hear it! 🙌

[@Luis-oc6ml]

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!

[@KenjiExplains]

Thanks! I was a teaching assistant at university mainly teaching Excel so I learned most of them from that actually

[@osolikandombi8069]

Great illustration, thank you Kenji

[@devmodi6466]

Your videos are super powerful. Don't just stop. Keep it up.

[@KenjiExplains]

thank you so much! That's the plan :)

[@dvdmarkable]

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.

[@ashleygarvin7177]

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-cb1gh]

Thank you Kenji for the shortcuts and Xlookup formula. Please elaborate the use of Xlookup too.

[@ProdigyShard]

Your uploading these with perfect timing, I’ve been trying to learn all these excel function in the past week

[@KenjiExplains]

Great to hear!

[@frodewilkensen]

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? :)

[@florianrec4913]

he already uploaded a video regarding excel shortcuts

[@KenjiExplains]

noted!

[@i123456987654]

Wow, concatenate is actually very useful

[@joseandrespena1920]

No dejo de ver tus videos. He aprendido mucho en estos últimos días. GRAN CONTENIDO. Saludos desde México

[@KenjiExplains]

Muchas gracias José, un saludo!

[@SharronFortune-x7h]

Great Job! This was really good

[@vheisshu]

Thank you Kenji

[@mrCetus]

These excel videos are really interesting. Thank you very much

[@markbernardo5164]

Very useful video, thank you so much for teaching us.

[@lazzagoal96]

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.7951]

We can use index match instead of xlookup..... Anyway great content....

[@max-gl2si]

To the point! Most useful finance videos on yt after Shkreli's finance streams, great job!

[@KenjiExplains]

Thank you!

[@arauf963]

Excellent work great 👍 help👍

[@datadrivenbusinessinsights]

Excellent video

[@raylensibanico5507]

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. 🤗✨💖

[@KenjiExplains]

Thanks for watching and good luck with your final year!

[@michaelquach7046]

Great video - good coverage on some fundamental excel exercises!

[@KenjiExplains]

Many thanks!

[@vmahdavi]

thanks so much!

[@RohitThakur-en7qw]

Love your Content

[@KenjiExplains]

Thank you!

[@leon.se3367]

Awesome video, thanks for the explanations

[@cfoleverage1125]

What will us Accounting & Finance experts do without Excel lol. Nice Video Kenji

[@cogwheelLearning]

This is a fantastic video🎉

[@camlex6310]

Great video as always! Thanks Kenji

[@KenjiExplains]

Glad you enjoyed it!

[@serlasco]

Kenji, your content is so great, keep it up!!!

[@GraciaEdhyta]

thank youu😊

[@arpandoshi9878]

Informative 👌🙏

[@willzinner8813]

thx Kenji again

[@KenjiExplains]

Cheers!

[@i123456987654]

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

[@danielmwabila8064]

Thank you very much!! 😁

[@KenjiExplains]

You're welcome!

[@hisokaamorou4211]

amazing video

[@giorgiastamadze167]

Great Chanel ✌️

[@KenjiExplains]

Glad you enjoy it!

[@muntaza5622]

Bro how u guys so good on this. Im fuckup

[@gurharkrishanbureau187]

V nicely explained

[@KenjiExplains]

Thank you so much 🙂

[@kaykay5081]

Hey, Where and how did you gain your excel Skills. Did you take classes, learn from KZbin etc??

[@KenjiExplains]

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.VeniceLAI]

Nice..!

[@GavinBull1]

First half can be done with a pivot table

[@mustafaraza1556]

#MY STRENGTH'S -Mininum Client Face -Long Planning -Analysis -Logic -Strategy -Organized Which Job Is Best For Me ? 😊

[@bakutamathew2441]

Amazing

[@Thesasquatchsgt]

The entire section on SumIf could have been accomplished by leveraging a pivot table in much less time.

[@Chironex_Fleckeri]

Let's see Paul Allen's pivot table.

[@hasanmohammed2284]

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.

[@daviddaniel8]

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.

[@rahuliron1635]

you should type SUMIFS to take multiple arguments not sumif

[@micahsnow346]

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?)

[@mohittripathi4026]

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?

[@FrozenGravy]

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

[@KenjiExplains]

Yeah sorry i cant make a video that works for both!

[@eMKeaL]

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?

[@i123456987654]

Ah, control shift down...takes me back

[@embererik7105]

Hey Kenji, curious, what do you use to edit and put together you videos? They look great!

[@KenjiExplains]

premiere pro!

[@solomonbhandari-young4154]

The greatest

[@chq012]

Please can you send me the link to download the data you used for the tutorial.

[@ericc9860]

Hi kenji, do you have tutorial on MS Access, to build simple databases for financial information?

[@paulpullia7840]

Excel creates pivote tables for you

[@norayrhayruni2622]

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.

[@dexplorer2007]

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

[@alexander191297]

When you work in marketing, you basically live inside Excel… my bread & butter! 😁

[@christoperjohnsanopo2049]

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"?

[@KenjiExplains]

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 :)

[@christoperjohnsanopo2049]

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?

[@Sewrk1ses]

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?

[@naregbas46]

Hello, If I don't have Xlookup formula what is the substitute of it?

[@SportsNStocks]

Can't seem to download the practice excel file.....

[@imsu0714]

Thanks Kenji, one question: why the "UNIQUE" function is not available in my excel?

[@KenjiExplains]

Could be because you have an older version?

[@aditya281950]

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?

[@Farmerjo007]

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.

[@richardbeardsley3781]

i am getting value error even when i apply the formula just the way you did. any suggestions to fix it.

[@RetroHZ]

you need to press tab not " ( "or just have the formula on all caps

[@brianhaj4845]

The first part could’ve easily be done by using/inserting a pivot table

[@KrishnaShah-hp7su]

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 .

[@jamesknight6630]

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!

[@sylvias5161]

=A1-b1

[@jamesbrown7885]

u just do "=A1-B1"

[@tigeryt637]

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)

[@KenjiExplains]

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.

[@peternelson94]

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.

[@Gofaw]

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.

[@juanramirez8966]

you can slow it down yourself in the settings just adjust the playback speed

[@salmaalaa6158]

hi sir every thing oki except music we cant hear good from we are Arabic nationality .thank you go head

[@jayceedelajoga707]

❤

[@G3MKnight]

My excel does not have the UNIQUE formula

[@P_hilly]

You’re 12. What business/finance roles have had?

[@ABHINAVSINGH-jy3jz]

U moved too fast …difficult to understand…please go step by step for beginners like us …I know you are pro pro

[@footfott]

Bruh just insert a pivot table