BC ALL

Saved by @raffijashua_08

Chandoo.org
@r1c1 3 years, 11 months ago 808 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

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
🙏🕉🙏

Kanekoa
@KanekoaTheGreat

*The Evidence Collection*

There is overwhelming evidence of election fraud. Therefore it is the duty of the Executive, Legislative, & Judicial branches to throw out the fraudulent votes & to honor their oath to protect & defend the Constitution of the USA.🇺🇸🦅

A list below.🔻

1/ Navarro Report: The Immaculate Deception - Six Key Dimensions of Election Irregularities -

2/ Analysis of 3,000 U.S. counties shows Joe Biden received 5.6 % more votes in counties using Dominion Voting Systems (Video) -

3/ Antrim Michigan Dominion Voting Systems Forensics Report -

4/ Evidence Grows: ’20 Election Was Rigged -

Advertisement

Vibhu Vashisth
@VIBHU_Tweet

Did you know?
Ahilyabai Holkar was one of India's
greatest women rulers of all time.

Ahilyabai was Born on May 31,1725 in the village of Chondi,Jamkhed distt,Maharashtra to a man named Mankoji Shinde,who was the Patil(Chief) of a village and a member of proud Dhangar Community.

Despite the fact that girls' education was a farther dream in those days, Ahilyabai was homeschooled by her father.
Ahilya didn't belong to any royal family but in a twist of fate she is still remembered as one of the most revered Queen in the history.

While they were living their humdrum lives, one day Malhar Rao Holkar, commander of the Peshwa Bajirao & Lord of the Malwa stopped in Chondi on his way to Pune, where he couldn't help but notice a young 8yrs old Ahilyabai in the temple service feeding the poor & hungry.

He was so impressed by the sheer innocence&beauty with simplicity character of Ahilyabai dat he asked her hand in marriage for his son Khanderao Holkar.Just like that she got married to Khanderao in 1733 at a tender age of 8&became a bride of esteemed Maratha community of Holkars

But destiny had something else in store for her as her husband died in the Battle of Kumbher in 1754 leaving her widow at 29.Distressed Ahilyabai was to commit Sati when her father-in-law Malhar Rao refused to let it happen.

Buzz Chronicles
@buzz_chronicles

@SaveToBookmarks Hola! Saving all night and all day :) Original tweet by @AchuthArora: "@aldothetrainer @Artofphysique_ @buzz_chronicles @rattibha @SaveToBookmarks save...". See You soon! ✌

Hola! There you go! Original tweet by @SaveToBookmarks: "@AchuthArora @aldothetrainer @Artofphysique_ @buzz_chronicles @rattibha Gotcha, ...". Enjoy ✌

Angela Jamison
@AnJamison

@45RapeKatieJohn @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

Patrick McKenzie
@patio11

Most software founders, particularly in B2B, need to get radically better at sales. @Steli , who is the best person for explaining the scrappy stages in the beginning and then building out a team with scripts and processes, wrote a guide to:

For technical founders it is irrationally, obscenely hard to reverse years of programming (ba dum bum) that sales is a value-destroying activity. Sales is CLEARLY a value-creating activity, contingent on you have a value-creating product.

The world will not drop what they are doing to adopt your work. This is particularly true in B2B, where simply building a better mousetrap won't overcome the activation energy required to get people with additional non-mice problems to prioritize changing mousetraps today.

This is very non-obvious for founders because founders are not often people who *want* to be sold to. We often come from a background where trying out tools is a bit of a fun hobby. We like looking at all the options, making charts, and ripping out partially complete tests.

"This week I unsuccessfully trialed four software options for automating that thing that has been killing us. Our actual production process remains the same as last week. Don't worry; this was a great use of time." is not a thing you want to write in a progress report to manager.

Angad Singh
@Singh7575

𝙎𝙝𝙖𝙧𝙞𝙣𝙜 𝙢𝙮 𝙬𝙞𝙨𝙙𝙤𝙢 𝑾𝒐𝒏'𝒕 𝒃𝒆 𝒔𝒖𝒓𝒑𝒓𝒊𝒔𝒆𝒅 𝒊𝒇 𝒕𝒐𝒎𝒐𝒓𝒓𝒐𝒘 𝒖 𝒓𝒆𝒂𝒅 𝒕𝒉𝒆 𝒔𝒂𝒎𝒆 𝒔𝒕𝒖𝒇𝒇 𝒊𝒏 50𝒌 𝒘𝒐𝒓𝒌𝒔𝒉𝒐𝒑 𝒐𝒓 𝒔𝒐𝒎𝒆𝒐𝒏𝒆 𝒎𝒂𝒏𝒂𝒈𝒊𝒏𝒈 𝒚𝒐𝒖𝒓 𝒎𝒐𝒏𝒆𝒚 𝒘𝒊𝒕𝒉 𝒔𝒂𝒎𝒆 𝒍𝒐𝒈𝒊𝒄
Simple and effective way 2 make Money

Idea 1:- Use pivot level like 14800 in case of nifty and sell 14800straddle monthly expiry (365+335) exit if nifty closes on daily basis below S1 or above R1

After closing below S1 if it closes above S1 next day or any day enter the same position again vice versa for R1

Idea2:- Use R1 and S1 corresponding strikes multiple
Incase of R1 15337 take 15300ce
N in case of S1 14221 use 14200pe
Sell both and hold till expiry or exit if nifty closes below S1 or above R1 around closing
If the same bounces above S1 and falls below R1 re-enfer same strikes

Use same criteria for nifty, usdinr and banknifty

(This is must)Use this margin rule for 1lot banknifty pair keep 4Lax margin
For nifty one lot keep 3Lax
For usdinr 100lots keep 4Lax

I bet you if you do this on consistent basis your ROI will be more than 70% on yearly basis.

Couldn't explain easier than this

Criticisms are most welcomed.

Advertisement

$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. 👇

Andrew Chen
@andrewchen

👇 Thread. New deck getting published this week: "Consumer startups are awesome, and here's what I'm looking to invest in at Andreessen Horowitz." If you want to read it, subscribe to my newsletter here: https://t.co/262t8eh0wf

1/ A lot of new consumer technologies have been introduced to US households in the last 100 years. But it's taken many of them - like the telephone - more than 50 years to get to the majority of the US. Why is that?

2/ We had to literally teach people how to use phone. Which end goes to your mouth, which goes to your ear. Say "hello" when people call. The motivation of consumers to talk to their friends has always been there, but we had to teach the behavior

3/ If you compare phones to the latest technologies, there's been a huge shift. Things are being picked up much faster.

4/ Even while there's been all this innovation recently, physically speaking, we are still the same human beings from 100,000 years ago.

Pegasus of Dharma
@HarduttSuhas

THE EVOLUTION OF OUR NATIONAL FLAG (1857-1947)

The INDIAN NATIONAL FLAG is not just a flag! It's a testimony of patriotism and seamless sacrifice. A symbol representing one of the oldest civilizations on this planet.

Let's hope what happened yesterday never repeats!

(Thread)

After the revolt of 1857, the first Indian flag was designed. The design was based on western heraldic standards with "Union Jack" in the upper-left quadrant and a "Star of India" enclosed in the royal crown in the middle of the right half.(1)

The flag was a symbol of the direct imperial rule in India.(2)

In 1904 the first Indian flag which stood for India's independence from the British was devised. The design was provided by sister Nivedita, an Irish disciple of Swami Vivekananda.(3)

The flag was red and yellow with an image 'Vajra' (weapon of god Indra). The phrase 'Vande Mataram' was written in Bengali on it. The red colour and the yellow colour signified freedom and victory while the symbol of vajra stood for strength.(4)