BC HOW TO USE GOOGLE SHEET
Saved by @shanki03

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.
Heat Maps:

With conditional formatting, you can turn your data into a heat map to easily identify trends & patterns.

•Select the data range in the Google Sheet
•Format->Conditional Formatting
•Click "Color Scale"
•Select colors to represent:
––Min, Mid, & Max
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())
Auto-email when commenting:

One of my favorite things about Google Sheets is the ease of collaboration within docs.

Need to assign a task to a co-worker?

Want to make sure they actually see it?

Automatically send an email to coworkers using comments within cells.
Make your charts stand out:

First, let's make a chart...

Highlit cells then click:

"Insert -> Chart -> Chart Type -> Pie"

Now, double-click one section of the chart and select the "distance from center" option.

Increase the % to make that section stand out from the rest!
Thanks for reading!

If you're a bit of a nerd & love spreadsheets like me, why not share?

•Retweet the first tweet and help others find this thread!

•Join 56,000 of my friends & follow me: @blakeaburge

•You can find my previous work here:
https://t.co/YokOrX2SzE

More from Blake Burge 💡

Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
How to get rich, learn anything, and get more done.

11 Tweets to change your life. 🧵

1/ Learn Anything:

A masterclass from my friend @SahilBloom

The 6-step framework he uses to learn anything.

(1) Identify & Establish
(2) Research
(3) Skin in the Game
(4) Engage Community
(5) Teach
(6) Reflect &


2/ A cheat sheet for building your career:

20 things you'll wish you knew sooner.

An amazing piece by @RomeenSheth on career


3/ The 5 Traits of Elite Individuals:

I'm not sure what rock I've been living under...

I've somehow just now stumbled across @NdamukongSuh's Twitter content.

It's a goldmine.

Case in point


4/ Where you are -> Where you're going:

•Be consistent
•Set higher standards
•Learn to say "no" more
ALL
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
25 years ago my father made me a deal...

I only had to do one thing.

I failed.

THREAD: A story about a father, a son, and life meeting you halfway.

It was the summer of 1996, I had just turned 15 & like any 15-year-old boy, I only had one thing on my mind.

OK, maybe two.

Other than girls, the main thing I wanted, all I could talk about, was a car.

Or in my case a truck.

The deal was simple.

Over the next year, I'd be given chores to complete around our home.

With an agreed-upon hourly rate, I was free to work as much, or as little, as I choose.

At the end of the year, whatever I earned, my father would match.

Up to $2500.

Best case scenario?

I earn $2,500, my dad matches $2,500.

I've got $5K to spend!

Look out world, I'm gonna be rich!

There was only one catch, I had to do the work.

Not only did I have to do the work, I had to ask what work needed to be done.

I came out of the gate fast.

Asking my father for anything and everything I could do to earn a buck, and he obliged.

Each time I asked, he had a new project ready and waiting.

The opportunity was there, and I was seizing it!
SAHASRA
Advertisement
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
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
ALL
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
What do the world's greatest leaders know about the power of persuasion that you don't?

THREAD: How you can unlock the ability to change anyone's mind.

Let's get smarter... 👇🏻


1/ As far back as the mid 300's BC, humans were fascinated by the power of persuasion.

In light of this, Aristotle developed what is known as the "Rhetorical Triangle."

A framework for persuading any audience using 3 simple appeals:

•Ethos
•Pathos
•Logos

Let's dig in...


2/ Ethos (Ethics / Character)

The first of the 3 appeals, Ethos speaks to the perceived character of the speaker.

In order to persuade anyone to do anything, they must first believe you are a credible and trustworthy source.

How do you accomplish this?

3/ Establishing Ethos: (1)

•Language: Choose verbiage that is fitting to the subject matter and audience you are trying to persuade.

•Pedigree: Do you have specific credentials or education relating to the topic being covered? If so, make it known.

👇🏻

4/ Establishing Ethos: (2)

•Rapport: Your audience must feel as though you are "in sync."

You understand and can relate to their feelings or ideas.

TL;DR

•Choose the right language
•Communicate pedigree
•Build Rapport

Trust becomes a byproduct.

Let's see an example 👇🏻
ALL
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
10 websites you didn't know you were missing (until now) :

https://t.co/vC0nCFDmk0

People are visual learners.

Easily turn your data into stunning charts, maps, and interactive stories.

Upload a spreadsheet, and return with:

• Animated bar charts
• Survey data
• Scatter plots
• Story maps & more


https://t.co/g9YBl2ELwq

Looking for a way to make your presentations more engaging?

Build interactive polls, quizzes, and more allowing your audience to engage in real-time.

Using their smartphone, attendees can answer questions and the results are visualized as they happen.


https://t.co/wsUNfyHzFb

An online collaborative whiteboard ideal for remote meetings, brainstorming, and ideation across teams.

• Make flowcharts
• Build product roadmaps
• Engage in a quick retrospective

The best part?

It's free.


https://t.co/RxDEsvPB2w

My friend @thejustinwelsh brought this site to my attention recently.

If you're in the solopreneur game and need to spin up a quick landing page or website for just about anything, Carrd is tough to beat.

Simple, free, mobile responsive.

Check 'em out.
WEBSITE , ALL

You May Also Like

Reagan Gomez
Reagan Gomez
@ReaganGomez
Black movie goers know which movies are for us and which films aren’t. We really don’t like our stories being made into films that center (and humanize) people that hate us. The filmmakers/studio know that by naming the film “The Green Book”, black movie goers...

...are going to be expecting a story about black people trying to safely navigate the country (real history) and instead will get a white savior film. Like folks went to see Detroit thinking it was about the riots...

Anywhoo, I know Mahershela is fantastic in it. He was the best thing about the trailer. As rich as the history behind the creation of ‘The Green Book’ is/was, as amazing as Dr. Don Shirley’s story is, WHY is this film about a random, racist driver and his family?

This feeds into the ignorant anti-Black American stereotype of “Black Americans don’t have any culture/history/mythology” or whatever. That our stories are still both being used while simultaneously erased in 2018 is wild to me. It’s gonna clean up come award season. 🤦🏾‍♀️

And now, if black filmmakers WANTED to make a film about The Greenbook, guess what it can’t be called🙃. Just like if someone wanted to make a film about the actual Detroit riots, guess what it can’t be called? Then those filmmakers would run into...
CULTURE
James Felton
James Felton
@JimMFelton
Butt plugs were originally sold as a miracle cure for headaches, acne, and insanity

Thread, article here and h/t: @qikipedia :
https://t.co/Ts84xnmWKJ


For a long time, medicine was pre-occupied with the question "can this be solved by putting something in the butt?"

Take, for example, tobacco smoke enemas, in which 18th Century physicians saw drowning victims and attempted to de-deadify them by blowing tobacco smoke up their rectums with a pipe.


Despite having no medical benefit whatsoever, the practice was popular, and enema kits lined the Thames like lifebelts, ready to be used as one final humiliation for somebody who was crap at swimming.

This practice ended sometime after 1800 when it became apparent that it didn't really work, given how the anus famously isn't really connected to the lungs, but doctors weren't quite finished with having a poke around in the old anus to see what happens just yet.
TECH
Advertisement
\u0936\u094d\u0930\u0940\u092e\u093e\u0932\u0940 \u0939\u093f\u0924\u0947\u0936 \u0905\u0935\u0938\u094d\u0925\u0940
श्रीमाली हितेश अवस्थी...
@HiteshAwasthi89
Sri Devi Karumariamman mandir, Chennai, Tamilnadu

Sri Devi Karumariamman mandir is in Thiruverkadu, a suburb of Chennai. It is said that God Muruga came here and obtained the 'Vel' (spear) from His mother, Goddess Karumari (an avatar of Parvathi) 1/n


to fight the demon Suran and hence this place was called as 'Vel kadu' and became as Verkadu. As per legend Devi Karumariamman once disguised as a soothsayer visited Bhagwan Surya, the Sun God, to predict His future. 2/n


Not realising that the soothsayer is none other than Sakthi Matha, Surya ignored Her. Angered by his indifference, Devi Karumariamman immediately retreated. Bhagwan Surya lost His glory and the earth plunged into darkness. 3/n


Bhagwan Surya then realised His folly and pleaded forgiveness from Devi Karumariamman. In order to pacify mother Karumariamman, Suryadev said that His rays would fall on Her directly twice in a year and touch her feet. (in the month of Panguni (March- April) & during (Sep - Oct)


Mother Karumari Amman is worshipped here in two forms.A swayambu (self manifested) with only head visible above the ground and another one in a graceful sitting posture with all Parasakthi features,with four arms holding skull, sword, trishul, udukkai (damru). 5/n
ALL
Conviction | Patience
Conviction | Patience
@unseenvalue
H was always unseen in S2NL :)

Those who exited at 1500 needed money. They can always come back near 969. Those who exited at 230 also needed money. They can come back near 95.

Those who sold L @ 660 can always come back at 360. Those who sold S last week can be back @ 301
UVLEARNINGS
katya adler
katya adler
@BBCkatyaadler
Again, at such a key moment in UK and at such high political levels, evidence of deep misunderstanding of EU: The PM is under pressure in some quarters to delay #Brexit vote to allow her first to “improve” deal in Brussels BUT EU is determined not to budge at this stage

2) All EU leaders watching tomorrow’s vote. Of course they want to avoid a no deal #Brexit BUT they feel the deal - so painfully negotiated between EU and UK - is too fresh to re-open. Clarifications, yes but fundamental renegotiations, no.

3) The EU’s international reputation as a tough deal-maker is at stake here too. If Brussels now suddenly “gives in” to U.K. on EU red lines (eg backstop) then that would weaken the EU’s reputation in future trade negotiations with other non EU countries

4) Also on backstop the EU is unlikely to cave in to favour a relationship with a leaving member state (UK) against the explicit wishes and ignoring the deep concerns of a continuing member: Ireland.

5) Both the EU and the PM signed up to a guarantee to protect the border between Northern Ireland and the Republic of Ireland. If either the U.K. or EU can leave the backstop unilaterally then this clearly is no longer a guarantee.
POLITICS