Google sheets tags | google sheets templates | google sheets tutorial | google sheets functions tutorial | spreadsheet functions | new features in google sheets | cool google sheets templates | google sheets shortcuts
We’re going to cover a range of tips that will help you save time and do some awesome things, all using the power of Google Sheets! Let’s get started!
And if you like, you can jump straight to a tip:
|
Send
emails when you comment
|
|
|
|
Add
heatmaps using conditional formatting
|
|
|
|
Apply
filters
|
|
|
|
Clean
up values with CLEAN and TRIM
|
|
|
|
Protect
data in cells
|
|
|
|
Validate
data in cells
|
|
|
|
Integrate
with Google Forms
|
|
|
|
Insert
a chart from Google Sheets into a Google Doc
|
|
|
|
Import
data from a website or RSS feed
|
|
|
|
Change
capitalization in cells
|
|
|
|
Translate
text
|
|
|
|
Split
names and other data
|
|
|
|
Check
for valid email address
|
|
|
|
Quickly
summarize data
|
|
|
|
Import
data from other sheets
|
|
|
|
Visualize
data with a sparkline
|
|
|
|
Create
QR codes
|
|
|
|
Quick
data visualization
|
|
|
|
Extend
Google Sheets with add-ons
|
|
|
|
Quickly
learn formulas
|
|
|
|
Keyboard
shortcuts
|
