KZhead

Top 10 Essential Excel Formulas for Analysts in 2024

Kenji Explains
2024 ж. 20 Мам.
737 694 Рет қаралды
Жүктеу

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 KZhead Channel: / @careerprinciples
📸 Instagram - instagram.com/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.

Пікірлер

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

    @KenjiExplains@KenjiExplains Жыл бұрын

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

      @meeto4084@meeto4084 Жыл бұрын

    • 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

      @renvirsiasol3947@renvirsiasol3947 Жыл бұрын

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

      @mgangat@mgangat Жыл бұрын

    • That gives 64% 59% and 48%

      @beniria2179@beniria217911 ай бұрын

    • good job

      @abdullahiadamumaina2708@abdullahiadamumaina27085 ай бұрын

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

    @BibiMegaotaku@BibiMegaotaku2 ай бұрын

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

    @vishaljhaveri6176@vishaljhaveri61769 ай бұрын

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

    @user-ri7sw2wt6f@user-ri7sw2wt6f Жыл бұрын

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

    @stresslaxing.@stresslaxing. Жыл бұрын

  • Thanks Kenji, you are always adding value .Thanks

    @magdahassib8659@magdahassib8659 Жыл бұрын

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

    @Danielle_Scott@Danielle_Scott Жыл бұрын

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

    @Jenny-pc7ge@Jenny-pc7ge Жыл бұрын

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

    @_sonicfive@_sonicfive3 ай бұрын

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

    @BenDieselBasicAutomotive@BenDieselBasicAutomotive Жыл бұрын

  • Very useful 👌 Thanks for the information

    @bspraveen9364@bspraveen93648 ай бұрын

  • Thank you for sharing Doris The Coder!!!

    @kellysanesthesiatips1983@kellysanesthesiatips19837 ай бұрын

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

    @mindmywordsbymeghna.5325@mindmywordsbymeghna.5325 Жыл бұрын

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

    @ahsantheanalyst7199@ahsantheanalyst7199 Жыл бұрын

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

      @KenjiExplains@KenjiExplains Жыл бұрын

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

      @Mrdezmiki@Mrdezmiki Жыл бұрын

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

      @kartheek79@kartheek79 Жыл бұрын

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

      @ilocomocomediaentertainmen7425@ilocomocomediaentertainmen742510 ай бұрын

    • 1- cost/revenue will be handy

      @saravanakumar5656@saravanakumar56567 ай бұрын

  • Kenji, you rock! Thank you.

    @NatashaDiedricks@NatashaDiedricks Жыл бұрын

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

    @christopherleinweber5455@christopherleinweber545511 ай бұрын

  • Your videos are awesome. Thank you so much

    @franciabowen2496@franciabowen2496 Жыл бұрын

  • Thanks for these useful tips! Cheers!😁😁

    @andymarci6766@andymarci6766 Жыл бұрын

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

    @sheetgood@sheetgood Жыл бұрын

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

    @che7001@che700111 ай бұрын

    • Certainly, by using data validation.

      @imtghanabranch@imtghanabranch8 ай бұрын

  • Indirect nested in index-xmatch is also pretty useful

    @leesam3258@leesam3258 Жыл бұрын

  • 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

    @brianbarns8675@brianbarns86758 ай бұрын

  • You are a gift Kenji! Thanks

    @doristhecoder765@doristhecoder76511 ай бұрын

  • Thank you❤❤

    @camillegrajo1919@camillegrajo19199 ай бұрын

  • Thank you Kenji! This is very useful information.

    @LileeCuisia@LileeCuisiaАй бұрын

  • Thanks. You made my life easier.

    @faisalym@faisalym2 ай бұрын

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

    @nev0116@nev0116Ай бұрын

  • Thank you, Kenji!

    @Quinton-Baldwin@Quinton-Baldwin5 ай бұрын

  • Love your videos, thank you!!!

    @wilmaostman7537@wilmaostman75376 ай бұрын

  • Concise and informative

    @Kbira8960@Kbira89603 ай бұрын

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

    @rockj8197@rockj819711 ай бұрын

  • 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

    @susanitaq85@susanitaq85 Жыл бұрын

  • this is beautiful thank you

    @alblanquicett@alblanquicett11 ай бұрын

  • Thank you

    @emmapa3868@emmapa38689 ай бұрын

  • Agree. There are some basics formulas that you always use

    @XLLearner_Courses@XLLearner_Courses7 ай бұрын

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

    @rwfrench66GenX@rwfrench66GenX Жыл бұрын

  • Thanks Kenji

    @annieo.9887@annieo.9887 Жыл бұрын

  • this was great thank you!

    @charlenem6040@charlenem60402 ай бұрын

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

    @shahbazyandav82@shahbazyandav823 ай бұрын

  • Nicely done. Thanks!

    @junesechowski5932@junesechowski5932Ай бұрын

  • super powerful kenji 💥💫 keep going

    @muhammadrefaay1503@muhammadrefaay150311 ай бұрын

  • Thank you so much.

    @kennethmutai2967@kennethmutai296710 ай бұрын

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

    @giannisgrats883@giannisgrats8833 ай бұрын

  • Super useful!!

    @camlex6310@camlex6310 Жыл бұрын

  • Indexmatch formula is amazing. Thanks 😊

    @manpreetsagoo367@manpreetsagoo36719 күн бұрын

  • thanks for explaining

    @thusithadasanayaka4329@thusithadasanayaka432910 ай бұрын

  • Thank you 😊

    @sorosekaewmanee1845@sorosekaewmanee1845 Жыл бұрын

  • Good job! Great video.

    @nolimit7185@nolimit7185 Жыл бұрын

  • dude you're the best, totally time saving!

    @safakv60@safakv606 ай бұрын

    • Glad I could help!

      @KenjiExplains@KenjiExplains6 ай бұрын

  • Nice, thanks Kenji.

    @sarathrupasinghe6240@sarathrupasinghe6240 Жыл бұрын

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

    @swapnamali3860@swapnamali3860 Жыл бұрын

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

    @hectorrenemelendez@hectorrenemelendez Жыл бұрын

    • Is this written by ChatGPT?

      @saukash@saukash10 ай бұрын

    • @@saukashObviously😁😁

      @lukmanadamu5778@lukmanadamu57788 ай бұрын

  • Thank you.

    @questionresearch8721@questionresearch87213 ай бұрын

  • great ! very useful, tks !

    @xujason4607@xujason4607 Жыл бұрын

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

    @RexxorDDG@RexxorDDG3 ай бұрын

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

    @peterjarabek5541@peterjarabek5541 Жыл бұрын

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

      @camridgway3862@camridgway386225 күн бұрын

  • thank you kenji

    @Mark-gz9si@Mark-gz9si4 ай бұрын

  • very useful - thanks

    @hadiekhtiardar@hadiekhtiardar25 күн бұрын

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

    @michaellorman448@michaellorman448 Жыл бұрын

  • Great Thanks

    @kimsclub3860@kimsclub38607 ай бұрын

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

    @Stef1955@Stef1955 Жыл бұрын

    • Awesome Mark thanks for watching!

      @KenjiExplains@KenjiExplains Жыл бұрын

  • nice one,learnt alot

    @Mudianiel@Mudianiel Жыл бұрын

  • thanks brother

    @SMrahim113@SMrahim1133 ай бұрын

  • Thank u

    @3lw1@3lw1 Жыл бұрын

  • Thanks for this video

    @dakf660@dakf6608 ай бұрын

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

    @michaellawrence883@michaellawrence883 Жыл бұрын

    • Experience

      @psychofacto7212@psychofacto721211 ай бұрын

  • great tutorial

    @William_Webber@William_Webber Жыл бұрын

  • thank you

    @user-sy7vp4ld2o@user-sy7vp4ld2o Жыл бұрын

  • 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

    @MK-fq3fk@MK-fq3fkАй бұрын

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

    @hibaadnan9983@hibaadnan9983 Жыл бұрын

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

    @gergoadorjan4259@gergoadorjan42595 ай бұрын

  • 😊 Thanks

    @godknowsjeremiah440@godknowsjeremiah44021 күн бұрын

  • I got my job as a financial analyst. This helped so much, thank you from the bottom of my heart.

    @MetalBreakdown@MetalBreakdown11 ай бұрын

    • How much experience did you have when you applied? I'm wondering because I'm also looking for a job as a FA and dont have much experience :/

      @Kezinch99@Kezinch9911 ай бұрын

  • wow nice thank you🥰

    @nctzen-oe2sk@nctzen-oe2sk2 ай бұрын

  • Awesomeee!!

    @mehranbilesan4186@mehranbilesan4186 Жыл бұрын

  • Quite helpful

    @samanthadaroga4811@samanthadaroga4811 Жыл бұрын

  • Great Video!

    @user-xh8cr9pk5g@user-xh8cr9pk5g Жыл бұрын

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

    @tanweerabbasabbas649@tanweerabbasabbas6495 ай бұрын

  • Ang galing ma try sa office hehehe

    @jhonrayocampo7511@jhonrayocampo7511 Жыл бұрын

  • Simple ❤

    @shahenulkabir-fu2yq@shahenulkabir-fu2yq Жыл бұрын

  • Indirect function is very useful too.

    @doug1307@doug1307Ай бұрын

  • Amazing

    @solomonbhandari-young4154@solomonbhandari-young4154 Жыл бұрын

  • This is great

    @gjinro743@gjinro743 Жыл бұрын

  • Very useful

    @divya264@divya264Ай бұрын

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

    @tonysundellsweden@tonysundellsweden Жыл бұрын

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

    @ShIrEnZeR@ShIrEnZeR7 ай бұрын

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

    @nobogurus@nobogurus Жыл бұрын

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

    @m.w.6099@m.w.6099 Жыл бұрын

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

      @Cydia0@Cydia0 Жыл бұрын

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

      @CP-zb3ky@CP-zb3ky Жыл бұрын

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

      @willcarroll9762@willcarroll976211 ай бұрын

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

      @CP-zb3ky@CP-zb3ky11 ай бұрын

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

      @HarshitSingh-zo5mi@HarshitSingh-zo5mi10 ай бұрын

  • Sumifs with the wildcard is so cool. What do I do if I want to include a word but want to exclude it if the cell includes a combination of two certain words? For example I want to sum if the description includes Amazon but want to exclude it if the description includes both Amazon and Walmart?

    @toshiyo822@toshiyo822 Жыл бұрын

  • I use the IF formular a lot

    @DummyUrD@DummyUrD Жыл бұрын

  • I'm watching this vlog always

    @piobasartejr.7686@piobasartejr.7686 Жыл бұрын

  • Amazing Video

    @sherwinnaidoo8440@sherwinnaidoo8440 Жыл бұрын

  • excellent

    @muthukumar-wj6pk@muthukumar-wj6pk Жыл бұрын

  • What is a good way to compare two lists where the values are not in the same order?

    @charizard_baller69@charizard_baller69 Жыл бұрын

  • I like this guy👍🏾

    @seanolanrewaju9@seanolanrewaju9 Жыл бұрын

  • YOU ROCK!

    @debbietownsend1673@debbietownsend167310 ай бұрын

  • I really needed the magic in 9:46 😊

    @goosebumplane@goosebumplane Жыл бұрын

  • Kenji, I have tried and tried but I cant get my head around how the solver function works. Could you do a video on that?

    @Kirkland-rv5jf@Kirkland-rv5jf Жыл бұрын

  • I like sequence with date function.

    @sunilsomanath623@sunilsomanath62311 ай бұрын

  • Those Templates are pretty

    @sarahbee1115@sarahbee11153 ай бұрын
KZhead