BC READING
Saved by @paro_monty

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

One of my personal favorites.

Sparklines allow you to insert miniature graphs inside an individual cell to easily visualize data.

•Select range
•Insert ⇢ Sparkline
• Choose type
Geography / Maps:

Often, a geographical representation of your data can be quite useful.

Need to see where the majority of your customers live?

Interested in which states are driving the most revenue?

•Select your range of data
•Insert ⇢ Map

It's that easy.
Live stockmarket data:

Easily track 31 different metrics related to companies of your choice.

• Enter ticker symbols
• Select the "Data" tab
• Select "Stocks"
• Choose the metrics you'd like to track.
Conditional Formatting:

As you can tell, I'm a big fan of visualizing data.

Conditional formatting is one of the best (and easiest) ways to do this.

Let's face it, if your data looks good, you look good.

Spice it up by adding data bars, heat maps, or icon sets to show trends:
Drop Down lists:

If you've spent any time working in spreadsheets at all you know one thing:

They're only as good as the data entered.

My favorite way to ensure consistency & accuracy is Drop Down lists.

It's easy & guarantees the data will be entered correctly––every time.
Background Images:

OK, I'll be honest.

I'm not sure how "powerful" this is, but man, it looks cool.

Did you know you can add your own custom background images to your spreadsheets?

You didn't? Me either.

Check it out:
Thanks for reading!

If you learned something new today:

Follow me @blakeaburge for weekly threads on business, productivity, & building a better you.

Check out my newsletter:

"While You Were Away"

•The best of Twitter
•In your inbox
•Every Sunday
https://t.co/KPDWcYfMx3
For those asking, here's another on based on Google Sheets I did a while back.
https://t.co/Mmvfz7aPpD

More from Blake Burge 💡

Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
Don't lose today planning for tomorrow.

Don't join the pack –– Lead it.

10 Stoic principles that will immediately change your life: 🧵

On Wealth:

We all want more.

More things, more money, more prestige...

Whatever 'it' is, we never seem to have enough.

But what if we measured wealth differently?

Not by what we don't have, but by what we don't need?

True wealth is found in wanting less, not having more.


On Truth:

Too often we become set in our ways.

We believe our opinion is right, and are unwilling to consider alternate perspectives.

Have an open mind.

Be willing to change.

He who thinks he knows everything knows nothing.


On Control:

Some things we can change, some we cannot.

The secret to happiness lies in the ability to differentiate between the two.

Ask yourself:

Do I have the power to change this?

If so, get to it.

If not, move on.


On Looking Back:

Quit living in the past.

I've been guilty of this, as I'm sure you have as well.

Stop worrying about what could have been or what you should have done.

Start new. Start fresh. Start today.

What's done is done, but the future has yet to be written.
ALL , PRINCIPLES
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
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.
ALL
Advertisement
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
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!
ALL
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
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:
ALL
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
Google Sheets isn't Excel...

But it's more powerful than you think.

8 things Google Sheets can do, you'll wish you knew yesterday. 📊

Translate Text:

Need to convert data from one language to another?

Enter:
=GOOGLETRANSLATE("A2","en","es")

This will translate the words in cell "A2" from English to Spanish.

Replace "en" with "auto" and Sheets will identify the source language automatically.


Timesavers:

Assuming you're signed in to your Google account, head on up to your browser's address bar:

From there type: "https://t.co/BeKgYV7g31"

Boom! A new Google sheet is created for you on the fly from anywhere on the web.

(Works for docs too)

Pretty cool!


Sparklines:

Easily visualize data trends by adding sparklines to your sheet.

To add a basic "mini-graph" inside a cell, it's as simple as inputting:

=SPARKLINE (A1:F1) – (Where A1:F1 represents your range of data.)

For more detailed options, check this out:👇🏻


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" – Complex charts, analytics, & detailed info. generated automatically.
HOW TO USE GOOGLE SHEET

More from Reading

Joe Koster
Joe Koster
@jtkoster
I’m often asked by college students for reading recommendations to help them learn more about investing. I feel like I change my answers, at least a bit, all the time depending on what I’m reading and what’s on my mind at any given time, but here’s my current list….

1. Warren Buffett’s Letters to Shareholders

2. “Poor Charlie’s Almanack”

3. Howard Marks’ “The Most Important Thing”

4. Nassim Taleb’s books, in this order…. “Fooled by Randomness” (twice, back-to-back), “The Black Swan” (once), “Antifragile” (twice, back-to-back), and then “Skin in the Game” (once).

I think after reading Buffett and Munger, things sometimes seem too easy. Taleb’s books helped me think about risk and randomness in a way other books haven’t. Howard Marks’ book (or letters) help a lot too, but Taleb’s books pound those lessons in.

5. Peter Kaufman’s essay on “Culture”

6. William Green’s “Richer, Wiser, Happier.” And you don’t just learn from the investors profiled in the book (about investing and life), you also learn so much from @williamgreen72 as he synthesizes and simplifies the important things.
READING
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
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())
READING
Advertisement
Alex and Books \U0001f4da
Alex and Books 📚...
@AlexAndBooks_
36 Amazing short books (less than 200 pages):


1) Meditations
2) On The Shortness of Life
3) The Art of Living
4) Steal Like An Artist
5) The Last Lecture
6) The Miracle Morning
7) The Monk Who Sold His Ferrari
8) Tribe
9) The Greatest Salesman In The World
10) Lying
11) Make Your Bed
12) Finite & Infinite Games

13) The Compound Effect
14) The Dip
15) Poke The Box
16) Tribes
17) Anything You Want
18) The Go-Giver
19) Ignore Everybody
20) The Four Agreements
21) The Strangest Secret
22) Man's Search For Meaning
23) Nobody Wants To Read Your Sh*t
24) The War of Art

25) Gifts of Imperfection
26) Tao Te Ching
27) Ikigai
28) How To Fight A Hydra
29) Checklist Manifesto
30) Eat The Frog
31) Poor Richard's Almanack
32) Effective Executive
33) Who Moved My Cheese
34) 7 Brief Lessons on Physics
35) Lessons of History
36) The Boy, Fox, Mole & Horse

If you enjoyed this thread and want more book recs:

1) Follow @AlexAndBooks_ 👈
2) Sign up for my free weekly book newsletter (7,100+
READING
Library Mindset
Library Mindset
@librarymindset
100 Books To Read In 2022


1)Atomic Habits
2)Deep Work
3)The Almanack of @naval Ravikant
4)Sapiens
5)Can't Hurt Me
6)The Psychology of Money
7)Think Like A Monk
8)Steve Jobs
9)A Calendar of Wisdom
10)On the shortness of Life
11)Do Epic Shit
12)12 Rules For Life


13)Man's Search For Meaning
14)A Short History of Nearly Everything
15)The Four Agreements
16)The Power of Habit
17)21 Lessons for 21st Century
18)Homo Deus
19)Alchemist
20)War and Peace
21)Factfulness
22)The Lessons of History
23)The Power of Now
24)I Will Teach you to be rich


25)Einstein
26)Autobiography of Yogi
27)Leonardo da Vinci
28)Benjamin Franklin
29)Why We Sleep
30)5 am club
31)Built to Serve
32)The Go Giver
33)Meditations
34)Ego is the enemy
35)Stillness is the key
36)Lives of the stoics


37)Grit
38)The Everything Store
39)Measure what Matters
40)Everything is f
41)Crime and Punishment
42)Talk Like Ted
43)Who Moved my Cheese?
44)Beyond Order
45)The Dip
46)Limitless
47)The Rational Optimist
48)48 Laws of Power
READING , ALL
Alex & Books \U0001f4da
Alex & Books 📚...
@AlexAndBooks_
I asked, "What's the best history book you've ever read?"

I received 300+ responses.

Here are 20 books that will help you understand the world and how we got here:

1/

Sapiens

by @harari_yuval

2/

The Lessons of History

by Ariel Durant & Will

3/

Guns, Germs, and Steel

by Jared

4/

A Brief History of Nearly Everything

by @billbrysonn
READING

You May Also Like

Anu Satheesh \U0001f1ee\U0001f1f3
Anu Satheesh 🇮🇳...
@AnuSatheesh5
Thuravoor Narasimha Swamy Temple
Alappuzha, Kerala
#KeralaTemples 🚩

Thuravoor Narasimha Swamy or Thuravoor Mahakshetram is situated in Alappuzha with Narasimha Swamy and Sudharshana Moorthy as main Prathishta.
Temple has separate Sannidhi for Vadakkanappan ( Narasimha) and 👇


Tekkanappan ( Sudarshana).

Sthala puranam says that Vigraham of Narasimha was brought from Varanasi. Swami Padmapadar, shishya of Adi Sankaracharya, had worshipped the same Vigraham at Kashi.
A Namboodiri, on his way to Kashi saw a powerful light which disappeared here 👇


Namboodiri dug the place and he found a beautiful beautiful Vigraham made of Anjanasila. It is said that the vigraham occupied a site, which was the place of Durga Devi
Sudarshana Moorthy is about 6 Ft, Chaturbahu. Deepavali is famous festival here.
Om Narasimha Swamine Namah
🕉
ALL
Rich Energy
Rich Energy
@rich_energy
Great seeing one of the fastest natural drivers of the last decade Robert Kubica today with @WilliamsRacing at @COTA #USGP #f1 #robertkubica #Poland #richenergy
ALL
Advertisement
Mike DiCenzo
Mike DiCenzo
@mikedicenzo
"How the Avengers would respond to the Capitol riot" (a thread)

CAPTAIN AMERICA - tells Falcon, "I fought Nazis once before. They're extremely dangerous." They then see the guy scaling the Capitol wall fall into the shrubs. Falcon: "You sure these are the same Nazis?"

IRON MAN - lands by the guy carrying the podium. Says, "Mind if I borrow this?" then tosses it to Hulk, who swings it like a bat at the mob. Guy: "Hey, that's MY podium!" Iron Man: "Actually it's the Speaker's. And technically, it's a lectern." Then punches him through a wall.

BLACK WIDOW - enters hotel room where Jack Dorsey is tied up. Rips duct tape off his mouth. Jack: "I'll do anything you want!" BW: "Disable POTUS's Twitter. NOW!" Jack fumbles with his phone. "Done. Anything else?" BW: "Yeah. Trim your beard for God's sake." *tosses him clippers*

HULK - grabs a selfie stick from one of the guys and beats him over the head with it. Deeming it too small, he grabs another guy's Confederate flag and takes out a whole swath of rioters. He then tosses the flag to Cap, who uses it as a javelin to impale a fleeing Ted Cruz.

HAWKEYE - hears Iron Man in his earpiece say, "Looks like Orange Julius is tweeting from another account." Hawkeye: "On it." He locks in on Trump through the White House window and fires an arrow, knocking the phone out of Trump's hands. Hawkeye: "Damn that felt good."
GOVERNMENT
WAKE UP AUSTRALIA WAKE UP
WAKE UP AUSTRALIA WAKE...
@WakeAustralia
Facebook originally a CIA program called "LifeLog".
LifeLog, via DARPA, terminated on Feb 4th, 2004.
Facebook was launched on Feb 4th, 2004.
Many of the LifeLog team became execs at FB.
Zuckerberg is a figurehead.
CIA allowed Cambridge to help Trump win

https://t.co/enzOXDCogV


Pentagon Kills LifeLog
BUSINESS
Murray \U0001f1fa\U0001f1f8
Murray 🇺🇸...
@Rothbard1776
NEW: @SidneyPowell1 radio interview w/ @toddeherman "The new report has a truckload of evidence of foreign interference in the election in it. That's what people seem to want to deny, even though the FBI & CISA ... issued an advisory and alert back on Oct. 30th & updated on

2/ Nov. 3rd, so for them to deny that now is absolutely absurd. Plus, we have an affidavit from an expert cyber-warfare [individual] who even shows the diagram of all the attacks coming in. We know that the VPN ... the Dominion people left those open and unencrypted on the night

3/ of the election, so that anybody could get in. We know that the packets of information went to Serbia [note: over 100 Dominion employees scrubbed there LinkedIn profiles of any affiliation with the company after the election, many of whom were in Serbia], Liechtenstein,

4/ Spain, Venezuela, Hunan, China & Hong Kong. There was traffic all over into our election system that is supposed to be self-contained, not accessible by the internet at all. We have witnesses who document that it was connected to the internet. We have a study out of

5/ [the Dominion voting system in Antrim] MI, they know that it was connected to the internet. They erased their audit files & their adjudication files, where they dumped over 68% of their ballots into a bin that they call "adjudication" [that would've been thousands + thousands
POLITICS , ELECTIONFRAUD