I heard about people talking behind my back:

It reminded me of a quote from Dale Carnegie:

"no one every kicks a dead dog... and the more important the dog, the more satisfaction people get in kicking him".

The act of kicking helps the kicker feel significant.

99% of the time it means you are doing something great.

Many people find terrible pleasure in disparaging those who are more successful than they are.

The next time someone is talking sh*t...
...take it as a compliment in disguise.

No one ever kicks a dead dog.

6 Excel features that will blow your mind:

1. Data Types (DT)

Spare yourself the google search and let Excel search for you using DT. DT pull real-time data into Excel. To convert text strings into linked DT, just select the data category under the data tab. Now, simply select the attributes you want to pull into Excel.

2. Flash Fill (FF)

Say goodbye to writing complex functions to manipulate data, and hello to FF. FF automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will auto-fill the pattern down the column!

3. Power Query (PQ)

Teleport data into Excel using PQ. PQ is a powerful tool that imports data from various sources (the web, PDFs, CSVs, etc.) into Excel. Instead of copying data from the web, just go to the Data tab > From Web > enter URL > Select the data table and hit load.

4. AutoSum (AS)

Summing data in Excel can be tedious, but not with AS! AS automatically detects data in adjacent cells and sums it using the SUM function. To use AS, select an empty cell adjacent to the data that needs to be summed and simply press ALT =.

From age 20-49, do these mistakes and never regret...

1. Spend 70% of your time alone

Life is not all about honey, butter and bread.

You'll become a weakling the more you spend time with people.

Do this instead;

• Spend time alone
• Work on yourself
• Guard your energy

2. Move from parents

Don't abandon them but if you want to be self-sufficient,

(Especially in a society without elaborate lites of passage to strengthen you)

Then you should move and build your safety nets.

There are moments when family can't help you.

3. Go against common beliefs

Common is comfortable and it's considered easy.

99% of the times it'll never serve you.

Question what there is and know what works for you.

4. Quit taking medicine

Unless it's a life threatening illness or some necessary antibiotics.

You can stay healthy with;

• The right diet
• Exercise
• Water
• Work
• Sun
• Sex

You don't always need medicine.

Most millionaires invest in stocks

But they don't teach you how to research companies in school

So let me break it down for you

Using the strategy of the most successful fund manager of all time:

Mr. Peter Lynch managed the Magellan fund, averaging a 29% yearly return

This makes him the most successful fund manager of all time.

He strongly believes that anyone has the ability to outperform the market

Here's an insight into his own, winning research strategy...

First, Mr. Lynch categorises the stock he's researching to determine if it's a:

- Slow Grower ($PFE, $WMT)
- Stalwart ($KO $PG)
- Cyclical ($GM $AAL)
- Fast Grower ($MELI $TSLA)
- Turnaround ($FCAU $F)
- Asset Play ($MCD)

For each, there are differing factors to consider...

For all of the above, there are general fundamentals & stats to look at
These are:

- PE ratio: is it high or low for this company & for similar companies in the industry
- % of institutional ownership: The lower the better
- % of insiders buying: The higher the better

Cont...

- Record of earnings growth: are they consistent or sporadic (less important for asset plays)
- Balance sheet strength: debt to equity ratio
- Cash position: Cash per share, is there a floor price?

Once you've checked these out, check the following for the specific category...

6 books to help you become the disciplined person you want to be:

1. Can’t Hurt Me by David Goggins

Lessons:

- Your mind will tell you “you’re done”, you’re not.
- Build a “cookie jar” and use it when times get tough

2. The Compound Effect by Darren Hardy

Lessons:

- Routines are crucial for momentum
- Small smart choices + consistency + time = radical difference

3. Mastery by Robert Greene

Lessons:

- Follow your calling / your purpose
- Lean into the resistance and let go of comfort

4. The War of Art by Steven Pressfield

Lessons:

- The hardest part is starting
- Act like a professional - do the work regardless

By age 30, you need to master these money skills if you want to be 10 years ahead financially.

• Network with people

Your ability to succeed and find opportunities can depend on the people that you know.

Spend time with ambitious people who have a desire to grow.

You'll gain a lot of knowledge and always strive to improve yourself.

• Avoid lifestyle creep

With social media, people want to be seen as affluent.

The reality is that many are in huge debt and cannot repay it.

Focus on important things, live below your means, and invest your money.

Financial freedom is more important than possessions.

• Become marketable

The pay you receive is proportional to the talent you provide.

Acquiring new skills increases your earning potential.

More skills mean more money and more assets to invest.

Developing a competitive advantage in life is necessary.

• Pay yourself first

Save or invest money before splurging on wants.

Investing is a way to pay for your freedom with money earned today.

To make investing simple and easy, set up automatic investments.

Start out modestly and build up as you see fit.

How to invest in US stocks?

• Online Brokers
• Taxation
• Yearly Limits
• Online research sites for US stocks

A thread 🧵. Please retweet for maximum reach.

What are some platforms that allow opening a US investment account?

- Groww
- Interactive Brokers
- Vested
- many others

You may like to read reviews online before opening an account with any provider.

Is there a statutory limit on investment?

As Indian resident, RBI’s Liberalized Remittance Scheme lets you remit upto $250,000 per year, per person. Above that, permission from RBI is required.

What are the capital gains tax on foreign stocks?

- US doesn't tax capital gains for us. However, tax applicable in India.

LTCG:- applicable if held above 24 months. Taxed @20% with indexation benefit
STCG:- if held for less than 24 months, Taxed at your income tax slab rate

What is the tax on dividends earned?

- Dividends taxed at flat 25% in US
- Also taxable at your income tax slab rate in India
- As per Double Tax Avoidance Agreement, tax withheld in US offsets tax liability in India

So tax to you is 25% or your tax rate, which ever is higher

You don't need to pay someone $2,000 or even $200 to update your Linkedin Profile.

This thread will show you how...for Free.

Here's My 5-Part System For Turning Your Linkedin Profile Into A Business Growth Machine:

Thread 🧵

1. Profile Photos

Pictures say a thousand words.

Make your photos speak for you.

Your profile photo should:

1. Match your audience
2. Build Trust
3. Show Personality

Here’s how:

Match your audience:

- If they wear a suit, you do too
- If they wear a t-shirt, you do too

Build trust by:

- Showing your face
- Smiling
- Clear imagery

Show personality through:

- Hobbies
- Family candids
- Action shots

Look at these:

2. Cover Photo

Your cover photo should follow the same principles as your profile photo.

Great Cover photos do 3 things.

1. Match your audience
2. Show Personality
3. Pitch or show credibility

We've already covered the first two...

But how can you show credibility?

Social proof is key to building trust with people when they land on your profile.

Show them:

- Some awards you've won
- You speaking at live events
- Publications you've written

Make sure your cover photo is clear & easy to read.

Here's a tip...

Excel has 100s of functions. Most them are not useful in day to day business setting. Here are the 10 most useful functions based on my 15 years of regular usage.
🧵

1) SUMIFS
Use it to add up values that meet one or more conditions.
=SUMIFS(A1:A100, B1:B100, "NZ", C1:C100, ">20") adds up all values in A1:A100 where column B is NZ and column C is more than 20.

2) XLOOKUP*
Use it to lookup a value and get corresponding value.
=XLOOKUP("Widget10", A1:A100, B1:B100)
looks the code Widget10 in column A and returns the price in column B.
* Works in Excel 365 / Web only

3) FILTER*
Use it to filter a list or range based on the conditions. Returns a range of values and automatically spills the values into next cells!
=FILTER(A1:C100, B1:B100="NZ")
returns the entire range of A1:C100 where column B has NZ.

4) COUNTIFS
Use it to count items that meet one or more criteria.
=COUNTIFS(B1:B100, "NZ", C1:C100, ">20")
tells us how many items have column B as NZ and column C more than 20.

In JUST 6 months, you can transform yourself to a superhuman, here how...

1. Fix your schedule and sleep at 9:00 PM to be awake at 4:00 AM

2. Quit your excuses and work out for 30 minutes daily

3. Include 2 eggs plus fresh fruits in your daily dieting to optimize your health.

4. Prioritize 2 cold showers a day with no excuses. I promise your self discipline will be boosted.

A 2-minutes read that'll help you build unbreakable discipline and consistency than you've been in the last 5 years.

1. Set clear goals

Take a pen and a paper, sit somewhere quiet and write;

• What you want to achieve
• How to achieve it
• Time it'll take for actualization

Let the goal you set be;

• Achievable
• Challenging
• Updatable
• Measurable

2. Set sustainable morning routine

Make your first 3 hours in the morning set the tone of the day

Start your day early to win your day

Be awake by 4:00 or 5:00 and;

• Set on a 20 minutes walk
• Take a quick cold shower
• Read and write for 1 hour

Reinforce these habits for 30 days and you'll eliminate brain fog and boost your focus

3. Set priorities in order

When you have many priorities, then you have prioritized nothing

The end goal will only make you ineffective and tired

Consistency demands focus

In this Thread, We will cover all important Patterns.

Retweet 🇮🇳 Like ♥️ Follow 📊

Tags:
@kuttrapali26 @caniravkaria
@Jagadeesh0203 @KommawarSwapnil

Open this Thread 🧵

1. Descending Triangle

a. Bounded by two trend lines; the lower is horizontal and the upper slopes downward.

b. Prices can break in either direction but most commonly downward.

2. Ascending Triangle

a. Bounded by a horizontal upper trend line and an upward sloping lower trend line. Each bound is a straight trend line.

b. Prices can break in either direction, but more commonly upward.

3. Head & Shoulders

a. Three peaks with center peak higher than the other two.

b. Shoulders should be at approximately the same level and the head higher.

c. Target is the distance from the head to the neckline projected from the neckline.

4. Inverse Head & Shoulders

a. Inverted but otherwise identical to above pattern.

This took me 11 years to learn, I'll teach you in 3 minutes. Here are 18 uncomfortable truths about life that'll put you 5 years ahead...

1. You’ll never have more than what you've worked for. Quit complaining and work harder.

2. You'll never be presented with challenges you can't overcome. You either want solutions too fast or are too lazy to fight.

3. No matter how old or good you are. Misfortunes can always strike.

4. Loyalty doesn't cost a dime. Give it to the deserving.

8 straightforward quotes on self-care:

1.

2.

3.

4.

5.

In 2 minutes, I'll give you 13 tips for beating procrastination...

1. Forgive yourself for procrastinating in the past.

2. Minimize distractions in your environment. Put down the phone and get to work.

3. Keep a to-do list and put it in order of priority.

4. Create a timeline with specific deadlines to accomplish tasks.

Master Excel for FREE with these resources 📈

A thread 🧵👇🏻

1.

2.

3.

4.

How to detect and call out Bullsh*t on the spot.

A complete guide.

Have you ever dreamed of knowing if the person in front of you was bluffing?

The word "bluff" immediately brings poker to mind.

It is one of the most interesting applications of bluffing.

That's what makes this game so exciting from a psychological point of view.

I will use poker as an illustration throughout this thread.

But it doesn't matter if you don't play it.

What I'm about to show you can be applied to many other situations.

Let's get to it.

In poker, once you understand the rules of the game and start to have some experience, you try to bluff and unmask the bluff.

Only, people do it badly:

They observe the gaze of other players, we observe their fingers, they observe the slightest blink of the eyes….

They then draw hasty and wrong conclusions.

Why do people do this?

Because the TV and the psycho-morbid books explain it that way.

However, that's is a very bad way to go.

10 rules that you must follow to change your life:

1.

2.

3.

4.

5.

Must know free tools for Startups:

@NotionHQ —Notes
@WriteSonic —Writing blogs
@canva —Graphics
@make_hq —Automation
@gumroad —Selling
@beehiiv —Newsletter
@testimonialto —Testimonials
@wotnot_io —Chatbot
@copy_ai —Writing copy
@TheQuillBot —Repharser
@loom —Video

10X output!