Thread
All business people use Microsoft Excel.

But not everyone can dedicate 40+ hours to learning it.

Here’s how Chat GPT can write the 10 formulas that will put you ahead of 90% of people:
This is the table that we will work on, so you can follow along.
1/ SUM

Sum is pretty simple if you've worked with Excel before.

If you haven't, no worries, go to Chat GPT and type the text in the photo.

This will give us the total annual salaries for the team.

=SUM(D2:D7)
2/ SUMIF

But what about calculating the sum of the salaries for people below 30?

We have a nice little formula for that, and Chat GPT will show us how to use it.

=SUMIF(B2:B7,"<30",D2:D7)
3/ AVERAGE

The next important formula you need to "know" is the average.

Again, go into GPT, write your question, and boom.

=AVERAGE(D2:D7)
4/ ROUND

If you've followed me, the above average salary will be 78966.66667.

You don't want to work with those kind of numbers.

So Chat GPT will tell you to use the ROUND function to get rid of them.

=ROUND(AVERAGE(D2:D7),0)
5/ RIGHT/LEFT

Now, let's go to some interesting stuff. We want to extract the first name from the "name" column.

If we try the first formula that GPT gives us, we will notice it's not correct.

Nobody's perfect.

Just use the second one, and it works.
6/ COUNTIF

Now we're getting into the serious stuff.

We want to filter when we calculate stuff.

For example, let's see how many people are over 30 on the team.

=COUNTIF(B2:B7,">30")
7/ Multiple IFs

But what if we want to filter more information? How would we do that?

Let's say you want to categorize the salaries into three categories: low, medium, and high.

=IF(D2<60000,"Low", IF(AND(D2>=60001,D2<=90000),"Medium", IF(D2>90000,"High","")))
8/ VLOOKUP and INDEX/MATCH

When we're talking advanced stuff, we're talking VLOOKUP and Index/Match.

This will help you get corresponding information, like someone's salary (especially useful when you have a very big table).

Both can help in most cases.
9/ NETWORKDAYS

Excel can quickly tell you how many working days there are in a certain month.

This is very useful if you're a manager who needs to plan and allocate resources.

It can also take into consideration any public holidays or other leave days.
10/ DATEDIF

Want to know how long it's been since someone got hired or received their latest promotion?

Chat GPT will successfully suggest the "DATEDIF" function, to calculate the difference between 2 moments in time.

It works for years, months, and days.
And this is what you should have in the end.
TL;DR: The 10 formulas that will put you ahead of 90% of people.

• IF
• SUM
• SUMIF
• ROUND
• DATEDIF
• COUNTIF
• AVERAGE
• VLOOKUP
• RIGHT/LEFT
• NETWORKDAYS
If you enjoyed this thread, please:

1. Follow me (@theleoalexandru) for more tips on Career Growth, Management, and Leadership.

2. Retweet the 1st tweet below to share this thread with your friends.

If you liked this, you'll love my Ultimate Productivity Guide.

Get it here: leoalexandru.ck.page/ultimate
Mentions
See All
  • Post
  • From Twitter
This is great!