BC ALL

Saved by @raffijashua_08

Chandoo.org
@r1c1 2 years, 7 months ago 569 views

Save to PDF Share See On Twitter

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.

5) INDEX
Use to it get a specific items from a list or range.
=INDEX(A1:A100, 12)
returns the 12th item in the range A1:A100

6) EDATE
Use it to calculate a future or past date after x months.
=EDATE(TODAY(), 6)
tells you what the date is exactly 6 months from now.

7) TEXTJOIN¹
Use it to combine text values in range with a specified delimiter.
=TEXTJOIN(" ",,"This","tweet","thread","is","awesome!")
returns the message "This tweet thread is awesome!"
¹ Works in Excel 2019 or above

8) UNIQUE*
Use it to extract unique values from a range.
=UNIQUE(A1:A100)
gives you the unique items in range A1:A100 by removing any any duplicates.

9) SORT*
Use it to sort a list or range by in ascending or descending order.
=SORT(A1:C100, 2, -1)
Sorts the range A1:C100 by column B(2nd column) in descending order (-1)

10) IFERROR
Use it to replace any formula errors with a relevant value.
=IFERROR(A1/0, "We can retweet this thread, but can't really divide by zero")
prints the message "We can retweet this thread, but can't really divide by zero"😉

11) For more on useful Excel functions, see these resources:
Top 15 Excel functions 👉 https://t.co/89m2aM6fYF
Advanced Excel Skills for you 👉 https://t.co/uRW5resifJ

More from All

Naval
@naval

How to Get Rich (without getting lucky):

Seek wealth, not money or status. Wealth is having assets that earn while you sleep. Money is how we transfer time and wealth. Status is your place in the social hierarchy.

Understand that ethical wealth creation is possible. If you secretly despise wealth, it will elude you.

Ignore people playing status games. They gain status by attacking people playing wealth creation games.

You’re not going to get rich renting out your time. You must own equity - a piece of a business - to gain your financial freedom.

Anu Satheesh
@AnuSatheesh5

Story of Thumba Poo and Shiva

Thumba poo is a tiny white flower which grows in all areas. These flowers are used for treatment for sinus. Small children who have polyps in Nose are told to crush tumbha leaves and apply in nose part.
There is an interesting story of Thumba and

Mahadeva. Thumba flowers were not taken for Shiva Pooja. Saddened to this Thumba prayed sincerely and Mahadeva appeared before her.
She was surprised that Shiva had appeared before her. Instead of saying that she wants to under his feet always, she said
@SriramKannan77

She said that her feet should be on his head. Shiva accepted her prayers. It is because of this Thumba flower is placed in the head of Shiva Linga.
Shambo Mahadeva
Om Namah Sivaye
🙏🕉🙏

Advertisement

Sheetal Rijhwani
@RijhwaniSheetal

How you can filter stocks for Intraday trades - 🧵

As a kid, we would do homework before school the next day - you have to do homework here too. A specific sector performs on a particular day and studying things a day before will help you spot that particular sector. (1/11)

To prepare for the next trading day, you got to check the Index charts of all sectors. You got to keep an eye on a specific Index if you see a few factors:

- If any Index closed exactly at the resistance, you can get a trade on either side on the next day. (2/11)

- If it gave a rejection candle at resistance.

- If any Index closed exactly at support, you can get a trade on either side the following day.

- If there was a bullish signal at the support.

- If any Index gave a breakout or breakdown and then gave a good closing. (3/11)

- If any Index has taken support at 50 or 200 EMA.

Once you spot the Index, look at all the stocks in that particular Index. Pick at least 3-4 stocks from that Index and add them to your watchlist for the next day. It's ideal to check both higher and lower timeframes. (4/11)

What you should do next day? (When I am unable to check Indices and stocks a day before, I sometimes directly start with this process.)

- Start with checking the top gainers/losers list. I observe market from 9:15 to 9:45am to check the sectors performing well on that day.(5/11)

Angela Jamison
@AnJamison

@FeistyLibLady @jamie_raskin @buzz\_chronicles @buzz\\\_chronicles @buzz_chronicles save as category @pdfmakerapp grab @pdfmakerapp grab this @readwiseio save @readwiseio save thread @threader compile summarize @Threadreaderapp unroll please @ttttreads unroll @unrollthread.com @SaveToBookmarks

Angela Jamison
@AnJamison

@ferrisjabr @buzz_chronicles @buzz\_chronicles @buzz_chronicles save as category @pdfmakerapp grab @pdfmakerapp grab this @readwiseio save @readwiseio save thread @threader compile summarize @Threadreaderapp unroll please @ttttreads unroll @unrollthread.com @SaveToBookmarks

You May Also Like

Jaya_Upadhyaya
@Jayalko1

NARHARI AND BHAGWAN PANDURANG/VITTHAL

Once a goldsmith by the name of Narhari lived in Pandharpur. He excelled in his craft. He had vowed not to look at Pandurang or visit his mandir ever, as he was a Shiva Bhakt.
One day, a wealthy merchant visited him.

He wanted a gold girdle studded with precious gems, to be made for Prabhu Vitthal. Narhari refused to make it as it was for Vitthal.
After many requests, he agreed to make the girdle but asked the merchant to bring the measurement from the mandir as he himself would not go there

The measurement was given n he made the girdle. When the girdle was put on Vitthal, it was loose. Narhari had to shorten it. Now the girdle became tight. So Narhari was forced to take measurement on his own. He had to go to the mandir but went blindfolded to avoid seeing Vitthal

In the Mandir, when blindfolded Narhari touched Vitthal, he felt as if he was touching Shiva with matted hair, the moon, snake in His neck and Trishul in His hand. Ecstatic with joy, he removed the blindfold to see Shiva but he found the murti of Vitthal with Rukmini there.

He realised the truth that there was no difference between Vitthal and Shiva. Narhari at once fell at the feet of Panduranga. He then took the measurement of the waist of Vitthal and this time the ornament fit the Murti perfectly.

Narayan Hari🙏🏻

Robin Berjon
@robinberjon

Recently, the @CNIL issued a decision regarding the GDPR compliance of an unknown French adtech company named "Vectaury". It may seem like small fry, but the decision has potential wide-ranging impacts for Google, the IAB framework, and today's adtech. It's thread time! 👇

It's all in French, but if you're up for it you can read:
• Their blog post (lacks the most interesting details): https://t.co/PHkDcOT1hy
• Their high-level legal decision: https://t.co/hwpiEvjodt
• The full notification: https://t.co/QQB7rfynha

I've read it so you needn't!

Vectaury was collecting geolocation data in order to create profiles (eg. people who often go to this or that type of shop) so as to power ad targeting. They operate through embedded SDKs and ad bidding, making them invisible to users.

The @CNIL notes that profiling based off of geolocation presents particular risks since it reveals people's movements and habits. As risky, the processing requires consent — this will be the heart of their assessment.

Interesting point: they justify the decision in part because of how many people COULD be targeted in this way (rather than how many have — though they note that too). Because it's on a phone, and many have phones, it is considered large-scale processing no matter what.

Advertisement

Guillaume Chaslot
@gchaslot

The YouTube algorithm that I helped build in 2011 still recommends the flat earth theory by the *hundreds of millions*. This investigation by @RawStory shows some of the real-life consequences of this badly designed AI.

Flat Earth conference attendees explain how they have been brainwashed by YouTube and Infowars https://t.co/gqZwGXPOoc
— Raw Story (@RawStory) November 18, 2018

This spring at SxSW, @SusanWojcicki promised "Wikipedia snippets" on debated videos. But they didn't put them on flat earth videos, and instead @YouTube is promoting merchandising such as "NASA lies - Never Trust a Snake". 2/

A few example of flat earth videos that were promoted by YouTube #today:
https://t.co/TumQiX2tlj 3/

https://t.co/uAORIJ5BYX 4/

https://t.co/yOGZ0pLfHG 5/

Kavita
@Kavitastocks

There are many strategies in market 📉and it's possible to get monthly 4% return consistently if you master 💪in one strategy .
One of those strategies which I like is Iron Fly✈️

Few important points on Iron fly stategy

This is fixed loss🔴 defined stategy ,so you are aware of your losses . You know your risk ⚠️and breakeven points to exit the positions.
Risk is defined , so at psychological🧠 level you are at peace🙋‍♀️

How to implement
1. Should be done on Tuesday or Wednesday for next week expiry after 1-2 pm
2. Take view of the market ,looking at daily chart
3. Then do weekly iron fly.
4. No need to hold this till expiry day .

5.Exit it one day before expiry or when you see more than 2% within the week.
5. High vix is preferred for iron fly
6. Can be executed with less capital of 3-5 lakhs .
https://t.co/MYDgWkjYo8 have R:2R so over all it should be good.

8. If you are able to get 6% return monthly ,it means close to 100% return on your capital per annum.

$FT Trading\u2503Stock Trader$

FT Trading┃Stock Trade...
@FT__Trading

Ever wonder how traders get in stocks before they explode? 🧐

Or find options that move 1,000% in a single day/week?🤯

I made a thread going over exactly how I find these stocks BEFORE they take off 🚀
👇👇👇

So, let's start with the software I use…

Finviz!! Finviz is a free website that I use to scan for stocks.

They have a lot of other cool features as well, but I only use their scanner.
👇

Head on over to finviz and go to the screener

Click on the “All” tab on the top and put in the criteria in the next tweet
👇

This is the first scan that I use for bullish swing setups
✅Quarter +10%
✅Week Down
✅Vol over 400k
✅Optionable
✅Price > $20
👇

The next scan I use is the opposite of the first one.

Simply change:
✅Quarter +10% to -10%
✅Week Down to Week up

This is my bearish scan for swing setups. 👇