10 time-saving Excel functions you should be using: 📊

WORKDAY:

Customers need to know when the job will be done.

The Workday function allows you to easily calculate the time between your start date and a specified number of "business days" in the future.

Automatically exclude weekends & holidays of your choosing.

Like this:

3D FORMULAS:

Let's say you want to add up the values in Column 'D' on 4 different sheets & show a single total.

Quit wasting time on SUM formulas that reference each sheet individually.

3D lets you select the 1st + last sheet in a series and dynamically include any in between.

AGGREGATE:

This function returns the result of an aggregate calculation like Average, Count, Sum, Max, or Min.

What makes it special?

Aggregate performs these functions while allowing you to ignore errors, hidden rows, blanks, and more.

Here's how:

IFS FUNCTION:

The IFS function tests multiple conditions to find out if they are true based on the criteria you provide.

Here, we're going to test if our monthly sales increased, decreased, or remained static in relation to our average.

Use '$' to lock in the reference cell.

Ways to keep track of new OSINT tools and tricks:
Twitter https://t.co/05yTuOteUB
Telegram https://t.co/QEmaUvfpCw
Discord https://t.co/kfXcOk0rBR
Linkedin https://t.co/ZoiiCGlClv
Github https://t.co/MlZ0QAtK3W
Email https://t.co/v4Qgfn8ya8

#osint #socmint #geoint

@GordonsGecko That's a good short candidate

Accounting is the language of business.

If you buy stocks, you MUST learn how to read a Cash Flow Statement.

Here’s everything you need to know:

The cash flow statement shows how cash moves in and out of a company over a period of time.

The most common time periods are:
▪️1 Quarter
▪️1 Year
▪️Year-to-date (usually 6 or 9 months)

The time period is at the top. Here's $NFLX recent cash flow statement time period.

Some companies show the cash flow statement in their earnings press release, but many don’t.

You can find the cash flow statement by looking at:
▪️10-Q (Quarterly Report)
▪️10-K (Annual Report)
▪️Fnancial aggregators such as @theTIKR,
@CMLviz, @themotleyfool, @YahooFinance

There are three main segments to a cash flow statement.

1. Operating Activities
2. Investing Activities
3. Financing Activities

Companies get some leeway with how they breakout each segment, but they all follow this basic structure.

Let’s start with Operating Activities.

This segment STARTS with net income (the bottom number of the Income Statement).

It shows cash movements from all normal operational business activities.

Listened to an excellent episode of Paisa Vaisa podcast with:

Monika Halan @monikahalan author of the best-selling book "Let's Talk Money" hosted by Anupam Gupta @b50

A thread 🧵 on key takeways from this excellent podcast.
#PaisaVaisa
@IVMPodcasts

Learnings from pandemic:

~ Need for a bigger emergency fund
~ Move money from equity to emegency funds during bull runs

~ Re-balance portfolio as per market changes
~ Maintain asset allocation

Beware of current environment

~ Unauthorised & unqualified people are giving equity investing advice

~ New investors haven't seen deep crash & scary market environment

~ Times of get rich quick schemes through stock & crypto

Understand your impression about the market

Most youngster's idea of the market is:
~ Driven by the current environment
~ Influenced by the media & news
~ Motivated by bull market returns

Understand who are you?

~ Are you a trader or an investor.
~ Stock market is for all types of people.

Once you understand yourself, then choose the investment path accordingly.

If leveraged quickly, Twitter can lead to life-changing opportunities, jobs, mentors, and friendships.

It did for me.

But 95% of people have no idea how to start.

Here's a thread of 13 tips to help you turn Twitter into your most valuable resource:

1. Protect your attention from the algorithm.

Twitter is geared to try and serve content they think you like, not content that will create a positive impact for you.

To protect your attention:

• Use Twitter Lists
• Block Trending Topics
• Regularly Mute Conversations

2. Build Twitter Lists

The Twitter timeline is scattered. One second you are learning about NFTs, the next the best coffee shop in NYC.

Lists create content silos that allow you to build deeper understanding of the topics you actually care about.

(Video h/t @aaditsh)

2a. Use Lists on iOS

The majority of Twitter consumption happens on mobile.

Easily toggle between lists at the top of your screen by pinning them there!

3. Use Tweetdeck

Tweetdeck superpowers your Twitter experience.

• Displays all your lists in one place
• Timeline is organized by chronology not the algorithm
• Allows you to see the bios of your recent follows (DM the ones that interest you!)

Why should we refrain from refined edible oils:

- Major factor of cardiovascular risk is caused by refined oils
- Study found,Even rats which were constantly fed food made out of refined oils have shown symptoms of hypertension & ischemic heart causing cardiovascular disability

Traditional Indian consumed oils made from locally available seeds like sesame, gingelly, groundnut and coconut oil

The dynamics of edible oil industry got disrupted after we adopted mass production / import of refined oils at lower cost to our wallet( costing our heart health)

Oils are essential dietary fat which were implicitly included In our food culture

Age old days,Oils were extracted at home and given the complexity of extraction it was used mindfully

Oils are excellent supplement if we know how much is too much

Refined oils are trade ploy to make you sick or reduce your life span early due to high chemical treatment and food processing

Refined oils are gateway for

- Obesity
- Hypertension
- Abnormal cholesterol/ Lipid profile
-Ischemic heart disease
-Cardio vascular risk / disability

Refined oil mafia are quite influential to fund a favourable study that refined oils aka healthy oils were meant to do good to your than trad cold pressed oils

As health is subjective to individual so does oils were subjective to region person lived (Tropical bio diversity)

I interviewed 100 legendary investors, founders and executives.

Collectively, they have created over $1 trillion of value for the world.

Here are 20 practical career lessons they shared with me 👇👇👇

Always strive to simultaneously be overrated and underrated.

Contrary to popular belief, being overrated is good. It opens doors and gives you credibility.

But don’t let this go to your head. Stay hungry, humble and hardworking.

Most people overinvest in expiring skills & underinvest in permanent skills.

Expiring skills are tactical; their relevance diminishes with time and technology

Permanent skills are evergreen and create disproportionate impact

E.g. communication, judgement, trust, empathy

Get comfortable with being uncomfortable

If you get advice from enough people, the advice will cancel out.

You can find 2 smart people to take opposite sides of the argument on virtually every topic.

Focus on developing your instincts and trusting your own intuition.

Surround yourself with open minded people vs. close minded people

Open Minded People:
- Ask genuine questions
- Insatiably curious
- Listen attentively

Close Minded People
- Make statements instead of ask questions
- Focus on being right
- Speak more

@heykahn I use money converter a lot

And if you use chrome on phone, you can use this arrow button to choose the suggestion without typing

@luc_falco Debes decime cuándo quieres que te lo recuerde. Mira mi tweet fijado para ver cómo pedirme un recuerdo 😄

Marketing isn’t a scam

Marketing makes change happen. Marketing makes your creations known

I'll share some tactics & frameworks I use

How to get lucky in marketing in 2021:

How marketing has evolved:

Marketing used to be a contest for attention

But now, marketing is a contest for CONNECTION

Whoever owns the connection, wins

Turn your product into a social statement

Products that make you feel good or defend you from being cancelled, spread fast

Ex: Make clothes out of recycled plastic

Point: People want a chance to show they stand for something

Are you working with creators?

Some of the world’s biggest brands were catapulted in the 1960s via TV

Brands bought TV ads. Captured attention

Working with creators is like buying TV ads in the 1960s

Point: Co-building with the right creators is like fishing with dynamite

Avoid ads. Build media companies

Prediction: every public company will own a media arm

It’s a magical shortcut to building true fans

Ads just don’t hit the same way

Mega Thread on Personal Finance 101

👇👇👇

Rule of 72 (Double Your Money)
Rule of 114 (Triple)
Rule of 144 (Quadruple)
Rule of 70 (Inflation)
4% Withdrawal Rule
100 - Minus Age Rule
10, 5, 3 Rule
50-30-20 Rule
3X Emergency Rule
40℅ EMI Rule
Life Insurance Rule

♻ Rule of 72

No. of yrs required to double your money at a given rate, U just divide 72 by interest rate
Eg, if U want to know how long it will take to double your money at 8% interest, divide 72 by 8 and get 9 yrs

At 6% rate, it will take 12 yrs
At 9% rate, it will take 8 yrs

📋Rule of 114

No. of years required to triple your money at a given rate, U just divide 114 by interest rate.

For example, if you want to know how long it will take to triple your money at 12% interest, divide 114 by 12 and get 9.5 years

At 6% interest rate, it will take 19yrs

🗒️ Rule of 144

No. of years required to, quadruple your money at a given rate, U just divide 144 by interest rate.

For eg, if U want to know how long it will take to quadruple your money at 12% interest, divide 144 by 12 and get 12 yrs

At a 6% interest rate, it will take 24yrs

🗒️ Rule of 70

Divide 70 by the current inflation rate to know how fast the value of your investment will get reduced to half its present value.

The inflation rate of 7% will reduce the value of your money to half in 10 years.

Today is the founding day of Gita Press.

This thread tells the story of Gita Press. Their mission, their founding members and their unrelenting resistance against left-liberal & Congress Govt censorship of their organization.

Gita Press was established in 1923 by JD Goyanka.

Hanuman Prasad Poddar was the founding editor of Gita Press.

Its first journal Kalyan was published in 1927. While most journals of this period are confined to libraries and archives, Gita Press and Kalyan still exist with millions of copies

Unlike other publications, Gita Press publishes its books at a very reasonable price.

For example, a Bhagavad Gita can be procured at Rs.30. A copy of Hanuman Chalisa costs just Rs. 2 (50 lakh copies printed every year). Yet, the printing, cover and content quality is FANTASTIC

But why? Why does Gita Press publish excellent books at such a minimum token price which inevitably equals or exceeds the creation cost?

The answer to this question is that Gita Press was not founded to be a profit making enterprise.

Its goals were something very different

Gita Press was founded at a time when Christian Missionaries were making rapid progress in converting Hindus.

They were making all out attacks on Hinduism.

Missionaries distributed copies of Bible to anyone who showed slightest inclination to accept it. Bibles were flowing in