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

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:

Think crypto is confusing?

You're right.

Let's make it easier.

Here's Crypto Terminology 101: 🧵

Altcoin:

Any coin that's not #Bitcoin

Ether (#ETH) is the second most popular coin overall and the most well-known Altcoin.

Ether is the native cryptocurrency on the Ethereum blockchain.

There are thousands of other altcoins, but for now, this is the one to know.

Bitcoin: (#BTC)

The first decentralized digital currency.

Launched in 2009 by an unknown person or organization known only as "Satoshi Nakamoto."

It is the most famous, and most valuable cryptocurrency.

Blockchain:

The core tech behind Bitcoin and most other cryptocurrencies.

An open, distributed, general ledger where transactions are organized into blocks which are then connected using cryptography.

Coin:

A store of digital value that lives on a blockchain.

Some blockchains, such as Bitcoin, use the same name for both the network and the coin.

Stable coins are another type of cryptocurrency which are backed by fiat currency (e.g the US dollar) or commodities such as Gold.

The ultimate guide to Gmail, Gsheets, and Mac Productivity:🧵

📊 -Explore:

Need to do some number crunching?

Let Google's AI do the work for you.

•Highlight the range of data.

•Move your cursor to the starburst-shaped icon in the bottom right corner.

•Click "Explore" – Charts, analytics, & detailed info. generated automatically.

📩 -Look like you're working (when you're not)

Gmail offers scheduling... Who knew?

No need to be physically sitting at your desk, or hammering out emails on your phone after hours.

•Compose your message
•Click the dropdown next to "send"
•Click "schedule send"

💻 -Specific Screenshots:

SHIFT+CMD+3 will capture your entire screen.

Did you know you can also narrow your capture to a specific portion?

It's easy, & now that I know it exists, I use it every day.

A simple SHIFT+CMD+4 and you're on your way.

📊 -Finance:

Monitor stock prices, spot trends, & quickly review historical data using =GOOGLEFINANCE.

Want to see the last 60 days of closing prices for a specific ticker symbol?

Paste the formula below & voila!

=GOOGLEFINANCE("NASDAQ:TSLA","price",TODAY()-60,TODAY())

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

WHY BABUR NEVER TRIED TO ATTACK SRI KRISHNADEVARAYA ?

A🧵u must read

It is very well known that Babur considered Krishna Dev Raya as the strongest ruler of the entire subcontinent, and Vijayanagar empire the strongest during that time in India.

1/10

The Vijayanagar empire reached its peak during 1509-1529 around the reign of Krishna Dev Raya.

Vijayanagar’s famed elephant brigade 👇

2/10

At his command there were over 50000 elite troops with a regiment of Portuguese gunners and 3200 cavalry with 600 elephants.

3/10

Along with that more than four hundred thousand ( four lakh) peasant levies and irregular military made this empire one of the largest in all of South Asia.

A typical Vijayanagar levie soldier 👇

4/10

During Baburs invasion, Krishna Dev Raya ruled supreme in all of deccan.

In fact, in an all our brawl, Krisha Dev Raya will beat Babur fair and square.

Babur could muster at max 50000 troops with 50 canons.

While Krishna Dev Raya had these numbers in Hampi alone

5/10

Again sharing bank nifty intraday weekly straddle. How to play by selling straddle.
Mostly will work on Monday to Wednesday. Sometimes on Friday.
Why to pay your money to learn this if u can get it here.
U need only practice.
Let’s go.

Say bank nifty future is at 32000.
Sell both 32000 call and put.
Considering current volatile market lest say premium on Monday morning is 350 on both sides.
Sold with 700 points combine premium.
If bank nifty will trade in narrow range say +\- 100 hold it.
If moving 200 points

then exit previous sold straddle. Sell new one. Let’s say BN moved +200
Now sell 32200. If bank nifty will move here within range then u will get profit through theta decay. Follow same procedure for next 150-200 pts move.

This is only for single straddle sell position.

Now in second case sell three straddle. 31900/32000/32100
In case of 100 points move no need to change.
If 200 + then future is 32200.
Exit 31900 and sell 31200 straddle.
If moving another 100 then exit 32000 and sell 32300. Continue same with 100 points move.
If no move then

it will consolidate between 32000-32200 or 32100 to 32300 and u will get theta decay.

This is for normal move. Sudden big move may come anytime. So keep SL in system.
If u r selling at 350-350 then keep SL in system 475 for both legs.
Practice it. No need to attend webinar.

#Thread
An interesting story of Kamala Devi hazarika for all Sanatanis...🙏

A Xtian missionary was sent to Assam for the promotion of religion. His name was Cruz. He came across to one the boys from an influential family in Assam to teach him English.
@noconversion

Cont 👇

The p@stor slowly began to study the house and he learned that the boy's grandmother was the most influential person in the house. So he thought 'Corrupting the grandmother's mind can make the whole family Xtian as well as the whole village.

Cont 👇

The p@stor began to tell Grandma the stories of how J€$u$ cured leprosy of lepers, how He gave sight to the blind, etc..But after listening to him, the strong Sanatani grandmother said. A stone turned into a living woman (Ahalya) for our Rama when he touched the stone.

Cont 👇

She spoke of Rama setu where stones floated in sea just by writing his name on the stones and that they are still floating today.
The p@stor continued his efforts but all his tricks went in vain.

Cont 👇

One day he had brought a cake from the church and he thought of offering it to grandmother but he was doubtful that she would eat it. But contrary to his expectation, she took the cake and ate it.

Cont 👇

9 Python resources that will fast-track your learning

🧵👇

1️⃣ Introduction to Python Programming

✔️ Learn to solve practical problems with Python
✔️ Enhance your skill set
✔️ Boost your hirability through innovative, independent learning.

2️⃣ Introduction to Computer Science and Programming Using Python

✔️ Introduction to computer science
✔️ A tool to solve real-world analytical problems
✔️ Computational thinking and Data

3️⃣ Learn Python the HARD WAY

✔️ The Hard Way Is Easier
✔️ Learn Python through 52 exercises
✔️ Starting from

4️⃣ Python for Everybody Specialization

✔️ Learn to program
✔️ Analyze data with Python
✔️ Gather, clean, analyze, and visualize

@AJA_Cortes @buzz_chronicles @rattibha @SaveToBookmarks save as Workouts