Original thread by 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. ?
Need to convert data from one language to another?
This will translate the words in cell “A2” from English to Spanish.
Replace “en” with “auto” and Sheets will identify the source language automatically.
Assuming you’re signed in to your Google account, head on up to your browser’s address bar:
From there type: “http://sheet.new“
Boom! A new Google sheet is created for you on the fly from anywhere on the web.
(Works for docs too)
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:??
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.
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
•Click “Color Scale”
•Select colors to represent:
––Min, Mid, & Max
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!
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: