Top 10 Essential Excel Formulas for Analysts in 2024

Building wealth involves developing good habits like regularly putting money away in intervals for solid investments. Instead of trying to predict and prognosticate the stability of the market and precisely when the change is going to happen, a better strategy is simply having a portfolio that’s well prepared for any eventually, that’s how some folks' been averaging 150K every 7week these past 4months according to Bloomberg.

Thank you for sharing Doris The Coder!!!

Note: The Profit marhing % formula is = (Gross profit/revenue)

Correct it please!
And The concept of if error is fine!❤

I need to build tracker in excel of different information security tools deployment,which are delayed by vendor from proposed dates ,just need to show to boss through tracker. I have meeting every week with service provider but things are moving forward, please support in this regard

Hope You Will be doing well

Pls help to provide a formula To find the common hour at a specific site where cell availability has been below 98.0% for the last 3 days (from 07/09/2023 to 09/09/2023) within the given ranges

Thanks for this video

SEQUENCE function is not showing in Excel 2019. What do I do?

Very useful 👌 Thanks for the information

Can u please teach how to use Google USD exchange rates for other currencies as real time currency in costing in excel to convert In one go... Please

Why can't i be able to make SEQUENCE command? it shows 44940 value when i enter the said formula.

Thank you❤❤

The formulas downloaded, but could not open. 🤦

Thank you

For the SEQUENCE date skip when I use the DATE function it returns me a number 44927 for Jan 1st...how do I get it to print the date..what am I missing here?

COUNTIFS for counting Catrgorical columns

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

When I did the sequence for date, it gave me lists of numbers instead of dates

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

in what cases do you use index match instead of xlookup?

Thank you so much.

To calculate the gross profit margin percentage, you can use the following formula:

Gross Profit Margin = (Gross Profit / Revenue) * 100

Given the values you provided:
Total Revenue = 239,383
Gross Profit = 153,119

Now, let's plug these values into the formula:

Gross Profit Margin = (153,119 / 239,383) * 100

Now, perform the calculations:

Gross Profit Margin = (0.6395) * 100
Gross Profit Margin ≈ 63.95%

So, the gross profit margin percentage for your data is approximately 63.95%.

thanks for explaining

YOU ROCK!

Thank you

That was definitely rocket science for me 😂😂

Can you add graphs without hubspot? Does excel generate it?

super powerful kenji 💥💫 keep going

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

this is beautiful thank you

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.

Weighed averages.....ie SUMPRODUCT(array 1, array2)/SUM(array 2)

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!

Some of the explanations are poor

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 !

how can i get this excel sheet to practice pls?

You are a gift Kenji! Thanks

When I am using sequence formula, it is giving me spill error

I like sequence with date function.

May I ask how to use 3 arguments in an IfError formula or IF formula follow by IfError please?

You only need one formula if you are an Analyst now: C h a d G P T
--> going rogue bartender myself.

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

Why does he sound Indian 😅

Great Video!

Quite helpful

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