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 💡

Success isn't a mistake.

8 steps to build the life you want. 🧵

Clock In:

It's time to go to work.

There are no magic bullets & "get-rich-quick" doesn't exist in the real world.

Immerse yourself in learning, have a bias toward action, be willing to do what others won't.

Do this & you won't need to look for results, they'll find you.

Work from the top down:

The fastest way to get from where you are to where you want to be?

Find someone who's already there.

Learn from them, seek advice, & follow the path they've forged.

Reach out.

People are more willing to help than you think.


Persist:

The bigger your goals, the more likely it is they'll take longer to achieve.

Most people fail when they quit right before their plan is beginning to work.

By stopping, they never know how close they actually were.

Be consistent. Keep going.

h/t@visualizevalue


Build your personal brand:

We're all selling something, often it's ourselves.

Give before you get.

Provide value, be unique, be consistent.

Once people know what to expect from you, they'll come back for more.

The best advertisement in the world is repeatable results.

You May Also Like