These Excel formulas and tricks will save you hundreds of hours of work

If you use Microsoft Excel, here are some formulas and tricks that will save you hundreds of hours of work:
• MATCH & ISNUMBER

MATCH searches and returns the positions of the items in the range.

ISNUMBER determines whether a value is a number and returns True or False.

Because service, books, and dairy are true, they are the only ones on both lists.

• SEQUENCE & COUNTA

SEQUENCE returns a sequence of numbers in an array.

COUNTA counts the number of cells in a range that are not empty.

Combining the two formulas gives you a list with a sequence that continues to populate as you add information to it.

• TRIM

TRIM removes extra spaces from a text string, whether they are at the beginning, middle, or end.

In the example, we had text strings with a lot of spaces.

The spaces were removed when we used the function.

• Difference between lists

Steps:

1. Highlight both lists holding the ctrl key

2. From home, go to Conditional formatting>Highlight cells rules> Click duplicates

3. In the dialogue box, change from duplicate to unique

This displays items that are different.

• Flash Fill

Here, we create an email list.

Steps:

1. Type the data in the first two columns
2. Type Ctrl + E to populate the email list

This can be done for addresses, names, and other data that has the same information pattern.

• Remove duplicates

This allows you to remove duplicates for a specific set of data.

Steps:

1. Highlight the table> go to Data
2. Remove Duplicates
3. In the dialogue box, select the data that you want to remove.

• Delete Empty Cells

Steps:

1. Select the Data
2. Go to find & Select> Go to Special > Check Blanks
3. Right-click on one of the highlighted cells> Click Delete > Select shift cells left

This can be useful, especially when you have a big set of data.

• Populate information faster

Steps:

1. Select the data
2. Click F5 or go to special
3. In the dialogue box, click blank
4. Type the sign “=” in the top first empty cell
5. Select the region on top
6. Type Ctrl + Enter

• Quick tool Analysis

Simply select your table and an icon will appear in the bottom right corner.

This tool contains extremely useful information.

You can select charts, format them, perform calculations, and add sparklines.

This is unquestionably a useful tool.

• Analyze Data

Analyze data provides suggestions on how to analyze data in a variety of ways.

It also suggests pivot tables for you to create.

You also have the option to ask a question about the data that you have.

If you enjoyed this thread, please like, comment, and retweet the first tweet.

I write about

– Personal Finance
– Investing
– Wealth

Follow me @AccentInvesting for more tips.

Subscribe to receive a free guide on the top 5 ETFs to hold for life: https://wordpress.us5.list-manage.com/subscribe?u=72ef5ca4088a6ab26fc8e2fcb&id=fe976c00c9

Investing in index funds is the simplest way to build wealth.

Start your investing journey today: https://accentinvesting.gumroad.com/l/AccentInvesting

Follow: @AccentInvesting

[Via]
Fundraising Tips For Growth Stage Founders

This is how Dopamine addiction kills your productivity and causes poor performance

The modern world is destroying your brain

Dopamine addiction causes poor performance and cognitive impairment in professionals

If you’re a working professional and want to

✅ Fight brain fog
✅ Lack of focus
✅ Procrastination

This thread is your all inclusive playbook 🧵

Let’s get some facts right first..

Every time you spike your dopamine (from substances, porn, social media, or any habits)

There is an opposite, non proportional reaction which dips your dopamine below baseline.. (Opponent process theory)

Let me explain its relevance..

Think of it like a see-saw,

If you encounter a dopamine spike, one end of the see – saw is raised to the max height..

Now, when the weight drops (coming down from the high)

The see-saw doesn’t come back to the normal balanced stance..

Instead it goes below the normal..

What does this mean for your brain?

When you have dopamine below baseline,

– You have brain fog
– You cannot focus
_ You have no drive to work and perform
– You cannot work for long periods
– You are constantly craving more dopamine
– You need 10X more time to do something

Dopamine plays an important role in complex cognitive functions such as working memory, cognitive flexibility, language and thought, motor planning, abstract representation, temporal analysis etc

(Volkow et al., 1998; Previc, 1999; )

However..

The current lifestyle you live is one of excess stimulation.

Your reward pathways are constantly in overdrive and this is creating long lasting neuroplastic change in your frontal cortex

What does this mean?

If you indulge in an activity repeatedly,

The brain creates neural pathways to perform more efficiently

These pathways fire constantly and are very hard to dissolve

When you indulge in your habits, the addiction pathways you create keep you trapped in this loop of addiction..

How do you fight this?

You need to bring your dopamine back to baseline.

This is only possible through complete abstinence from dopamine spikes & redirection (controlled dopamine injection) via lifestyle changes

Now this concept is not new..

The best addiction treatment centers in the world use this habit breaking protocol..

You first abstain from dopamine spikes and quiet your mid brain (The part responsible for relapse)

Then you strengthen the frontal cortex with coping skills (FC responsible for willpower)

FYI, I use this very treatment modality in my coaching practise.

I help working professionals beat habits and heal their brain chemistry from dopamine abuse

You can apply to work with me here https://projectphalanx.co/

Guaranteed results or you don’t pay

Now how do you abstain without relapse?

You practice a pro – active systems based approach that is built on awareness.

I will tell you what I do with my clients and you can replicate in your life step by step..

First, initial mindset work to get them invested

Why?

3 things you need to transform your life..

1) Powerful emotional reason. The WHY
2) Systems. The HOW.
3) Accountability.

I help my clients walk through a series of exercises to better understand themselves and create that sense of intense desire for transformation..

Next..

Trigger identification & awareness training

Each time you spike dopamine you also release glutamate which creates addiction memories

It is this GLU memories that makes you relapse when you hit a trigger..

Ex, you watch a person smoke on TV and you get powerful cravings..

I sit down with my clients and we dissect their lives to list out every trigger they have encountered Or possibly will in the future

2 things happen next,

We train them on how to be aware at all times with some elite training protocols used in the military..

Simultaneously we build out systems for them.

Simple IF-THEN mechanisms like,, IF X happens deploy system Y.

Systems include several training regimens from cognitive therapy, mindfulness, addiction counselling, psychology, etc.

Then we begin implementation.

First we create routines to bring more structure into their lives.

Then employ the systems we built out.

Then introduce new progressive tasks each week to gradually create sustainable lifestyle changes

Never all at once. One step at a time.

How long does it take to heal your brain?

Depends on your condition.

With no lifestyle changes, likely a year.

But if you dedicate yourself and really make some changes like work out, meditation, breath work, cognitive training.. can happen as quickly as 12 weeks..

Practice abstinence and redirect your dopamine cravings onto healthy lifestyle choices.

You will see your life transform in a few months.

P.S, if you’re a working professional and want to

– Beat an addiction
– Build better habits & systems
– Heal your brain chemistry
– Transform your life

@ https://projectphalanx.co/ coaching program is all you need

Guaranteed results or you pay nothing

Follow: @SpartanPsyche

[Via]

7 stoic rules to follow to live a good life

7 Stoic Rules For Life (An Ancient Guide to the Good Life):
1. Only focus on what’s in your control.

“The chief task in life is simply this: to identify and separate matters so that I can say clearly to myself which are externals not under my control, and which have to do with the choices I actually control…”

— Epictetus

… Think for 5 minutes about your current problems and separate them into two categories:

1) what is in your control and

2) what is out of your control.

Now only focus on what’s in your control. Nothing else.

2. Don’t suffer imagined troubles.

“We suffer more from imagination than from reality.”

— Seneca

Don’t let anxiety and worry get the best of you. Don’t let your worries grow out of proportion to what might actually happen. Don’t let imagination overtake reality.

3. Just do one thing every day.

“Well-being is attained by little and little, and nevertheless is no little thing itself.”

— Zeno

Pick a project you are either currently working on or wanting to get started….

… What is the smallest step you can take to move that project forward? Go complete that step!
4. Make beautiful choices.

“If your choices are beautiful, so too will you be.”

–Epictetus

Things can get between you and your goal, of course, but nothing can stop you from getting started.

Nothing can stop you from making a beautiful choice for yourself today.

5. Constantly ask, “is this necessary?”

“Ask yourself at every moment, ‘Is this necessary?’”

— Marcus Aurelius

There has never been a better time to go through your life and ask yourself about all the things you do and say and think…

.. “Is this necessary?” “Is this essential?” “Why am I doing this?” “What would happen if I changed?”

These are the questions to ask yourself, every day, every moment.

6. Love your fate.

“Do not seek to have events happen as you want them but instead want them to happen and your life will go well.”

— Epictetus

Today, whenever something ‘bad’ happens, respond to it with, “Good.” And then see how you can turn it into a positive.

7. Speak with the dead.

You can put yourself in the same room as Lincoln. You can chat with Shakespeare. You can be inspired by Einstein. To do this isn’t scary, in fact it’s the opposite: READ

Read for thirty minutes today and everyday.

Thank you for reading!

If you found any value in this thread please consider:

1. Following me @growthhub_ for more for more writing on growth, mindset and more.

2. Retweet the tweet below to help another person. https://twitter.com/growthhub_/status/1594714766098173954

Follow: @growthhub_

[Via]

9 proven strategies to help you 10x your LinkedIn presence

Give me 2 minutes and I’ll show you how to 10x your LinkedIn presence:
1. Increase your content input

Your content only reaches ~10% of your audience.

There’s no such thing as “posting too much”.

More input > More output

2. Re-design your profile

Get yourself a professional-looking picture + header.

The more appealing your profile.

The more connections and followers you get.

People want to hear from those who look like an authority.

3. Write a good “About” section.

Don’t write it for everyone.

Write it for the people you want to attract.

4. Be active

Seems obvious.

Because it is.

But 99% of people don’t go the extra mile to write thoughtful comments.

You should.

5. Re-write your headline’s first line

I call this “the money maker.”

This one tweak allowed me to monetize my 100M+ views.

And it only has one goal:

Tell people what you can do for them.

Here’s mine…

6. Don’t be a one-trick pony

Don’t just post carousels.

Don’t just post single-line content.

Don’t just post long-form content.

Mix it up with:

• Value
• Videos
• Carousels
• Viral posts
• Funny posts

7. Write content that triggers emotions

Everyone writes boring content.

You should write content that appeals to the reader’s emotions.

Will that generate controversy?

Maybe.

But f* the haters.

Controversy is great for engagement.

8. Don’t miss a day

The secret to growth is consistency.

The more your content pops in the timeline.

The more people will see you as a familiar face.

And humans like to engage with familiar faces.

9. Send more DMs.

Real connections are built in the DMs.

Don’t be afraid to say “Hi”.

It’s not scalable for growth.

But it might bring you unexpected opportunities.

I write daily threads like this one.

Drop me a follow @houstongolden
so you don’t miss any.

If you enjoyed the reading, consider retweeting this thread to your audience:
https://twitter.com/houstongolden/status/1593265232008429568

If you want my help growing on LinkedIn — book a free call and I’ll see if you’re a good fit to work with us. (I sell a paid service)

Link’s in my BIO.

Follow: @houstongolden

[Via]

These 9 things are enough to screw up your focus

9 things that screw up your focus:
1. Tolerating distraction.

Many of us kid ourselves into allowing distractions into our environments because we have an emotional connection to those things.

Email notifications, music, visiting toddlers, Youtube videos, text messages, talking colleagues.

They are all excuses, diluting your needed attention, no matter how much you rationalise allowing them in.
2. Caffeine.

I love caffeine, it boosts my mood, but this high comes with a cost.

We may have more “energy,” but our focus takes a hit.

Why?

Because caffeine puts us in a heightened state, making it harder to bring our attention to any one thing.

We become twitchy and more easily distracted, thinking we’re more focused when we’re not.

A calm, unstimulated mind is ideal for focus.

3. Multi-tasking.

This one makes me chuckle because doing several things at once is the opposite of focus.

Strong focus means you are doing one thing at a time, undistracted, totally present, and ideally in a flow state.

That’s focus.

Not writing emails while balancing your baby and on the phone.
4. Self-consciousness.

If, for whatever reason, you’re thinking about yourself, how you look, and what’s ‘wrong’ with you…your performance will be minimal.

Focus should reflect ease in your environment.

If you’re uncomfortable, you will be in your head – and this sucks for focus.

Get comfortable and let go of self-pressure if you want to be focused.

5. An inability to handle resistance.

Steven Pressfield said, ‘ the more important a call to action is to our soul’s evolution, the more resistance ******we will feel to do it.’

Resistance is inevitable, especially if the work is meaningful to you.

So your focus relies – not on your clever ability to never feel resistance – but rather on being OK with this feeling and power on regardless.
6. Lack of consistency.

Focus must be thought of in general terms, not as a one-off act.

We’ll always experience moments when we’re distracted – that’s human.

Habits make the difference.

If you are not habitually doing the same thing over and over, you won’t reap the benefits of consistency – one major of aspect of which is focus.

Focused writers are consistent writers.

7. Lack of sleep.

Getting inadequate sleep is no longer trendy.

You may enjoy bragging about how you can manage on less than 6 hours, but you will pay for the accumulated deficit in the long term.

Sleep directly replenishes the mind and body, which is vital for superior focus.
8. Physical tightness.

The state of your body is underrated.

If we’re stressed in mind, we will be stressed in the body too.

This is the least effective mode for focus.

Forget your worries and understand the necessity for you to be physically relaxed.

If you sense tightness, focus on taking belly breaths for a couple of minutes or even having a goofy shake-out dance.

Loosen up before expecting to concentrate well.

9. Not prioritising completion.

Having too many projects happening simultaneously is not particularly bad for focus.

We all have tons of data coming in.

It’s not that.

The issue is that you don’t prioritise finishing what you start.

Leaving a trail of unfinished projects instils in you a lack of urgency and, subsequently, your lack of focus on any one thing becomes a self-fulfilling reality.

🔆

RECAP

9 things that screw up your focus:

1. Tolerating distraction
2. Caffeine
3. Multi-tasking
4. Self-consciousness
5. An inability to handle resistance
6. Lack of consistency
7. Lack of sleep
8. Physical tightness
9. Not prioritising completion.

Thank you.

I keep getting messages from you thanking me for this free gift:

‘The 12 Habits of Mentally Strong People’

Yours free today for a SHORT time, when you subscribe to my newsletter:

https://untetheredmind.substack.com/

Please click below + retweet this tweet: https://twitter.com/1450424698853072897/status/1593604989678559232

Follow: @Alexmathers84

[Via]

5 mental models to help you become a strong leader

Matt Mochary has coached @naval, the founders of Reddit, Coinbase, Notion, OpenAI, and leaders at Sequoia, Y Combinator, Benchmark, and many others.

Here are his 5 mental models that will help you become a strong leader:

1/ Find your Zone of Genius

There are 4 zones:

a. Zone of Incompetence

These are things others do better than you (eg: car repair). Outsource them.

b. Zone of competence

The things you do just fine, but others are as good as you or better (eg: cooking). Outsource them.

c. Zone of Excellence

The things you’re better at than most, but don’t love doing. Outsource them, too.

d. Zone of Genius (ZOG)

The things you’re excellent at and enjoy doing. Ensure you spend the most time doing them.

You’ll add 10X value to your life and team.

Here’s how to find your ZOG:

Message this to a group of people you interact with regularly:

“I want to know what I’m good at. It’s difficult for me to understand that, but you can help. Can you take 10 minutes to answer these questions? If yes, thank you! If not, no problem.

• What do I do that’s “world-class”?

• What do I do where I appear experiencing fun, peace, or joy (if different from above)?

• What do I do that I’m good at but don’t appear to enjoy?

• What do I do that’s not better than others?

• What do I do worse than others?”

2/ Receive honest feedback

Want unfiltered feedback? Follow the 5 A’s:

a. Ask for it

• Take out 10-15 mins to ask for feedback.

• Assure your employees you won’t shame/punish them for negative feedback by not doing so.

• Convince them it’ll not hurt you.

b. Acknowledge it

Confirm you heard by summarizing the person’s thoughts & reciprocating the emotions.

c. Appreciate it

Avoid excuses and thank them.

d. Accept it (or not)

If you disagree, explain why with context and reasoning.
If you agree, then

e. Act on it

Discuss the solution with the feedback giver. Set
a deadline, do it, & let them know.

It will build trust & assure them it’s worthy & safe to provide feedback.

3/ Follow the RAPID (Input, recommend, agree, decide, and perform) model to make fast and quality decisions

In this process:

Here’s a helpful 2*2 matrix to decide who should be the decision maker:
4/ Improve creativity

Matt advises “finding ways to get bored” to pump your creative muscle. It will restore/relax your mental state and trigger creative thoughts.

Here’s how to do it:

• Shut off distractions (meetings, social media, keep your phone in another room) and sit alone (where no one can disturb you)

• Initially, it’ll be unbearable, but you’ll soon experience clarity and think creatively.

• Start doing this for 15 mins/day, then 30 mins/day

5/ Magic questions

To motivate your teams, ask these 5 questions, and act on their answers.

(After each question, follow up with, “What will get it to the next level?”)

• How are you feeling about your life at work?

You’ll know what would increase their job satisfaction and so can provide the necessary help.

• What is it like to work with me?

You’ll know how to improve your relationship with the team.

• How are we performing as a company?

You’ll know how to improve the company’s performance and match their outlook (Who doesn’t like to work in a growing company?)

• How are you feeling about your remote setup?

You’ll know what resources will increase their productivity.

• What is it like to work with the rest of the team?

Everyone wishes to work with supportive and talented colleagues.

The answer to this question will help you address problems and find solutions to increase team communication and collaboration.

This thread is based on this excellent source, where you’ll find @mattmochary other CEO/leader templates.

https://docs.google.com/document/d/18FiJbYn53fTtPmphfdCKT2TMWH-8Y2L-MLqDk-MFV4s/edit

I’ve learned about Matt from his amazing interview with @lennysan. Check it out:
https://www.youtube.com/watch?v=bCel0X2Ta7U&t=101s

@mattmochary @lennysan That’s a wrap!

If you enjoyed this thread:

1. Follow me @volodarik for more of these (I also share everything on the way to growing to $100m / year)
2. RT the tweet below to share this thread with your audience https://twitter.com/1934228078/status/1593239981702713349

Follow: @volodarik

[Via]

10 AI tools to help you save hours of work every week

You are losing out if you are not using AI.

10 mindblowing AI tools that will save you hours every week (for sure).

{1} Excel AI Formula Generator

Transform your text instructions into Excel & Google Sheets formulas in seconds with the help of AI.

🔗 https://excelformulabot.com/

{2} LongShot AI

LongShot is an AI-powered content writing assistant to research, generate, and optimize high-quality long-form content.

Writing blogs will never feel this easy.

🔗 https://www.longshot.ai/

{3} Namelix

Namelix uses artificial intelligence to create a short, brandable business name. Search for domain availability and instantly generate a logo for your new business

🔗 https://namelix.com/

{4} Huemint

AI color palette generator with different previews.

🔗 https://huemint.com/

{5} Soundraw

Your personal AI music generator.

🔗 https://soundraw.io/

{6} Tribescaler

Make Your Tweets Go Viral

Get more impressions, grow a better network, and earn more money.

🔗 https://tribescaler.com/

{7} Supercreator

Create videos 10x faster with AI

Supercreator is a mobile app that uses artificial intelligence to make it easy and quick to create original short videos fast for TikTok, Reels, Shorts, and more.

🔗 https://www.supercreator.ai/

{8} Supermeme .ai

AI memes to boost your personal and professional brand

Generate original AI memes in 110+ languages by entering any text input and turning that into shareable memes.

Powered by GPT-3 and a custom-built meme database.

🔗 https://www.supermeme.ai/

{9} Cleanup .pictures

Remove objects, people, text, and defects from any picture for free. Create a clean background for a product picture 📸, re-design any items 👠, and fill up some missing space for a youtube thumbnail 🎬.

🔗 https://cleanup.pictures/

{10} Looka

Free Logo Maker & Intelligent Brand Designer

🔗 https://looka.com/

You can save this thread by replying with @SaveToBookmarks #thread #ai

You can unroll the complete thread by replying with @SaveToBookmarks unroll

If you want to receive a summary of my best resources, you can even subscribe to my weekly newsletter:
https://www.getrevue.co/profile/csaba_kissi
That’s all guys.

If you found this list useful, consider:

✅ Follow @csaba_kissi for more content like this
🔔 Enable notifications 👀
🔄 Retweeting the first tweet.

Thanks for your support guys! 🙏🤝

Follow: @csaba_kissi

[Via]

Here’s how Peter Thiel has turned a retirement account into a $5B tax-free piggy bank

Peter Thiel turned a retirement account into a $5 billion dollar tax-free piggy bank.

Here’s the incredible story:

In January 1999 a deputy of Peter Thiel’s walked into Pensco Pension Services office in San Francisco.

This would be a meeting that would change Thiel’s life.

First things first, let’s understand how a Roth IRA works.

With a Roth Individual Retirement Account (IRA) you invest a limited amount of money each year ($6,000).

When the money is in your account it’s never taxed again.

As long as you don’t withdraw it before you’re 59 1/2.

Thiel had recently embarked on his venture capital career.

He raised $1 million from friends and family to launch Thiel Capital Management.

Pensco was a small firm that allowed its customers to put almost any investment in a tax-beneficial retirement account.

Pensco’s founder was Tom Anderson.

Anderson introduced Thiel to the Roth IRA, a new account that wouldn’t make you pay tax when you took the money out.

Thiel seized the opportunity with two hands.

He was about to become Pensco’s whale.

But what happened next cost the US government millions.

The average American typically uses their retirement account to purchase stocks or bonds.

The value of which is set by a public stock exchange.

Thiel used his Roth IRA to purchase shares in his new startup, PayPal.

In 1999, the maximum annual contribution to your Roth IRA was $2,000.

Thiel paid $0.001 per share for 1.7 million shares.

This cost him only $1,700.

One month after Thiel bought the shares in his Roth, PayPal raised $500,000.

Then in August, another $4.5 million from Nokia’s venture fund.

The dot-com boom was happening, and happening quick…

The reported value of Thiel’s Roth at the end of 1999? $1,664.

After 1999, Thiel never contributed money to his Roth IRA again.

In 2000, the value of his Roth jumped to $3.8 million.

A cool 227,490% increase.

In 2002, eBay purchased PayPal.

Thiel sold the shares and bagged $28.5 million inside his tax-free wrapper.

If Thiel held these shares outside of the Roth, he would’ve owed the IRS 20% of the gains and another 9% in tax to California.

What happened next?

Rinse and repeat…

Thiel founded Palantir in 2003.

A data analytics company backed by a CIA venture fund.

Thiel used the $28.5 million sloshing around in his Roth to buy shares of Palantir.

There was another opportunity sitting on the table.

In 2004, Thiel met Mark Zuckerberg.

He invested $500,000 into Facebook from a place no other than his Roth IRA.

By the end of 2008, his Roth was worth $870 million.

As of 2019, Thiel’s Roth IRA crossed $5 billion.

What if you also started a Roth in 1999 and maximised your contribution each year?

You’d have $258,000.

So what’s the secret?

1. Open a Roth with $2,000
2. Buy founders shares for fractions of a penny
3. Shield yourself from tax until you’re 59 and a half
4. Use the proceeds to make other investments
5. Find yourself on the beach sipping a cold one
(6. Meteoric startup growth)

If Thiel waits until he’s 59 1/2 in April 2027, he won’t have to pay tax on a penny of the $5 billion.

To give you some perspective:

1 in 4 working-age Americans have nothing saved for retirement.

The average Roth IRA was worth $115,400 at the start of 2020.

Follow me @thealexbanks for more threads to help you in business and life.

If you liked this thread, you’ll love the newsletter.

Subscribe here:
https://noise.beehiiv.com/subscribe

I write threads each week, here’s another I think you’ll enjoy:
https://twitter.com/thealexbanks/status/1591430673834733568
Help the community grow and retweet this thread: https://twitter.com/thealexbanks/status/1592878054702866432

Follow: @thealexbanks

[Via]

7 free courses to help you build a 6-figure online business

If you want to build a 6-figure online business before 2024,

Here are 7 courses you can’t miss…

(All FREE)

1/ $100M Offers Course – Alex Hormozi

You will learn:

– Choosing the most profitable market
– Charging the right price
– Creating offers your customers will feel stupid saying ‘no’
– Using psychological principles to get more sales & grow your business

https://www.acquisition.com/training/offers

2/ Ultimate Web design course – Webflow

You will learn:

– Layout and design
– Interactions and animations
– SEO
– Templates
– Website settings
– Account and billing
– Integrations and users

And more…
https://university.webflow.com/courses/ultimate-web-design-course

3. Shopify Dropshipping Course by EcomKing

You will learn:

– Finding winning products
– Build a digital store
– Set up apps to scale your business
– Hire people to automate your business
– Copywriting and creating offers

And much more…
https://www.youtube.com/watch?v=UrHmQHrIzT4&list=PLAWIMDAc54guVp7x0FZodDAuESbbMjp4q&index=55&t=123s

4/ The Fundamentals of Copywriting – Copy that!

You will learn:

– The power of copywriting
– Writing for prospects & writing for a company
– 5 Stages of customer awareness
– Planning copy
– Crafting ideas
– Structure

And much more…

https://www.youtube.com/watch?v=mWNYE5yVOzk&t=18s

5/ Digital Marketing Certification – Google

Master the basics of digital marketing created by Google trainers.

You will learn:

– SEO & SEM
– Content marketing
– Display advertising
– Local marketing

And more…
https://learndigital.withgoogle.com/digitalgarage/course/digital-marketing

6/ Hubspot Email Marketing Course

You will learn:

– Fundamentals of email marketing
– How to build an email marketing strategy that builds trust
– Designing, testing, and analyzing your marketing emails

https://academy.hubspot.com/courses/email-marketing

7/ Facebook Ads Course – Dylan Pondir

You will learn to:

– Create Facebook Business manager and Ad account
– Build marketing funnels
– Create an advertising story
– Create Optimized Performance Ad Copy
– Launch, analyze and scale Your Facebook Ads

https://www.youtube.com/watch?v=yFrrEiKLsM4

If you like growing your audience and your business,

You will love Steep Growth Saturday.🚀

Subscribe for free to never miss another issue👇
https://steepgrowthsaturday.beehiiv.com/subscribe

Free courses to build a 6-figure business TL:DR

1. $100M Offers Course – @AlexHormozi
2. Ultimate Web Design Course – @webflow
3. Shopify Dropshipping Course – @kamil_sattar
4. Fundamentals of Copywriting – Copy That!

Continued…

5. Digital Marketing Certification – @Google
6. @HubSpot Email Marketing Certification Course
7. Facebook Ads Course – Dylan Pondir
@Google @HubSpot That’s it, Thank you for reading until the end!🎉

If you enjoyed this thread, Please:

1. Follow me @itsamaaan for more of these
2. Retweet the tweet below to share it with a person who will benefit from this like you did👇👇 https://twitter.com/1475820093347024903/status/1592525385539129345

Follow: @itsamaaan

[Via]

20 Lao Tzu quotes that can change your life

20 Lao Tzu quotes on life that have the power to change you:
1. New beginnings are often disguised as painful endings.
2. The journey of a thousand miles begins with a single step.
3. When I let go of what I am, I become what I might be.
4. Nature does not hurry, yet everything is accomplished.
5. If you correct your mind, the rest of your life will fall into place.
6. Knowing others is intelligence; knowing yourself is true wisdom. Mastering others is strength; mastering yourself is true power.
7. Being deeply loved by someone gives you strength, while loving someone deeply gives you courage.
8. Time is a created thing. To say ‘I don’t have time’ is like saying, ‘I don’t want to’.
9. The best fighter is never angry.
10. Do you have the patience to wait till your mud settles and the water is clear? Can you remain unmoving till the right action arises by itself?’
11. All streams flow to the sea because it is lower than they are. Humility gives it its power.
12. In the world, there is nothing more submissive and weak than water. Yet for attacking that which is hard and strong nothing can surpass it.
13. Knowledge is a treasure, but practice is the key to it.
14. To a mind that is still the whole universe surrenders.
15. Silence is a source of great strength.
16. There is no greater danger than underestimating your opponent.
17. Those who flow as life flows know they need no other force.
18. At the center of your being, you have the answer. You know who you are and you know what you want.
19. Success is as dangerous as failure. Hope is as hollow as fear.
20. A good traveler has no fixed plans and is not intent on arriving.

Follow: @growthhub_

[Via]

5 interview mistakes you should never make

It took me 9 interviews to land my first job in the tech industry.

Here are 5 interview mistakes I made that delayed my wins…

1. Lack of confidence

Your lack of confidence will be visible from a mile away.

So, to be confident…

Over prepare for the interview.

– Have a variety of examples from current job
– Know how to convey your answers
– Research the company
– Be a confident listener

It’s time for the interview.

Greet interviewer:

– Make good eye contact
– Firm handshake
– Be polite

It’s normal to feel nervous before and during an interview.

Meke sure you do this…

TIP: Write bullet points to expand upon.

Keep these with you throughout.

Aim to memorize them.

And skyrocket your confidence by 5x.

2. Work examples

As I mentioned earlier.

You should over prepare.

Why is this important?

Have more examples than you’ll ever need at your disposal.

Cover all angles…

– Weaknesses (how have you improved them)
– Failures (how you learned from them)
– Problem solving skills
– Achievements
– Team work
– Strengths

Repetition is key. Practice.

Say them out loud to a family member or friend.

And use feedback to refine where necessary.

3. Talking too much

Do you continue talking beyond answering the question?

Because you think you haven’t answered the question well enough.

The problem is…

You don’t have a framework.

PRO tip.

When you answer any typical competency-based interview questions…

Use the STAR technique:

1. Situation – Describe the situation and the time it occurred

2. Task – Explain the task. What was the goal.

3. Action – Describe the actions taken to achieve the goal

4. Result – Close with the result of your action

I wish I’d knew about this framework sooner.

Would have saved me a lot of trouble.

Break down each section using STAR. And It’ll give structure to your answers.

4. Over exaggerated achievements

Exaggeration creates false expectations.

We’ve all done it.

Overemphasized skills.

But be warned. Don’t put yourself in a position where you can’t back up your claims.

3 possible signs:

– Focus too much on group accomplishments
– It’s all in your body language
– Overstated a given skill

The issue here is.

You can write anything you like on your resume.

But it’s the interview that counts.

And there’s another problem…

A test.

If you’re tested on a set of skills you claim to be a “ninja” on.

But then you flop it.

It’s crystal clear you were dishonest.

5. Failure to close

It’s not about you. It’s about what you can do for them.

I’ve fallen into the trap talking about…

“How I would love to join”

“Why you should hire me”

In any part of the interview. As soon as you get the chance.

Sell yourself the right way…

– How your set of skills will bring the company value
– What changes do you expect to bring

At the end of an interview.

You’ll hear…

“Do you have any questions for me?”

Damn right you do.

This is your chance to learn more about the company.

And show your desire.

Prepare ahead. Ask clear questions.

Here are 4 examples:

– What are your expectations for me in this role?
– Does this role offer growth and development opportunities?
– What are the most important values for this company?
– How does this company define and measure success?

It’s your final opportunity to prove you’re the right candidate for the job.

The last thing you want to say is…

“No I don’t have any questions”.

(awkward silence)

So, assemble questions in advance and show you’ve researched the company.

Are you stuck in a dead-end job?

Learn in-demand tech skills…

Create more:

– Flexibility
– Opportunities
– Better career growth

❌ No degree or qualifications needed.

Your FREE guide to start 👇
https://growthtowealth.gumroad.com/l/gtnvik

Thanks for reading.

If you enjoy what you see👇

Please share and help change a life.
Scroll to the top and retweet the first tweet.

Follow @GrowthToWealth for more:

– Life
– Tech
– Improvement
– Personal development

Follow: @GrowthToWealth

[Via]

7-step guide to learn new skills faster than 95% of people

How to learn new skills faster than 95% of people.

This 7-step guide to help you develop skills 10x faster:

Step #1 Recognize the 10,000 hours myth

Malcolm Gladwell’s 10,000-hour theory:
Only applies to elite performers in specialized fields.

In reality:
you can get good at something within the first 20 hours of practice.

Look at the relationship between:

Your skill level and how long you’ve been practicing.

→ You will see rapid improvements in the first 20 hours.
→ After 20 hours, things start to taper off.

Step #2 Understand & manage your emotions:

• You might think the new skill challenge is intellectual
• In reality, the Challenge is emotional.

→ Learn to deal with feeling uncomfortable, scared, and incompetent.

Step #3 Deconstruct the skill

Break down the skills you want to learn into their components.

Example: If you want to learn to create visuals, the components are:

• Drawing basic shapes
• Drawing icons
• Typography
• Styling shapes, icons, and typography together

Step #4 Learn enough to Self-Correct

• Get 1-3 learning resources
• Learn to recognize the patterns
• Start reviewing your work & identifying areas for improvement

Step #5 Remove practice barriers

• Keep your practice gear (guitar, sports gear, etc…) within sight

• Make it easier to practice, by getting rid of distractions

• Treat practice as a routine rather than a hobby

Step #6 Practice for at least 20 hours

• You can dedicate 45 minutes a day to learn in 30 days

• Or 1 hour a day to learn in 20 days

→ Stay consistent and you’ll be proud of what you’ve achieved!

Step #7 Get excited about the journey

Learning skills in 20 hours is a theory by @joshkaufman

His TED Talk on “how to learn anything” has over 31 M views on YouTube.

→ Watch the video now ⬇️ https://www.youtube.com/watch?v=5MgBikgcWnY

TLDR;

#1 Recognize the 10,000 hours myth
#2 Understand & manage your emotions
#3 Deconstruct the skill
#4 Learn Enough to Self-Correct
#5 Remove practice barriers
#6 Practice for at least 20 hours
#7 Get excited about the journey

Did you like this, perhabs you’ll enjoy Growth Tribe Newsletter:

Join +1,200 readers to Build your audience and grow your business 👇

https://www.getrevue.co/profile/GrowthTribe

Follow me @albadawee for more content like this. https://twitter.com/252177940/status/1592142118599868416

Follow: @albadawee

[Via]

9 beneficial activities parents should do with kids

Parents, do this with your kids and set them to millionaires in the next 10 years…
1. Have common cool hobbies.

Pick hobbies like;

– Archery
– Handstands
– Chess
– Yoga
– Writing
– Trail Running
– Rock Climbing
– Painting
– Pool
– Ping Pong

This’ll ensure you have more time together.

2. Travel together

The world has beautiful people and places.

Ask your family members the places they’d love to tour.

Create time in your busy schedule.

The experiences are priceless.

3. Forgive your past selves

You’re a product of;

• Your environment
• Education
• Society

You hate that but it’s not your mistake.

– Acknowledge this
– Learn
– Become better

4. Read more books

Few families have time for books.

Don’t restrict yourself. Read books on;

• History
• Finance
• Psychology

Reading is learning from others.

Share what you learn later. (It’s fun)

5. Be goofy with each other

Most people are socially awkward because they come from dull families.

Have fun with your family.

This’ll help when relating with others.

6. Talk about your days

Life gets kinky sometimes and we need people to talk to.

• Sit down together
• Have coffee
• Talk about your days

It’s powerful for your mental health.

8. Exercise together

A fit family is healthy and strong.

– Set time aside to work out
– Have nature walks
– Eat clean

Your family will starve the pharmaceutical industry.

9. Pray together

Prayer is leaving what you can’t handle to the unknown.

After the day’s activities;

• Sit down together
• Show gratitude for the day
• Say a prayer and call it off

Your family will be happy.

It’s Sunday

Join https://copywritingdad.gumroad.com/l/50MinutesRule and learn more on;

• Making Money Online
• Audience building
• Persuasive writing
• Copywriting
• Productivity
• Creativity
• Writing
• Virality
• Life

💕I love you — You’re Amazing💕

Follow: @Copywriting_Dad

[Via]

Start a YouTube with $0 and make up to $10,000/month; here’s how

How to make $10,000/month on YouTube in 2023 as a beginner (starting with $0)

– Thread –

1. Select a niche

For our example, we will use the evergreen niche of relaxation and meditation

People love turning on relaxing music while working, reading or before bed

These videos get crazy amounts of watch time and can make a ton of money

Here’s an example channel:

2. Find Footage

Stock footage is perfect for the relaxation niche

To get footage, search for free video content on sites like:
– Pexels
– Pixabay

Meditation videos can use the same few videos throughout

Here’s what you would search on Pexels:

3. Find Music

Go into the YouTube audio library and sort music by mood

Select “Calm” and listen to the music demos

Select a track that matches your video content

Add in the credits in your video’s description and you’re set!

4. Edit Video

To edit your videos, go to Clipchamp

Import your video and audio files

Edit to match music length to length of video files

Aim to make your videos 24 hours long

5. Monetize

To make $10k/mo on this channel you need to promote an offer

Digital products and affiliate offers work best

Check out sites like Impact Radius or Commission Junction to find offers

Place links to your offers in your videos’ descriptions and pinned comments

Here’s how much a small channel can make:

20,000 monthly views x 2% conversion x $25 product = $10,000

Getting to 20,000 monthly views only takes 4-6 months

That’s the power of YouTube…

Start building your own $10k/mo YouTube channel

Get my guide Tube Ignite (25% off first 5 copies ONLY): https://adamdelduca.gumroad.com/l/tubeignite/25off

If you enjoyed this thread, please RT the first tweet

Follow me for more YouTube wisdom:
@Adam_DelDuca

1 left 🕐

Follow: @Adam_DelDuca

[Via]

Get rid of these 7 toxic habits to get ahead of 99% of people

Free yourself from these 7 toxic habits to get ahead of 99% of people in their 20s and 30s.
1. Wasting your time

Be mean with your time

Start your day at 4:00 AM with;

• 100 pushups
• A Cold shower
• 15 mins meditation

Then;

• 4 hours of deep work
• Spend your evening reading
• Schedule to sleep 9 PM

Fill your day with meaningful activities.

2. Getting easily distracted

Observe and learn but avoid;

• People’s ideas
• Crowd mentality
• Opinion from anyone
• Social media influence

Be picky on;

• Who you talk to
• What you watch
• What you engage with

Attention is energy exchange.

Conserve your energy.

3. Engaging in small talks

Only talk when you have something to say.

Compose yourself, people will trust you more.

Talking too much shows;

• Insecurities
• Low confidence
• Poor social skills
• Self unawareness

You should never trust anyone who talks too much

4. Chasing cheap dopamine

You’re a slave to anything that triggers you

Take some time away from;

• Alcohol
• Fast food
• Your phone
• Video games
• Social media

This’ll get you enough time to;

• Focus
• Do hard tasks
• Work on your goals
• Control your impulses

5. Using your phone in the morning

This kills your day’s momentum by;

• Raising your cortisol level
• Hit you with cheap dopamine

This will leave you feeling sluggish for the rest of the day.

Do this;

Keep your phone off for 2 hours after you wake up.

6. Being a people pleaser

Be ready to lose people who don’t help you grow.

Keep distance from friends, parents or partner if they drag you down.

Adversities will shape you.

Embrace being alone to conquer all your possibilities.

7. Having limiting beliefs

There’s a battle you can always win .

You need to;

• Think
• Write
• Visualize
• Take actions

Don’t compare, we all have different journeys to make.

Track your progress after 100 days and adjust.

8. Being attached

The more attached you’re to anything, the harder it hits when you lose it.

You need to let go;

• Personal beliefs
• Your past self
• Toxic family friends
• Unpleasant workplaces

Create options in life and you’ll be less attached.

Follow @Wealth_Pill and join https://wealthpill.gumroad.com/l/Wealthbrew to learn more on:

• Making money online
• Persuasive writing
• Business ideas
• Creativity
• Life

Follow: @Wealth_Pill

[Via]

How to get 1,000 true fans on Twitter? Follow these 4 simple steps

4 steps to 1,000 true fans on Twitter:
Think Like a Niche Streaming Service:

It’s critical that you focus on helping a specific person looking for specific advice.

The more helpful your content is to a specific audience, the more likely they are to find your “signal” in a world of generic “noise”.

Stay narrow.

Become a Category Pirate:

Don’t blend in. Stand out.

And the easiest way to stand out is through non-obvious content.

Non-obvious content is about bringing a new thought process to your niche.

Something that makes you radically different.

Ask yourself these questions ↓

– What is something everyone believes to be true, that you don’t?

– What is something nobody in your niche is talking about, but should be?

– What are the biggest mistakes people are making, that they are oblivious to?

– Why are you someone worth following when others aren’t?

Tell a story worth following:

Like the founder of a company, you need a story that compels your audience.

The story can’t be fake. It’s your real story but stitched together in a fashion that makes it exciting to follow along.

Use this formula:

Do unscalable things:

Here are some of the things I’ve done:

– Published daily to social media, often 2x-3x per day.

– Replied to every comment, every morning for over an hour.

– Engaged with 15+ people’s content every morning for over 3 years.

TL;DR

1. Think like a niche “streaming service”

2. Become a Category Pirate

3. Tell a story worth following

4. Do unscalable things

If you want go deeper on this subject, check out my article:

“4 Steps to 1,000 True Fans”

https://www.justinwelsh.me/blog/05072022

Follow: @thejustinwelsh

[Via]