BC ALL
Saved by @raffijashua_08

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

Vibhu Vashisth \U0001f1ee\U0001f1f3
Vibhu Vashisth 🇮🇳...
@VIBHU_Tweet
MAHARAJA CHHATRASAL BUNDELA was the great Bundela King who revolted against the Mughal ruler Aurangzeb.
Chhatrasal Bundela was born in year 1649 CE in Maur Hill of Bundela region to Champat Rai and Lal Kunwar. He was the descendent of Rudra Pratap of Orchha.


His ancesters were the vassals of Mughal Emperor. He drew inspiration from his father and revolted against the alien rule of Mughals. He was just 12 yrs old when his parents died in fight against the Mughal Army of Aurangzeb in 1661.

When his beloved father attained martyrdom in the year 166, the young Chatrasal was present in the last battle of his father against the Mughal and from these valiant campaigns,..

..he gathered the courage to free Bundelkhand from Aurangzeb’s rule.
He joined the Mughals initially, and was recommended by the Rajput King Mirza Jai Singh to be recruited in the Mughal Army in order to support their Deccan Campaigns.


But serving the alien rule of Mughals which brought chaos and misery to Bundelkhand was unacceptable for Chatrasal Bundela and his father’s incessant struggle against the Mughals kept the fire of independent Bundelkhand alive in his heart.
ALL
\u0936\u094d\u0930\u0940\u092e\u093e\u0932\u0940 \u0939\u093f\u0924\u0947\u0936 \u0905\u0935\u0938\u094d\u0925\u0940
श्रीमाली हितेश अवस्थी...
@HiteshAwasthi89
#Thread
12 Most Powerful Hanuman Mantras

Hanuman ji is the Hindu God of strength, valor, agility, and wisdom. He is considered as the incarnation (avatar) of bhagwan Shiva. Hanuman ji is the symbol of devotion and dedication. He is the greatest devotee of Prabhu Shri Ram. 1/n


Hanuman ji is known by several names such as Bajrangabali, Mahabali, Maruti Nandan, Pawanputra, Mahaveer, and Anjaneya. Hanuman ji is the son of Bhagwan Vayu, the wind god.

God Hanuman played a prominent part in rescuing Mata Sitafrom the bondage of demon King of Lanka, Ravana.


One can worship Hanuman ji by chanting Hanuman Mantras. There are many different types of Hanuman Mantras, each fulfilling a specific purpose. Hanuman Mantras help to beget the blessings of Mahabali Hanuman for success. 3/n


Let’s explore these powerful Hanuman Mantras one by one. Here’s the list for you:

1. Hanuman Moola Mantra
!! Om Hanumate Namah !!
ऊँ हनुमते नम:

You can chant the “Hanuman Moola Mantra if you usually face problems and obstacles in your life.4/n
#hanumanjanmotsav


However, the Human Moola Mantra is also a very powerful success mantra.

It’s a Kaarya Siddhi Mantra.

It is highly advised that all those who usually face obstacles and problems in their life should chant the Hanuman Moola Mantra. 5/n
#hanumanjanmotsav
ALL
Advertisement
Jaya_Upadhyaya
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🙏🏻
ALL
Ax
Ax
@AchuthArora
@powerbeastt @buzz_chronicles @rattibha @SaveToBookmarks save as Movies
ALL
Colby Kultgen
Colby Kultgen
@thecolbykultgen
The 7 Habits of Highly Effective People has sold more than 40 million copies.

Don't have time to read it?
—No worries.

Here are the 7 key lessons you should apply:


Habit #1 — BE PROACTIVE

It all starts with action.

Rather than being "reactive" (externally influenced).
Focus on being "proactive" (initiative-taking).

This puts you in firm control of your life.


Habit #2 — BEGIN WITH THE END IN MIND

"No wind is favorable if one does not know to which port one is sailing."

I use this goal-setting system to stay on track myself:

Who do I want to be --> Monthly goal to achieve it? --> Daily action to reach that goal?

I update weekly.


Habit #3 — FIRST THINGS FIRST

Knowing the work that moves the needle is half the battle.

The Eisenhower Matrix can come in handy here:

Urgent + Important - Do it
Important + Not urgent - Schedule it
Urgent + Not important - Delegate it
Not urgent + Not important - Delete it


Habit #4 — THINK WIN-WIN

Always strive to find a mutually beneficial solution.

How to:
- Be as objective as possible
- Try to see from their perspective
- Determine what a "win" truly means for both parties
- Work to find the best solution for both parties
ALL

You May Also Like

Shalini Singh Sengar
Shalini Singh Sengar
@Maverickmusafir
(An extract from Field Marshal Sam Manekshaw, Soldiering with Dignity)

The man eventually destined to be free India's first Field Marshal was born on 3rd April 1914 at Amritsar. How did a Parsi couple settle for the holy city of the Sikhs? I once asked him and was told that in+


1899, his father recently qualified as a doctor and just married, could make no professional headway in Bombay, and was advised to try his luck at Lahore in the Punjab. With his young wife, he set off by train for Lahore. The long dusty and hot journey took five days and by the+


end of it, his young wife, who had never left the comforts and civilization of Bombay, was in hysterics and cried to go back. Poor Dr Manekshaw did all he could to comfort her, but as the train steamed into Amritsar, with her first sight of the Sikhs the young bride screamed her+

lungs out and refused to go any further. So they left the train at Amritsar, and there they stayed for forty-five years.

The Manekshaws had six children, four boys and two girls, and Sam was the fifth child. Sam had his schooling at Nainital's Sherwood College.+

After completing his schooling, he should have gone to England to pursue higher studies; this was the promise made to him by his father but, fortunately for the Indian Army, Dr Manekshaw felt that this particular son was far too young to be on his own in a foreign country, even+
HISTORY
Anshul Pandey
Anshul Pandey
@Anshulspiritual
IMPORTANCE, ADVANTAGES AND CHARACTERISTICS OF BHAGWAT PURAN

It was Ved Vyas who edited the eighteen thousand shlokas of Bhagwat. This book destroys all your sins. It has twelve parts which are like kalpvraksh.

In the first skandh, the importance of Vedvyas


and characters of Pandavas are described by the dialogues between Suutji and Shaunakji. Then there is the story of Parikshit.
Next there is a Brahm Narad dialogue describing the avtaar of Bhagwan. Then the characteristics of Puraan are mentioned.

It also discusses the evolution of universe.( https://t.co/2aK1AZSC79 )

Next is the portrayal of Vidur and his dialogue with Maitreyji. Then there is a mention of Creation of universe by Brahma and the preachings of Sankhya by Kapil Muni.


In the next section we find the portrayal of Sati, Dhruv, Pruthu, and the story of ancient King, Bahirshi.
In the next section we find the character of King Priyavrat and his sons, different types of loks in this universe, and description of Narak. ( https://t.co/gmDTkLktKS )


In the sixth part we find the portrayal of Ajaamil ( https://t.co/LdVSSNspa2 ), Daksh and the birth of Marudgans( https://t.co/tecNidVckj )

In the seventh section we find the story of Prahlad and the description of Varnashram dharma. This section is based on karma vaasna.
RELIGION
Advertisement
Anu Satheesh \U0001f1ee\U0001f1f3
Anu Satheesh 🇮🇳...
@AnuSatheesh5
Agastya Muni & Kaveri River
#story
This is a story which describes how River Kaveri was brought on earth by Agastya muni. There was a king named Kavera lived in the Brahmagiri hills who prayed to Brahma for a child. He was blessed with a daughter whom he named Kaveri.


Agastya muni married her. A demon, named Shoorapadma, wanted to trouble people so he prevented rain from reaching South India. As a result famine occurred in South India.
Agastya Muni who came that way was very sad seeing this. He started to pray Mahadeva for a solution.


Shiva gave him small amount of Ganga water in his Kamandalu (small pot) and said wherever you spill this water the river will flow from there. Agastya Muni travelled lot of places to find a suitable place to pour water. Feeling tired he kept his Kamandalu and took rest.


At that time Ganesha took a form of crow and perched on the Kamadalu and made a hole that water began to flow as river Kaveri. This place is now called as Talakaveri (Karnataka), located in the Brahmagiri hill.


Tala Kaveri has temple for Agastheeswara, which denotes the story between Kaveri and Agasthya muni. Kaveri is a part of Ganga, thus, also called Dakshina Ganga.
🙏🕉🙏
ALL
Fidato
Fidato
@tequieremos
A thread on the life and achievements of Muhiyudin Sayyid Abdul Qadir Jillani RadiAllah who served Islam infinitely as the Reviver (Mujadid) of the 11th Century!


Muhiyudin Sayyid Abdul Qadir Jilani (RA) was one of the greatest Islamic Saint, Scholar, and Jurist. The honorific Muhiyudin denotes his status with many Sufis as a "reviver of religion". Jilani refers to his place of birth. He also carried the epithet Baghdadi.

[1]

Sheikh Abdul Qadir Jilani was born on the eve of the 2nd of Ramadan 470 AH. His birth was a great blessing for the Ummah. It was the arrival of the Sultan al-Awliya (King of the Awliya) of that era, which had been foretold for centuries before his birth.

[2]

When Hazrat Abdul Qadir Jillani was asked by someone what brought him to his high spiritual level, he said, The truthfulness which I promised to my mother. He related the following story:
"One day, on the eve of Eid al-Adhā, I went to my mother, who was then a widow and..

[3]

..and requested her, 'Send me to the path of Truth, give me permission to go to Baghdad to acquire knowledge, to be with the wise and those who are close to Allah. She cried, but she brought out 80 pieces of gold, which was all that my father had left as inheritance.

[4]
RELIGION
Alex Stamos
Alex Stamos
@alexstamos
The entire discussion around Facebook’s disclosures of what happened in 2016 is very frustrating. No exec stopped any investigations, but there were a lot of heated discussions about what to publish and when.


In the spring and summer of 2016, as reported by the Times, activity we traced to GRU was reported to the FBI. This was the standard model of interaction companies used for nation-state attacks against likely US targeted.

In the Spring of 2017, after a deep dive into the Fake News phenomena, the security team wanted to publish an update that covered what we had learned. At this point, we didn’t have any advertising content or the big IRA cluster, but we did know about the GRU model.

This report when through dozens of edits as different equities were represented. I did not have any meetings with Sheryl on the paper, but I can’t speak to whether she was in the loop with my higher-ups.

In the end, the difficult question of attribution was settled by us pointing to the DNI report instead of saying Russia or GRU directly. In my pre-briefs with members of Congress, I made it clear that we believed this action was GRU.
TECH