This thread will make you better at Excel: 📊

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

10 powerful Excel features every user should know: 📊

Flash Fill:

Let's say you've got all the data you need––it just isn't in the right place.

"Flash Fill" is your friend.

Quickly extract pieces of text from one cell and move them to another OR combine text from multiple cells into a single place.

Camera Snapshot

Here's a little-known trick to move data between workbooks.

First, add "camera" to your quick access toolbar.

•Select your data ⇢ click 📷
•Paste to new workbook

The cool part: When you update the main workbook, the data in the picture updates as well! 🤯

Analyze Data:

I was never very good at Pivot tables, graphs, & analyzing data on my own.

Lucky for me (and you) Excel will do the heavy lifting for us.

•Select the range of data
•"Home" ⇢ "Analyze Data"

Charts, tables, & analysis––premade.

Click "insert" & you're done!

X-Lookup

If you're an old-school Excel user, there's no doubt you're familiar with V-Lookup.

X is the new & improved version, here's why:

•Lookup array does NOT have to be only on the left-hand side.
•Allows you to return multiple values at the same time.

Here's how: 👇🏻

3 Excel Tips you can master in 3 minutes each: 📊

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:

Defined Cell Names:

Formulas in Excel are extremely useful.

That said, they can also be quite confusing.

By defining cell names, you can make them much more user-friendly and easier to read.

Instead of seeing = 'A3-B3'
You'll now see = 'Revenue-Cost'

Check it out:

Consolidate:

Take data from multiple tabs.

Consolidate into one.

Sum, average, count, it's your choice.

By creating links to the source data, your consolidation tab will update automatically.

The best part? No formulas required.

Last:

If you really want to get better at Excel, you can't afford to miss this.

I'll keep it simple:

✅ Most jobs require basic Excel skills.
✅ More skills = More money 💰

Signups Open Now!

You'll get better at Excel with these 8 simple tips: 📊

Print Titles:

Printing a worksheet with several pages?

Want the header to repeat at the top?

You could go to:

Page Layout-> Page Setup-> Sheet-> Rows to repeat at the top-> Select rows

Slooowww!

Instead, select the top row & type:

'print_titles' in the cell name box

Done!

New Window:

I bet you've had times when you wanted to compare items within the same sheet side by side...

There are a few different ways to do this, but my favorite is the 'New Window' feature.

Open 2 instances of the same file & review and edit as you like.

Fast Filters:

Most people know how to create a filter based on a cell's value (the slow way).

What if I told you that you can:

Apply a filter to an entire sheet & filter by a selected cell at the same time?

You can

Select the cell->right click->filter by selected cell value.

Center Across Multiple Cells:

Merged cells are notorious for creating problems.

Here's a quick trick I use to still get the look I want while retaining individual cells behind the scenes.

Select the range
Right-click->Format Cells
Horizontal Alignment
Center Across Selection

Ｇａｕ Ｍａｔａ Ｉｎ Ｖｅｄｉｃ
Ｃｕｌｔｕｒｅ

It is said that the one who bears the dust thrown from the hoof of Gaumata on his head, as if taking a bath in the water of the teerth sthalam and getting rid of all sins.

Ved and all other Hindu scriptures venerate the cow. The Vedic dictionary, Nighantu, gives amongst other synonyms of 'Gau' [ or cow] the words 'Aghnya', 'Ahi', and 'Aditi'.

Yaska the vedic decoder and commentator on Nighantu, defines these as-

Aghnya —— the one that ought not to be killed
Ahi —— the one that must not be slaughtered.
Aditi —— the one that ought not to be cut into pieces.

These three names of cow signify that this is an animal which should not to be put to tortures. These words appear frequently throughout the Veda in context of the cow.

But in due course the falsehood of killing cows spread far and wide and they became even more deep rooted when western scholars with their half baked knowledge of Sanskrit transliterated these interpretations of commentaries of Sayanacharya ,

Thread on
"Intraday Banknifty Strangle based on OI data"

(System already shared, today just share few examples)
(1/n)

-Trade timing after 9:45

-Check Banknifty change in OI data at 9:45, and identify the highest OI built up in call side and put side

-We will sell both strikes with combined premium as SL on both legs.
(2/n)

28th June 2021

BN open-35440
At 9:45 trading at 35350
Highest OI in call side at 35500 CE and 35000 at put side
Strike selection 35500 CE- 35000 PE
(3/n)

29th June 2021

BN open-35323

At 9:45 trading at 35112

Highest OI in call side at 35300 CE and 35000 at put side

Strike selection 35300 CE (232) - 35000 PE (150) Combined premium 382 , Both legs SL 382
(4/n)

30th June 2021

BN open-35030

At 9:45 trading at 35002

Highest OI in call side at 35000 CE and 35000 at put side

Strike selection 35000 CE(176)- 35000 PE(213) Combined premium 389 , Both legs SL 389
(5/n)

1. #Qanon told us that Saudi Arabia is a central piece of the puzzle in taking out the Deep State...we are watching the Deep State attempt to remove Crown Prince MBS and disrupt Pres Trump's administration's ties with MBS and the "new" Saudi/US coalition. Early in his admin,

2....@Potus sent Jared Kushner (JK) to SA on an undisclosed trip and told King Salman that business as usual was over, and if he wanted Pres Trump's support, Prince Alwaleed would have to be divested of $ and power; Alwaleed is one of top Deep State $ men and was tied to HRC.

3. @Potus knew that before he could begin cleansing the US and the rest of the world of the DS, he would have to cut one of the financial head's off the snake (Alwaleed). After JK met w/ King Salman, Alwaleed was arrested and divested of billions; MBS became leader of SA.

4. SA loves Pres Trump because he's a man of his word; SA could not trust Hussein or Clintons because they use SA for oil and leverage; SA has many factions, but essentially you have the new and upcoming SA that is attempting to modernize through Crown Prince MBS, and then you

5...have the old guard represented by Alwaleed who was one of the Deep State financial heads and loyal to the DS more than SA; SA knew Hussein was financing Iran to hold western world hostage, and SA was caught in middle of Deep State black mail; this is why @Potus was celebrated

Cortisol will ruin you

If you let it get away from you, chronic stress will lead to chronic disease and chronic disease will lead to early death

What are the best ways to lower cortisol?

1) Don't follow extreme diets

Cutting out all carbohydrates or fasting for 36 hours is going to wreak havoc on your stress hormones.

Although you may experience short term weight loss, it's going to hurt you in the long-term.

A balanced macronutrient ratio is best to aim for.

2) Get out in nature

Idc if you live in Alaska or Guatemala, connecting with nature daily will do more for your health than any biohack ever will

Reconnect to your ancestral roots and make it a habit.

Grounding/earthing, forest bathing, hikes, ocean swims, etc

3) SLEEP

You CANNOT neglect your sleep. I don't care how tough or alpha you think you are. It will eventually catch up with you.

@holisticnicola just released a great guide on sleep. Go check that out now as I read it and agree with everything inside.

MAKE THIS A PRIORITY

4) Improve your testosterone

Anything that improves your testosterone levels will decrease cortisol.

Here's a start:
-lower body fat
-eliminate PUFAs
-resistance training
-no alcohol
-sleep 8+ hours
-nutrient dense diet
-do cool shit

@SethAbramson @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