Google Workspace – Quick tips and tricks
Below are some short videos showing you some quick tips and tricks, helping you to use Google Workspace better.
Check out my YouTube channel here – Videos on how to use Google Workspace and Apps Script (I’m building a library of videos on there).
Google Sheets
Improve your Google Sheets skills with these short tips and tricks videos.
How to quickly sum numbers
How to use drop down menus
How to make a timeline
.new trick to create new docs
Use paint roller to quickly format Sheets
How to use Filter Views to quickly filter data
How to add alternating colours to rows
How to use Cell History
How to add new lines within cells
Why XLOOKUP is better than VLOOKUP – Look up to the left
Why XLOOKUP is better than VLOOKUP – Useful error messages
Why XLOOKUP is better than VLOOKUP – Multiple results
How to add a calendar in a Sheets cell
How to remove duplicates
How to filter duplicate rows
How to merge and split cells
How to sort data
More coming soon!
More tutorials on Google Sheets here.
Gmail
Go beyond the basics of Gmail with these tips and tricks.
How to send personalised emails to multiple people using Gmail’s mail merge
Arrange a meeting directly from Gmail
Google Slides
Google Slides tips.
How to annotate slides while presenting
How to create shareable video presentations
Google Tasks
Learn all about Google Tasks.
How to use Google Tasks
Google Drive
Dive into Google Drive.
How to use scan using Drive app on your phone
How to move a folder to a Shared Drive
Want to learn more about Google Workspace and Apps Script? The books below are available on Amazon. Just click on a book! (Affiliate links).
a
