Top 10 Essential Excel Formulas for Analysts in 2024

Подписаться 501 тыс.

Просмотров 740 тыс.

50% 1

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

Опубликовано:

22 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 261

@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 11 месяцев назад

That gives 64% 59% and 48%

@abdullahiadamumaina2708 5 месяцев назад

good job

@BibiMegaotaku 2 месяца назад

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

@vishaljhaveri6176 9 месяцев назад

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

@user-ri7sw2wt6f Год назад

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

@stresslaxing. Год назад

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

@magdahassib8659 Год назад

Thanks Kenji, you are always adding value .Thanks

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

@BenDieselBasicAutomotive Год назад

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

@christopherleinweber5455 11 месяцев назад

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 !

@doristhecoder765 11 месяцев назад

You are a gift Kenji! Thanks

@franciabowen2496 Год назад

Your videos are awesome. Thank you so much

@LileeCuisia Месяц назад

Thank you Kenji! This is very useful information.

@andymarci6766 Год назад

Thanks for these useful tips! Cheers!😁😁

@junesechowski5932 Месяц назад

Nicely done. Thanks!

@wilmaostman7537 6 месяцев назад

Love your videos, thank you!!!

@_sonicfive 3 месяца назад

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

@NatashaDiedricks Год назад

Kenji, you rock! Thank you.

@giannisgrats883 3 месяца назад

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

@bspraveen9364 8 месяцев назад

Very useful 👌 Thanks for the information

@charlenem6040 2 месяца назад

this was great thank you!

@mindmywordsbymeghna.5325 Год назад

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

@camlex6310 Год назад

Super useful!!

@manpreetsagoo367 21 день назад

Indexmatch formula is amazing. Thanks 😊

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

@faisalym 3 месяца назад

Thanks. You made my life easier.

@Quinton-Baldwin 5 месяцев назад

Thank you, Kenji!

@Kbira8960 3 месяца назад

Concise and informative

@kellysanesthesiatips1983 8 месяцев назад

Thank you for sharing Doris The Coder!!!

@hadiekhtiardar 26 дней назад

very useful - thanks

@nev0116 2 месяца назад

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

@alblanquicett 11 месяцев назад

this is beautiful thank you

@shahbazyandav82 3 месяца назад

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

@nolimit7185 Год назад

Good job! Great video.

@Mudianiel Год назад

nice one,learnt alot

@kennethmutai2967 10 месяцев назад

Thank you so much.

@sarathrupasinghe6240 Год назад

Nice, thanks Kenji.

@zhiqizhang4348 Месяц назад

Thank you

@xujason4607 Год назад

great ! very useful, tks !

@muhammadrefaay1503 11 месяцев назад

super powerful kenji 💥💫 keep going

@questionresearch8721 3 месяца назад

Thank you.

@leesam3258 Год назад

Indirect nested in index-xmatch is also pretty useful

@camillegrajo1919 9 месяцев назад

Thank you❤❤

@sorosekaewmanee1845 Год назад

Thank you 😊

@annieo.9887 Год назад

Thanks Kenji

@William_Webber Год назад

great tutorial

@che7001 11 месяцев назад

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 8 месяцев назад

Certainly, by using data validation.

@thusithadasanayaka4329 10 месяцев назад

thanks for explaining

@nctzen-oe2sk 2 месяца назад

wow nice thank you🥰

@RexxorDDG 3 месяца назад

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

@XLLearner_Courses 7 месяцев назад

Agree. There are some basics formulas that you always use

@divya264 Месяц назад

Very useful

@kimsclub3860 7 месяцев назад

Great Thanks

@user-xh8cr9pk5g Год назад

Great Video!

@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 10 месяцев назад

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

@saravanakumar5656 8 месяцев назад

1- cost/revenue will be handy

@Mark-gz9si 4 месяца назад

thank you kenji

@rockj8197 11 месяцев назад

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.

@SMrahim113 3 месяца назад

thanks brother

@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

@brianbarns8675 8 месяцев назад

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

@swapnamali3860 Год назад

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

@3lw1 Год назад

Thank u

@safakv60 6 месяцев назад

dude you're the best, totally time saving!

@KenjiExplains 6 месяцев назад

Glad I could help!

@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 10 месяцев назад

Is this written by ChatGPT?

@lukmanadamu5778 8 месяцев назад

@@saukashObviously😁😁

@mehranbilesan4186 Год назад

Awesomeee!!

@peterjarabek5541 Год назад

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

@camridgway3862 27 дней назад

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

@samanthadaroga4811 Год назад

Quite helpful

@godknowsjeremiah440 23 дня назад

😊 Thanks

@sherwinnaidoo8440 Год назад

Amazing Video

@rwfrench66GenX Год назад

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

@doug1307 Месяц назад

Indirect function is very useful too.

@user-sy7vp4ld2o Год назад

thank you

@gjinro743 Год назад

This is great

@debbietownsend1673 10 месяцев назад

YOU ROCK!

@solomonbhandari-young4154 Год назад

Amazing

@muthukumar-wj6pk Год назад

excellent

@gergoadorjan4259 5 месяцев назад

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

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

@michaellorman448 Год назад

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

@tanweerabbasabbas649 5 месяцев назад

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

@Stef1955 Год назад

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

@KenjiExplains Год назад

Awesome Mark thanks for watching!

@MetalBreakdown 11 месяцев назад

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

@Kezinch99 11 месяцев назад

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

@seanolanrewaju9 Год назад

I like this guy👍🏾

@DummyUrD Год назад

I use the IF formular a lot

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

@sarahbee1115 4 месяца назад

Those Templates are pretty

@user-qf6xc8rj1t 3 месяца назад

Hi Kenji, do you think index match and xlookup are much the same?

@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

@charizard_baller69 Год назад

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

@goosebumplane Год назад

I really needed the magic in 9:46 😊

@ShIrEnZeR 7 месяцев назад

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

@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 11 месяцев назад

Experience

@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

@toshiyo822 Год назад

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?

@piobasartejr.7686 Год назад

I'm watching this vlog always

@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 11 месяцев назад

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

@CP-zb3ky 11 месяцев назад

@@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 10 месяцев назад

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.

@dakf660 8 месяцев назад

Thanks for this video

@Kirkland-rv5jf Год назад

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?

@shahenulkabir-fu2yq Год назад

Simple ❤

@mbayediop1094 10 месяцев назад

For the Index Match example can't I just put =F10 rather than going through a whole process or can you show a more complex example where you have to use Index Match please Thanks