5 Excel Skills You Can Learn Today and Show Off on Monday: 📊

1. Tables + TEXTJOIN

• Select Range
• Format as table
• Combine Name Using TEXTJOIN

Note –– Changes to the formula will carry throughout the table.

There are currently over 1.86 Billion websites.

Few provide any real value.

Here are 7 that do: 🧵

1/ Attend the Ivy League:

Always thought it would be cool to go to an Ivy League school?

Here's your chance.

Free lecture notes, exams, and videos from

2/ Millions of books: Available for free.

Booklists seem to be all the rage recently on Twitter.

(I'm guilty of posting a couple myself)

Instead of a list, here's a link to a library full of them.

The goal:
"A web page for every book ever

3/ Talks from a wide-ranging group of thinkers & doers.

If you enjoy TED, you should check out 99U "The Talks."

Past speakers include executives and creators from the New York Times, Netflix, Google, &

4/ I love documentaries.

As you know, many can be found on the major streaming services.

What you may not know? There are literally thousands of others available for free.

Here's a good place to

This thread will make you better at Outlook: 📬

Color code your emails:

I like to keep things organized.

I'm forgetful & I get A LOT of emails.

The easiest way I've found to ensure things don't get lost is utilizing conditional formatting.

• View -> View Settings
• Conditional Formatting
• Select type
• Name the rule

Never miss a game:

Did you know you can add custom event calendars directly in Outlook?

Never miss your favorite TV show or the next big game.

• Just head to "Add Calendar"
• Select "Sports" or "TV"
• Choose the event you'd like to add.

Send delay:

Sometimes you need to write a message now but wait to deliver it until later.

Just use "Delayed Delivery."

Here's how:

• Write your email
• Select Options -> Delay Delivery
• Choose the "Do not deliver before" time

Email your calendar:

Avoid the back and forth hassle of scheduling meetings.

Simply email your calendar so people know when you're available (and when you're not.)

You can also drag items from the received calendar to your own.

Like this:

What do the world's greatest leaders know about the power of persuasion that you don't?

THREAD: How you can unlock the ability to change anyone's mind.

Let's get smarter... 👇🏻

1/ As far back as the mid 300's BC, humans were fascinated by the power of persuasion.

In light of this, Aristotle developed what is known as the "Rhetorical Triangle."

A framework for persuading any audience using 3 simple appeals:

•Ethos
•Pathos
•Logos

Let's dig in...

2/ Ethos (Ethics / Character)

The first of the 3 appeals, Ethos speaks to the perceived character of the speaker.

In order to persuade anyone to do anything, they must first believe you are a credible and trustworthy source.

How do you accomplish this?

3/ Establishing Ethos: (1)

•Language: Choose verbiage that is fitting to the subject matter and audience you are trying to persuade.

•Pedigree: Do you have specific credentials or education relating to the topic being covered? If so, make it known.

👇🏻

4/ Establishing Ethos: (2)

•Rapport: Your audience must feel as though you are "in sync."

You understand and can relate to their feelings or ideas.

TL;DR

•Choose the right language
•Communicate pedigree
•Build Rapport

Trust becomes a byproduct.

Let's see an example 👇🏻

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.

Sri Gurubhyo Namah.
Some tweets on Adi Shankaracharya and in particular the Guru Parampara of @sringerimath. [I had done this series earlier 5 years ago on account of Shishya Sweekaram].

Adi Shankara established the Sringeri Peetham as the 1st of 4 amnaaya peetams.

The four being
1. Sarada Peetam at Sringeri.
2. Govardhana Peetam at Puri
3. Kalika at Dwaraka
4. Jyothir at Badarikashramam.

He installed his 4 most prominent shishyas as heads of the peetams.

Sureshwaracharya was assigned to Sringeri as its head.

Sringeri is a corruption of Rshyashrunga giri.

Rshyashrunga maharshi [and his father Sri Vibandhaka Maharshi] did their tapas at this place.

It is at Sringeri that Shankara spent 12 of His precious 32 years!!

That gives you and idea how much He loved this place.

Rshyashruga maharshi had a horn on his forehead, a result of being born to a deer. His mere presence was enough to shower rains!!

Rshyashrunga was one who led Putrakamesthi Yaagam of Dasaratha Maharaj and which resulted in Sri Rama's birth!!

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

RANI GAIDINLIU:THE LESSER KNOWN FREEDOM FIGHTER

Rani Gaidinliu joined the freedom struggle at 13 &was sentenced to life imprisonment at 16."We r free people—the White should not rule over us.”Thus calling out to her Zeliangrong tribesmen was the voice of 13yr-old Rani Gaidinliu.

She joined the freedom struggle in the present-day Northeast India. Today, her struggle is lost in history as most of her countrymen wouldn’t even have heard her name. B'coz our history textbooks tell us that only Mahatma Gandhi &Pandit Nehru got India its Independence.

At 16 yrs of age, this valiant girl was sentenced to life imprisonment for leading a movement to drive out the colonial rulers from Manipur and Nagaland. Nevertheless, she was released in 1947 after India’s independence and was given the title ,"Rani of Nagas".

EARLY LIFE AND HERAKA MOVEMENT

Gaidinliu belonged to the Rongmei clan of the Zeliangrong tribe in the Tamenglong district of western Manipur. Born on January 26, 1915, she was fifth among eight children.

Her native village was Nungkao, which is present day Tamenglong distt. Brought up in a specially backward region,she couldn't receive any formal education. However,this didn't stop her from joining the freedom struggle. At the age of 10 she came under the influence of her cousin.

Mahabharat - the great war - 18 days of heroism, deceit, blood and intrigue - now as a mega Twitter thread.

I'll add the events from a few days of the war each day.

Caveats: lots of editorialization, creative liberties and interpretations.

There will also be a lot of asides - especially around war strategy and tactics, the characters and their motivations and non-canon storylines.

Over the years, I've read multiple versions, phenomenal translations and modern retellings. So be prepared for a potpourri.

There are different ways of looking at this war. Was it a family feud? Sure - but whose family? Shantanu's or Satyavati's? Was Vyas essentially telling us his family history? And then Kunti added a twist to this tale. Here's a helpful chart:

Satyavati's two sons from Shantanu both died without children. Vyas - her first son - fathered Dhritarashtra and Pandu (and Vidur).

Pandu never fathered any children. Kunti and Madari gave birth to six demi-gods (Karna and the five Pandavs).

So Satyavati Vs Kunti and Madari.

Or was this a fight between two massive neighbouring kingdoms - the Kurus and the Panchals? While many smaller kingdoms joined the battle, most of the Pandav army (more than half of their 7 divisions) came from the Panchals. King Drupad and his son Shikhandi led two divisions.

@AchuthArora @aldothetrainer @Artofphysique_ @buzz_chronicles @rattibha Gotcha, boss!

Your tweet has been saved.

Please sign up with savetobookmarks .com in order to view and manage your bookmarks.