9 hidden Chrome features guaranteed to make your life easier: 🖥

This thread will make you better at Excel: 📊

Automatic Abbreviations:

If you're like me, autocorrect is more of an annoyance than a help.

Let's change that.

Set up your own custom list of abbreviations, and bend its powers to your will.

Type 'TBD'
Press 'Enter"
Output = 'To be determined'

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.

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! 🤯

People Graph:

I'm a big fan of visual representations of data.

Using 'People Graph' is an easy way to liven up your spreadsheet, especially when tracking metrics related to, well, humans.

Create an infographic to visualize social media engagement, app users, customers, & more.

20 of the smartest things that have ever been said: 🧵

"Holding onto your anger is like drinking poison and expecting the other person to die.”

–Buddha

“We are what we repeatedly do, Excellence is therefore not an act but a habit."

–Aristotle

"Look at a day when you are supremely satisfied at the end.

It's not a day when you lounge around doing nothing; it's a day you've had everything to do and you've done it."

–Margaret Thatcher

“There are only two great tragedies in life: one is not getting what you want and the other is getting it.”

–Oscar Wilde

10 can't miss Excel skills every single user should know: 📊

Custom Lists:

Stop wasting time entering the same customer names, product types, and generally repetitive data.

Creating custom lists is easy.

• Excel
• Preferences
• Custom Lists
• Create and click "Add"

Type the first item, then drag, and the rest of your list appears!

Data Types:

Data Types is a relatively new feature that was added to Excel in 2020.

It allows you to enter text, select data type, then extracts information based on the criteria you select.

Here's a pretty cool example using states where we can pull population data instantly:

SORTBY:

I'm a fan of organized data.

What I'm not a fan of?

Manually updating my sort every time something changes or new information is added.

Here's an easy fix.

With the SORTBY function, we can create a table that dynamically adjusts along with our data in real-time.

Unique:

Back in the day, Pivot Tables were my go-to for identifying unique items within large data sets.

Not anymore.

Now I use the "Unique" function in MS365 to easily identify and separate repeated items.

So simple.

Don't blink or you'll miss it:

How to quickly remove blank rows & duplicates in Excel: 📊

• Select Range → Find & Select
• Go To Special → Blanks → CTRL –
• Data Tab → Select Columns To Review
• Remove Duplicates

Done!

If you like these tips, you'd probably like my newsletter as well.

Just sayin'

Join 21K others and sign up for free here:

Want to learn the basics of Excel?

Not sure where to start?

Try

My Basic Trend Following system :

EMA-9> EMA>21>EMA> 63> EMA> 200.

RSI > 55

Weekly bases - Minimum 4 weeks.

Volume up by 200% .

Some others point to note :

Institutional sponsorship must.
Leading group
Annual Growth > 15 %
Quarterly growth > 15%
PEG <2.5

Swing Trading Strategy
That can help you generate Monthly Income !
A thread 🧵
Using RS , MACD , 21 EMA and Price Action
All Concepts with charts Explained !

RETWEET AND SHARE !

UNDERSTANDING MACD
Moving average convergence divergence (MACD) is a trend-following momentum indicator that shows the relationship between two moving averages of stock.
It is calculated by subtracting the 26-period exponential moving average (EMA) from the 12-period EMA.
2/n

The result of that calculation is the MACD line. A nine-day EMA of the MACD called the "signal line," is then plotted on top of the MACD line, which can function as a trigger for buy and sell signals.
3/n

Traders may buy the security when the MACD crosses above its signal line and sell—or short—the security when the MACD crosses below the signal line.
4/n

UNDERSTANDING RELATIVE STREGTH
1.Relative strength is a strategy used in momentum investing and in identifying value stocks.
2. It focuses on investing in stocks or other investments that have performed well relative to the market as a whole or to a relevant benchmark.
5/N

My past experience tells me to turn cautions on any asset class, the moment #GOLDMANSACHS gives incremental target when , it has already run towards extreme
As #GS sees #CrudeOil at 140 , I rein in my one-way Bullish optimism, I have been bullish since 40s-60s, 120 now
#OOTT

A thread of strength in the market.

An analysis which I did during Covid crash with @MashraniVivek on which sectors and stocks were strong, and we did pick pharma, chemical early cycle. Though we do not know where market is heading, doing such exercise always helps to find

strength when market bottoms. Of course, it requires much more reading and conviction building and hence should be taken only as a starting point. Here is how this list has been generated
1. Pick top 500 companies
2. Find list of companies which have fallen < 10% in last 3 months

Totally 61 out of 500 stocks.
This is how the sectors come up.
✍️Auto and Capital Goods stand out
✍️Do not ignore defence for sheer count as there are few companies in sector
✍️Next pocket looks like few beaten down sectors/stocks where may be value is emerging - FMCG, Pharma

List of stocks - Auto tops the list followed by capital goods, bank and financial, pharma and defense. Disc: I am biased towards auto n financials (keeping FII selling risk aside). Also, this is still a watchlist activity and I am not acting on it except being

invested in few auto n banking names. Please do your own due diligence. I am not a registered investment advisor and this is not a recommendation. Follow @ScientificInve6 and our Youtube channel for more such