There are plenty of ways to waste time online.

You already know those.

Instead, here are 7 sites that will make you more productive––not less: 🖥

Things don't get easier.

We get better.

THREAD: 10 principles to narrow your focus, conquer your fear, and overcome life's obstacles.

1/ Narrow your focus

Time is finite.

It is both our most valuable resource & the one we are most likely to waste.

Ask yourself:

Of the things I say are important to me, which am I willing to take immediate action toward?

Focus on these. Start today.

2/ Fear (Part 1)

A few years ago, after trying to convince the owner for months, I was given the opportunity to run a business.

One day she walked in and said:

"OK, you told me you could do it, it's yours. You start tomorrow."

I was scared to death.

I wanted out.

👇🏻

3/ Fear (Part 2)

I had exactly what I asked for, but fear was taking over.

What if I fail? People will laugh.

What if I succeed? Can I continue to meet these new expectations?

2 years later, we were the most profitable we'd ever been.

Don't let fear be a limiting force.

4/ No straight lines

Don't expect your journey to be linear.

We all map out in our minds the ideal path from where we are to where we want to be.

The secret lies in being able to roll with the punches.

Those who do great things adapt, overcome, and color outside the lines.

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.

Everyone wants to tell you what to do.

Not me.

I'm going to tell you what NOT to do.

10 career mistakes I've made––so you don't have to:

Quit focusing solely on compensation.

Money and benefits are nice, but they're not everything.

Environment, advancement opportunities, and overall quality of life are far more important in the long run.

Instead of asking "how much can I make," ask "how much can I grow."

Don't get too comfortable.

You've been at your job for years.

You can do it with your eyes closed and both hands tied behind your back.

That doesn't mean you should.

Don't let 5-10 years slip away due to complacency.

Take control, challenge yourself, level up.

Don't be afraid to fail.

I'll take an employee who is willing to try over one who is not, every single time.

Good managers expect some level of failure within each project, in fact, they plan for it.

Put yourself out there, take a chance, it's the only way you'll advance.

Quit trying to do it alone.

People want to help.

Toiling endlessly on a project when you're unsure what to do next only makes you look inefficient.

Asking for help doesn't mean you're incapable, it means you're invested and shows you care.

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: 👇🏻

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.

2. Organize With Multiple Slicers

• Select Range
• Format as Table
• Insert Slicers of Your Choice

Select individual or multiple categories at the same time.

To select multiple click+drag or select the ✅✅✅ box.

Click the funnel to unfilter.

No need for a pivot table!

3. Quick Interactive Charts

• Select Range
• Format as Table
• Insert Slicer
• Insert Chart

Like this: 👇🏻

4. Custom Text & Icon Sets

• Create Custom Text
• Choose Icon Sets
• Apply Conditional Formatting

No one else in your office is doing this!

5. Pivot Table Grand Total Percentage

Convert numeric values to show as a percentage of the grand total.

• Select Range
• Create Pivot Table
• Right-Click On Data
• Select "Show Values As"
• Percentage of Grand Total

I have earlier shared some setups/strategies for Intraday. One of them was ORB (opening range breakout) setup.. but I still get DM about this. So here's a thread about how to find ORB stocks: (1/12)

Stocks that are in consolidation or on the verge of a breakout and has already given a breakout from consolidation - both category stocks should be in your watchlist.

Now the question is.. with so many stocks around, how one must filter and check? (2/12)

I mostly trade in F&O stocks in Intraday - it has 188 stocks after new addition and can be filtered as per sector rotation.
Find the sector or theme with good recent performance and keep its stocks in watchlist. I keep an alert for breakout price when I see a good chart. (3/12)

Another way to filter stocks is to keep an eye on the new additions in the F&O and the stocks that are in news.

Not every stock gives a move of 7-8%. Look for stock that move 7-8% in one go when they give a breakout (Stocks unlike ITC that moves once in a year). (4/12)

There are a few stocks that are tailor made for ORB. And those stocks should be in your watchlist.
IRCTC, Mindtree, Bajaj Twins, IEX, TataElxsi, Naukri, Coforge are some great examples. Rest you can observe and add.
Recent examples 👇(5/12)

TREND TEMPLATE CRITERIA by the Legend @markminervini

A stock must meet all eight criteria to be deemed in a confirmed stage 2 uptrend.

1. Stock price is above both the 150-day (30-week) and the 200-day (40week) moving average price lines.

A Thread🧵

2. The 150-day moving average is above the 200-day moving average

3. The 200-day moving average line is trending up for at least 1-month (preferably 4 to 5 months or longer).

4. The 50-day (10-week moving average) is above both the 150-day and the 200-day moving averages.

5. The current stock price is at least 25 percent above its 52-week low. (Many of the best selections will be 100 percent, 300 percent, or more above their 52-week low before they emerge from a healthy consolidation period and mount a large-scale advance).

6. The current stock price is within at least 25 percent of its 52-week high
(the closer to a new high the better).

7. The relative strength (RS) ranking (as reported in Investor's Business
Daily) is no less than 70, but preferably in the 90s, which will generally be the case with the better selections.

Stocks with super improvement in Financials as per latest quarterly results and strong price action.

I've used Microsoft Excel for 20 years, and these 20 tips & functions will make you an expert and increase your productivity 100X📊

Don't ever use Excel again without knowing these 20 tips & functions:

Here are 20 MUST KNOW Microsoft Excel tips & functions (with pictures & examples of each below):

(1) Wildcards
(2) Duplicate
(3) Remove Duplicates
(4)Transpose
(5) Filter
(6) Conditional Formatting
(7) Sparklines
(8) Pivot Tables
(9) Auto-fill
(10) TRIM

11-20:

(11) XLOOKUP
(12) IF
(13) SUMIF
(14) SUMIFS
(15) COUNTIF
(16) COUNTIFS
(17) UPPER, LOWER, PROPER
(18) CONVERT
(19) Stock Market data
(20) Geography / Maps

Let's discuss each in detail (with pictures & examples):

(1) Wildcards

A wildcard is a special character that allow you to perform partial matches on text in your Excel formulas.

Excel has three wildcards: an asterisk "*", question mark "?", and "~"

(2) Duplicate

Duplicate the data from the cell above.

Ctrl + D fills and overwrites a cell with the contents of the cell above it

Semi conductor index is often considered a leading indicator of health of the economy

Micron: 'we see upcoming significant sequential declines in revenue & margins'

Nvidia: 'Will slow down hiring & control expenses as the company deals with a challenging macro environment'