Excel Formulas YOU NEED for Business & Finance Roles

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

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!

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

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

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

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.

Great illustration, thank you Kenji

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

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!

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

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

Cool explanation Kenji, thanks for sharing!

These excel videos are really interesting. Thank you very much

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

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

Thank you Kenji

Awesome video, thanks for the explanations

Great video - good coverage on some fundamental excel exercises!

Great video as always! Thanks 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.