I was a Senior Finance Manager at Microsoft from 2019 to 2021.

I built hundreds of complex financial models in Excel that helped close billion-dollar deals.

If you want to use Excel like a PRO, start by learning these 10 things:
1/ SUMIFS

Use it to add up values that meet one or two criteria.

In English:

SUMIFS(values you want to add, condition 1 range, condition 1)

Ex: Give me the total downloads for each podcast.
2/ XLOOKUP

Use it to search for a value in a column and return the corresponding value from another column.

In English:

XLOOKUP(value to find, column to look in, what do you want to get, what to do if not found)

Ex: Give me the total downloads on June 19, 2022.
3/ SUBTOTAL

Use it to add up values in a column but excludes anything that is filtered away.

In English:

SUBTOTAL(SUM[you have to type '9'], column you want to add up)

Ex: Give me the total downloads when I exclude the On Purpose podcast.
4/ IFERROR

Use it to stop showing error messages such as #N/A or #DIV/0! in your file.

In English:

IFERROR(your formula, error message to show)

Ex: Give me the ratio of 5 star ratings to 1 star ratings.
5/ Conditional formatting

Use it to highlight important values that need to stand out in your dataset.

In English:

• Select column
• Go to Home > Conditional formatting > New rule

Ex: Highlight in green if total downloads in a given day were higher than 7,000.
6/ Data validation

Use it to avoid mistakes in data input. Create a drop-down list with the options you want.

In English:

• Create a list
• Select the column
• Data > Data validation
• Allow > List > Select list > OK

Ex: Give your 1 to 5 rating to each podcast
7/ Pivot tables

Use it to summarize large amounts of data into tables.

In English:

• Select table
• Insert > Pivot table > OK
• Drag the fields into rows, columns, and values

Ex: Create a table that summarizes each podcast with total downloads per month.
8/ Transpose

Use it to reorganize your data from columns to rows, or vice versa.

In English:

• Select table > Copy it
• Paste > Transpose

Ex. Reorganize the data so that the months are the columns.
9/ Slicers

Use it to filter your data by clicking a button.

In English:

• Select table
• Inser > Slicer
• Select the field you want

Ex: Create a slicer that lets you filter out each podcast.
10/ Goal seek

Use it to find the value needed to yield a desired outcome.

In English:

• Data > What if analysis > Goal Seek
• Select set cell > input desired value
• Select cell that needs to change to yield desired outcome

Ex: Give me the grade needed to get a 92 average.
TL;DR

10 tips to become an Excel PRO

• Conditional formatting
• Data validation
• Pivot tables
• SUBTOTAL
• Transpose
• XLOOKUP
• Goal seek
• IFERROR
• SUMIFS
• Slicers
I hope you enjoyed reading this thread.

If you learned something valuable today:

1. Follow me @theantonioreza for more
2. RT the first tweet so more people can learn

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Antonio Reza

Antonio Reza Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @theantonioreza

Dec 8
Starting a business is scary.

You work 16 hours a day because you don't know what you're doing.

I wish I had a list of guiding principles when I started mine.

So, I made one.

Here's 15 lessons on entrepreneurship I wish I knew 13 years ago:
1| Know why your business exists

You need to answer 3 key questions to succeed:

1. What problem are you trying to solve?
2. How does your product help solve this problem?
3. Why are you the right person to lead the business?

If you can't answer one of those, you're lost.
2| Your customer is your boss.

Focus your attention on the people who buy from you.

Not only on what they say they want but on what they could need in the future.

Make it your mission to provide the most frictionless and helpful customer experience.
Read 18 tweets
Dec 5
I'm 35 ...

Here are 20 things I wish someone would have told me in my 20s:
1. Forgive your parents.

Holding grudges against the people that brought you to life can rob you of inner peace.

Let it go.

They are also human. Mistakes are inevitable.

Assume they had good intentions and promise yourself you won't repeat the story with your children.
2. To your company, you're nothing but a number on a spreadsheet.

The company's profits will always come first.

You are disposable.

Learn from 1000s of people being laid off right now.

Do your best from 9-5, but don't kill yourself over the company.

They sure won't for you.
Read 23 tweets
Nov 29
10 websites to start and grow your business (while saving you thousands of dollars):
1| Create a website that converts traffic into leads

leadpages.com

Use high-quality templates optimized to convert clicks into sales.

It's mostly "drag and drop" and integrates with tools like Calendly and Google Analytics.

Save money on website designers.
2| Find out what your customers are searching for

answerthepublic.com

Discover what your target audience is asking about and optimize SEO.

Use the keywords in your content and social media presence to increase traffic.

Save money on market research.
Read 13 tweets
Nov 22
Choosing Netflix over books won't get you very far in life.

Here are 12 books that will elevate your IQ and business acumen in 2023:
Elon Musk by Ashlee Vance

If you're on Twitter, educate yourself about its owner. Don't let the media determine what you think. Read this biography and make a judgment call.

Interesting highlights:
• Fornicating mice led to Mars misison
• Tesla became faster than Ferrari
The Everything Store by Brad Stone

If you're into business, take a deep dive into how Amazon became one of the largest companies to ever exist.

Interesting highlights:
• From PowerPoint to memos
• Two-pizza teams only
Read 15 tweets
Nov 18
I'm a Head of Finance at Google.

I've interviewed 100s of candidates in my career and I know my decision within the first 7 minutes.

Do these 5 things to prepare for the interview and I guarantee you'll impress recruiters and hiring managers at your dream company:
1.1 Polish your resume

Make your life easy and use this template.

This one-pager got me hired at GE, Microsoft, and Google.

Make sure you:

• Give context on all your roles
• Quantify your accomplishments
• Use words in the job description

Make it hard to pass on. Image
2.1 Research the company

Study their company website and social media channels to understand the latest trends.

• Are they investing in something new?

• Are they acquiring another business?

• What are their values?

• Are they being sued?
Read 18 tweets
Nov 14
Young men: don't be afraid of marriage. Embrace it.

My wife and I just celebrated 10 years. That decade has taught me more about happiness and self-growth than a high-powered corporate career.

Here are 15 pieces of advice to start the most important journey of your life:
1. Make her laugh. All the time.

Develop this superpower and she will always love you.

There's nothing better than bursting out in laughter after a rough day.

This keeps you young at heart and makes you yearn for each other's company every single day.
2. Listen to what's on her mind.

Many thoughts will keep her up at night.

Work, family, health, aspirations, money, and others.

It's your job to be the on-call therapist and more.

Don't judge. Just listen. Give her your best advice, and try to find a solution together.
Read 18 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(