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.
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?
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.
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!
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
•Format->Conditional Formatting
•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!
=GOOGLEFINANCE("NASDAQ:TSLA","price",TODAY()-60,TODAY())
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.
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!
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
I write 1-2 threads per week.
— Blake Burge \U0001f4a1 (@blakeaburge) September 29, 2021
Sharing stories about business, productivity, & building a better you.
My Goal: To help you learn while I do the same.
You can find all of my threads here.
Please read, enjoy, & share! \U0001f9f5
More from Blake Burge 💡
You May Also Like
Following @BAUDEGS I have experienced hateful and propagandist tweets time after time. I have been shocked that an academic community would be so reckless with their publications. So I did some research.
The question is:
Is this an official account for Bahcesehir Uni (Bau)?
Bahcesehir Uni, BAU has an official website https://t.co/ztzX6uj34V which links to their social media, leading to their Twitter account @Bahcesehir
BAU’s official Twitter account
BAU has many departments, which all have separate accounts. Nowhere among them did I find @BAUDEGS
@BAUOrganization @ApplyBAU @adayBAU @BAUAlumniCenter @bahcesehirfbe @baufens @CyprusBau @bauiisbf @bauglobal @bahcesehirebe @BAUintBatumi @BAUiletisim @BAUSaglik @bauebf @TIPBAU
Nowhere among them was @BAUDEGS to find
The question is:
Is this an official account for Bahcesehir Uni (Bau)?
Bahcesehir Uni, BAU has an official website https://t.co/ztzX6uj34V which links to their social media, leading to their Twitter account @Bahcesehir
BAU’s official Twitter account
BAU has many departments, which all have separate accounts. Nowhere among them did I find @BAUDEGS
@BAUOrganization @ApplyBAU @adayBAU @BAUAlumniCenter @bahcesehirfbe @baufens @CyprusBau @bauiisbf @bauglobal @bahcesehirebe @BAUintBatumi @BAUiletisim @BAUSaglik @bauebf @TIPBAU
Nowhere among them was @BAUDEGS to find
Krugman is, of course, right about this. BUT, note that universities can do a lot to revitalize declining and rural regions.
See this thing that @lymanstoneky wrote:
And see this thing that I wrote:
And see this book that @JamesFallows wrote:
And see this other thing that I wrote:
One thing I've been noticing about responses to today's column is that many people still don't get how strong the forces behind regional divergence are, and how hard to reverse 1/ https://t.co/Ft2aH1NcQt
— Paul Krugman (@paulkrugman) November 20, 2018
See this thing that @lymanstoneky wrote:
And see this thing that I wrote:
And see this book that @JamesFallows wrote:
And see this other thing that I wrote:
1/ Some initial thoughts on personal moats:
Like company moats, your personal moat should be a competitive advantage that is not only durable—it should also compound over time.
Characteristics of a personal moat below:
2/ Like a company moat, you want to build career capital while you sleep.
As Andrew Chen noted:
3/ You don’t want to build a competitive advantage that is fleeting or that will get commoditized
Things that might get commoditized over time (some longer than
4/ Before the arrival of recorded music, what used to be scarce was the actual music itself — required an in-person artist.
After recorded music, the music itself became abundant and what became scarce was curation, distribution, and self space.
5/ Similarly, in careers, what used to be (more) scarce were things like ideas, money, and exclusive relationships.
In the internet economy, what has become scarce are things like specific knowledge, rare & valuable skills, and great reputations.
Like company moats, your personal moat should be a competitive advantage that is not only durable—it should also compound over time.
Characteristics of a personal moat below:
I'm increasingly interested in the idea of "personal moats" in the context of careers.
— Erik Torenberg (@eriktorenberg) November 22, 2018
Moats should be:
- Hard to learn and hard to do (but perhaps easier for you)
- Skills that are rare and valuable
- Legible
- Compounding over time
- Unique to your own talents & interests https://t.co/bB3k1YcH5b
2/ Like a company moat, you want to build career capital while you sleep.
As Andrew Chen noted:
People talk about \u201cpassive income\u201d a lot but not about \u201cpassive social capital\u201d or \u201cpassive networking\u201d or \u201cpassive knowledge gaining\u201d but that\u2019s what you can architect if you have a thing and it grows over time without intensive constant effort to sustain it
— Andrew Chen (@andrewchen) November 22, 2018
3/ You don’t want to build a competitive advantage that is fleeting or that will get commoditized
Things that might get commoditized over time (some longer than
Things that look like moats but likely aren\u2019t or may fade:
— Erik Torenberg (@eriktorenberg) November 22, 2018
- Proprietary networks
- Being something other than one of the best at any tournament style-game
- Many "awards"
- Twitter followers or general reach without "respect"
- Anything that depends on information asymmetry https://t.co/abjxesVIh9
4/ Before the arrival of recorded music, what used to be scarce was the actual music itself — required an in-person artist.
After recorded music, the music itself became abundant and what became scarce was curation, distribution, and self space.
5/ Similarly, in careers, what used to be (more) scarce were things like ideas, money, and exclusive relationships.
In the internet economy, what has become scarce are things like specific knowledge, rare & valuable skills, and great reputations.
