Top 10 Essential Excel Formulas for Analysts in 2024

Learn the only Excel formulas you need as an Analyst in 2023 to get most things done.
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/y21
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/63ef84...
In this video we go over 10 excel formulas you need as a business analysts, financial analyst, or data analyst. The formulas are: iferror, concatenate, string functions (left, mid, right), filter, edit, sumifs, xlookup, large/small, sequence, and indexmatch.
The types of formulas covered include data cleaning functions, date & time functions, lookup functions, and sum functions.
LEARN:
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
🎬 My Company KZbin Channel: / @careerprinciples
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

[@KenjiExplains]

🚀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!

[@meeto4084]

Hey dude, I need your help at my excel sheet to get sum products

[@renvirsiasol3947]

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

[@mgangat]

Thanks so much for this very useful link and information. Your videos are very informative detailed and easy to understand. Thanks again👍

[@beniria2179]

That gives 64% 59% and 48%

[@abdullahiadamumaina2708]

good job

[@BibiMegaotaku]

I want this video to burn into my retina permanently, you're saving analyst lives out here man

[@user-ri7sw2wt6f]

All 10 are very good. I especially appreciated the 2nd example for the SUMIFS function.

[@vishaljhaveri6176]

LARGE and SMALL functions were new to me. Also I learnt the SUMIFS in a different manner. Thank you!

[@magdahassib8659]

Thanks Kenji, you are always adding value .Thanks

[@stresslaxing.]

Just Amazing. You are the GIFT who was given by youtube for us. Thanks for everything Kenji

[@Danielle_Scott]

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!

[@Jenny-pc7ge]

Great to have your video , that is exactly what I am looking for, thank you so much.

[@_sonicfive]

the =index(filter()) pattern works beautifully too.

[@mindmywordsbymeghna.5325]

Thank you kenji learning excel is not confusing anymore.I am new subscriber Love from India 🇮🇳

[@christopherleinweber5455]

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 !

[@BenDieselBasicAutomotive]

Thanks again, Professor.... More power....

[@franciabowen2496]

Your videos are awesome. Thank you so much

[@NatashaDiedricks]

Kenji, you rock! Thank you.

[@che7001]

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!

[@imtghanabranch]

Certainly, by using data validation.

[@LileeCuisia]

Thank you Kenji! This is very useful information.

[@bspraveen9364]

Very useful 👌 Thanks for the information

[@leesam3258]

Indirect nested in index-xmatch is also pretty useful

[@andymarci6766]

Thanks for these useful tips! Cheers!😁😁

[@doristhecoder765]

You are a gift Kenji! Thanks

[@shahbazyandav82]

Thanks a lot dear Kenji for your great work. If possible make a video about NPV and IRR with detailed examples. God bless you.

[@giannisgrats883]

Many new formulas that I didnt know about! Very interesting!

[@wilmaostman7537]

Love your videos, thank you!!!

[@nev0116]

This was amazing! I just got hired as a programmatic specialist and this helps so much 😩

[@charlenem6040]

this was great thank you!

[@faisalym]

Thanks. You made my life easier.

[@Quinton-Baldwin]

Thank you, Kenji!

[@junesechowski5932]

Nicely done. Thanks!

[@kellysanesthesiatips1983]

Thank you for sharing Doris The Coder!!!

[@alblanquicett]

this is beautiful thank you

[@XLLearner_Courses]

Agree. There are some basics formulas that you always use

[@muhammadrefaay1503]

super powerful kenji 💥💫 keep going

[@Kbira8960]

Concise and informative

[@susanitaq85]

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

[@camlex6310]

Super useful!!

[@kennethmutai2967]

Thank you so much.

[@nolimit7185]

Good job! Great video.

[@rockj8197]

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.

[@sheetgood]

Hey kenji, thanks for this video! for the Large and/or small function is there then a way to have an additional column with the Brand associated with the deal size? Essentially I would like to do something similar but, I don't care about the largest numbers, I care about the data associated with the largest numbers.

[@Mudianiel]

nice one,learnt alot

[@gergoadorjan4259]

well... you need a bit more than these functions but your title is a very good HOOK !

[@manpreetsagoo367]

Indexmatch formula is amazing. Thanks 😊

[@sarathrupasinghe6240]

Nice, thanks Kenji.

[@thusithadasanayaka4329]

thanks for explaining

[@camillegrajo1919]

Thank you❤❤

[@xujason4607]

great ! very useful, tks !

[@peterjarabek5541]

Hi Kenji. Thanks! For me the best is the last one: Index + Match, but the other is good as well:)

[@camridgway3862]

Index and match is now the xlookup formula I believe...way more user friendly

[@sorosekaewmanee1845]

Thank you 😊

[@annieo.9887]

Thanks Kenji

[@hadiekhtiardar]

very useful - thanks

[@emmapa3868]

Thank you

[@William_Webber]

great tutorial

[@RexxorDDG]

This is pretty interesting to learn while in my business stats 1 class

[@brianbarns8675]

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

[@tanweerabbasabbas649]

kevin you beauty. best thing is you always include practice file..

[@questionresearch8721]

Thank you.

[@nctzen-oe2sk]

wow nice thank you🥰

[@swapnamali3860]

Thanks for this useful information Sir can we use data validation in here?

[@user-xh8cr9pk5g]

Great Video!

[@Mark-gz9si]

thank you kenji

[@safakv60]

dude you're the best, totally time saving!

[@KenjiExplains]

Glad I could help!

[@kimsclub3860]

Great Thanks

[@SMrahim113]

thanks brother

[@samanthadaroga4811]

Quite helpful

[@Stef1955]

I had no idea that edate even existed! Thanks!!! Mark

[@KenjiExplains]

Awesome Mark thanks for watching!

[@sherwinnaidoo8440]

Amazing Video

[@doug1307]

Indirect function is very useful too.

[@divya264]

Very useful

[@3lw1]

Thank u

[@mehranbilesan4186]

Awesomeee!!

[@gjinro743]

This is great

[@user-sy7vp4ld2o]

thank you

[@m.w.6099]

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

[@Cydia0]

Nested lookups are not always a good idea and I would only really want to use them in very specific sceanrios.

[@CP-zb3ky]

@@Cydia0 I use nested lookups too when looking for two criteria, would like to know why Index-Match is superior/preferred.

[@willcarroll9762]

@@CP-zb3kyI think the index match match is just easier than two lookups. It’s just personal preference

[@CP-zb3ky]

@@willcarroll9762 I prefer two xlookups, but understand people are animals of old habits, also for older window users xlookup isn't available to them.

[@HarshitSingh-zo5mi]

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.

[@dominicburrows7317]

I am so so glad that I found this channel. Can you help with formula to compare 2 sheets or workbooks and highlight the data that's repeating or duplicate and then move that data to a different sheet. Also help on concatenate, vlookup and pivot will be great

[@nobogurus]

Can you show us please how to analyse livelihood coping strategies in excel, how to get percent of households in stress, crisis and emergency categories and the average for the region.

[@piobasartejr.7686]

I'm watching this vlog always

[@debbietownsend1673]

YOU ROCK!

[@seanolanrewaju9]

I like this guy👍🏾

[@michaellawrence883]

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?

[@psychofacto7212]

Experience

[@rwfrench66GenX]

On the Filter formula should you have it as => for the criteria in case something matches the amount being searched?

[@DummyUrD]

I use the IF formular a lot

[@hectorrenemelendez]

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

[@saukash]

Is this written by ChatGPT?

[@lukmanadamu5778]

@@saukashObviously😁😁

[@solomonbhandari-young4154]

Amazing

[@hibaadnan9983]

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?

[@mompreneurlife]

❤ nice video! A lot of people don’t use excel anymore however, I am a fan still excellent from your list. They’re very useful❤.

[@AlainW-xm1rh]

Hi there. What are they using instead?

[@ohdjrp4]

Hi, since when did those "lots of people" stop using Excel? and what they are using now?

[@AlainW-xm1rh]

@@ohdjrp4 Exactly... 😀

[@ggrocketleague9098]

Damn, I have the same question. Is there a better way?

[@AlainW-xm1rh]

@@ggrocketleague9098 Nah, this is somebody fishing for customers... :)

[@dakf660]

Thanks for this video

[@muthukumar-wj6pk]

excellent

[@tonysundellsweden]

Great stuff, thanks alot!! But..... how to get the Amount in FILTER formula? I can get the Country Name to show but don't get the amount displayed next to it.

[@sunilsomanath623]

I like sequence with date function.

[@michaellorman448]

Hi Kenjie! Can you tell me if only free template available just for one video or I could get for others as well? 🙏

[@goosebumplane]

I really needed the magic in 9:46 😊

[@godknowsjeremiah440]

😊 Thanks

[@MK-fq3fk]

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

[@sarahbee1115]

Those Templates are pretty

[@ShIrEnZeR]

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

[@PatrickWareham]

Can you do a video explaining excel advance absolute,relative and mix reference?

[@duncachinoahimiha3889]

As someone on Excel 2019, I’m infinitely envious of the xlookup function (but not enough to subscribe to 365 lol)

[@AmanGupta-ci1ik]

Could you please make a detail video on pivot table

[@ahsantheanalyst7199]

the first formula in this video is wrong :) Profit Margin %= (GP/Revenue) . Hope it helps. Overall the iferror concept is perfect .

[@KenjiExplains]

Hey you're right! Thanks for pointing it completely missed it :)

[@Mrdezmiki]

I like that he's human after all. More relatable and projects authenticity.

[@kartheek79]

Excel has fill function if we convert the data to table that can be used instead of string function

[@ilocomocomediaentertainmen7425]

Hi Kenji... Which of your course is best for data analysis? I am trying to switch career to data analytics

[@saravanakumar5656]

1- cost/revenue will be handy

[@PlasticGeordie]

I have found =UNIQUE to be useful for checking to help quickly see if a column may contain a repeated entry or not.

[@AdySimm]

For that you can use conditional formating.