Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Andrew Lokenauth | TheFinanceNewsletter.com Profile picture
@FluentInFinance
Apr 13, 2023 • 13 tweets • 5 min read • Read on X
Scrolly
I've used Microsoft Excel for 20 years and these 10 tips will make you an expert & increase your productivity 100X

Don't use Excel again without learning these 10 functions:
Top 10 MUST KNOW Microsoft Excel tips & functions:

(1) XLOOKUP
(2) Sparklines
(3) Importing PDF data
(4) IF Statements
(5) TRIM
(6) UPPER, LOWER, and PROPER
(7) Wildcards
(8) CONVERT
(9) Transpose
(10) Pivot Tables

Examples of each:
(1) XLOOKUP

XLookup is an upgrade compared to VLOOKUP or Index & Match. Use it to perform both VLOOKUP or HLOOKUP.

Formula: =XLOOKUP (lookup value, lookup array, return array) Image
(2) Sparklines

Sparklines are mini charts inside of cells, to provide visual representations of data.

Sparklines can show trends or patterns in data, and are useful for summary tables.

On the 'Insert tab', click 'Sparklines' Image
(3) Importing PDF data

This automates the process of manually typing data from a PDF into an Excel spreadsheet. This function saves hours! Image
(4) IF Statements

IF Statements make logical comparisons & tell you when certain conditions are met.

For example, a logical comparison would be to return the word "Pass" if a score is >70, and if not, it will say "Fail".

An example of this would be =IF(C5>70,"Pass","Fail") Image
(5) TRIM

TRIM is useful in removing irregular spacing from imported data, or removing extra spaces in data.

Formula: =TRIM() Image
(6) UPPER, LOWER, and PROPER

=UPPER, Converts text to all uppercase,
=LOWER, Converts text string to lowercase,
=PROPER, Converts text to proper case. Image
(7) Wildcards

Wildcards are special characters that allow you to perform partial matches in lookup formulas. Excel has three wildcards:

(1) an asterisk "*"
(2) a question mark "?"
(3) a tidle "~" Image
(8) CONVERT

This converts one unit of measurement to another unit, and there are multiple other conversions you can perform.

An example is converting meters to feet, or Celsius to Fahrenheit. Image
(9) Transpose

Transpose can transform data displayed in rows, to instead be shown in columns, or vice versa

To transpose a column to a row (or vice versa):

1. Select the data
2. Select the cell you want the row to start
3. Right-click, choose paste special, select transpose Image
(10) Pivot Tables

Pivot tables are a powerful tool to summarize & analyze data, which will help you to compare data or find patterns & trends.

To access this function, go to "Insert" in the Menu bar, and then select "Pivot Table". Image
Microsoft Excel is a must-have skill in today's job market. If you found this thread helpful, please:

• RT the FIRST tweet to share it🔁
• Follow me @FluentInFinance for more
• Sign-up for my FREE newsletter to learn more valuable skills: TheMoneyNewsletter.com!

• • •

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

Keep Current with Andrew Lokenauth | TheFinanceNewsletter.com

Andrew Lokenauth | TheFinanceNewsletter.com 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 @FluentInFinance

Andrew Lokenauth | TheFinanceNewsletter.com Profile picture
Mar 27
Roth IRAs can make you a tax-free millionaire.

But only 20% of Americans have one.

Here's everything you need to know about Roth IRAs:

(If you're in your 20s, I can't stress this enough)
How to Become a Tax-Free Millionaire:

Step 1: Open a Roth IRA with a trusted broker.

Step 2: Set up automatic contributions ($583 a month).

Step 3: Let your money grow over 30 years.

Step 4: Watch your savings become about $1.6 million tax-free.

Even if you start with a small amount, the power of compound interest will work for you.
What is a Roth IRA?

A Roth IRA is a special savings account for retirement.

You pay taxes on your money before you put it in.

The money grows and you can take it out later without paying more tax.

Unlike a 401(k), you open this account yourself. You choose where to open it.
Read 15 tweets
Andrew Lokenauth | TheFinanceNewsletter.com Profile picture
Mar 7
From age 20-30, learn these financial rules to become wealthy in your 40s and 50s:
• The 50/30/20 Rule

This simple rule helps you split your money in a balanced way:

50% goes to needs like rent, bills, and food

30% goes to wants like eating out and fun activities

20% goes to financial goals like paying off debt or saving
• The Rule of 72

Want to know how fast your money will grow? The Rule of 72 makes it simple.

Divide 72 by your interest rate to find out how many years it takes for your money to double.

If you earn 8% on your investments, your money doubles in 9 years (72 ÷ 8 = 9).
Read 14 tweets
Andrew Lokenauth | TheFinanceNewsletter.com Profile picture
Feb 14
Before age 40, you need to read these books:

1. Psychology of Money by Morgan Housel

Lessons:
• Money is More Than Numbers: Your habits, emotions, and past experiences shape how you handle money.
• Avoid Comparisons: Don't compare your financial journey to others. Focus on your own goals and progress.
• Plan for the Long Term: Think about money in decades, not days. Long-term planning leads to better decisions.Image
2. Millionaire Next Door by Thomas J. Stanley

Lessons:
• Millionaires Aren't Flashy: Most millionaires live simple lives and don't show off their wealth.
• Avoid Status Symbols: Don't waste money on fancy cars or big houses to impress others.
• Live Below Your Means: Wealth comes from spending less than you earn and saving the rest.Image
3. Simple Path to Wealth by JL Collins

Lessons:
• Ignore the Noise: Don't get distracted by daily market news. Focus on your long-term goals.
• Index Funds are Key: Invest in index funds for steady, long-term growth. They're easy and effective.
• Stay the Course: Don't panic when the market goes up and down. Stick to your plan.Image
Read 11 tweets
Andrew Lokenauth | TheFinanceNewsletter.com Profile picture
Feb 11
I'm 37.

If you're still in your 20's, I can't stress these money skills enough:
1. Negotiate everything. Salaries, bills, rent. Don't be afraid to ask. Never accept the first offer. A 5-minute ask can save thousands.

2. Your first job isn't your forever job. Never be afraid to job hop to find what you're good at and what pays you well. Your career will grow over time.
3. Protect your credit score at all costs. Your credit score affects loans, housing, and jobs. Pay bills on time, keep balances low, and check reports for errors.

4. Surround yourself with winners, they inspire you. Positive, driven people push you to achieve more. Choose friends wisely.
Read 19 tweets
Andrew Lokenauth | TheFinanceNewsletter.com Profile picture
Feb 3
President Trump says the pain from tariffs "will be worth the price."

But what does it mean for you?

I spent the evening analyzing it.

Here’s what you need to know:
1/Because of new tariffs, the average American family could pay about $1,245 more per year for everyday items.

This includes:

• Costlier furniture and home goods
• More expensive clothes and shoes
• Higher prices for cars and car parts
• Pricier groceries, especially fruits and vegetables
2/ Tariffs Will Affect Everyday Life:

1. Cars:

• Vehicle prices could rise due to integrated North American supply chains
• Auto parts costs would increase, affecting repair and maintenance expenses

2. Food:

• Furniture imports from China could see 10-25% price increases
• Electronics and household appliances would likely become more expensive
• Clothing and footwear prices could rise significantly

3. Consumer Goods:

• Avocado prices could increase as 90% come from Mexico
• Popular Mexican beer brands might see price hikes
• Canadian agricultural products, including frozen foods, would become more expensive
Read 9 tweets
Andrew Lokenauth | TheFinanceNewsletter.com Profile picture
Dec 27, 2024
If you own a business, you MUST understand accounting

You can't run a business without understanding your numbers

Here is everything you need to know:
1/ Accounting isn’t just about taxes or bookkeeping—it’s the language of business

At its core, accounting is based on “Accrual Accounting”

Accrual accounting shows the true financial health of a business by matching income with related expenses.
2/ Accrual Accounting

Most people think of accounting as balancing a checkbook—counting cash in and cash out (this is called Cash Accounting)

But real businesses use Accrual Accounting

Why?

Because it’s a more accurate way to measure actual profit by matching revenues and expenses in the same period

Here's a simple way to think about it:
Read 12 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!

Send Email!

:(