Simpliguides

Simpliguides › Productivity

Productivity

Guides for Google Calendar, Google Docs, Google Photos, and the everyday tools most people use but never fully figure out.

Google Calendar

Set a reminder that actually works

The difference between reminders and events — and which one to use.

Share a calendar with someone

Give a colleague or family member visibility of your schedule.

Stop spam invitations landing on your calendar

One setting keeps invitations from strangers in your inbox until you accept them.

Let people book time with you using a Google Calendar appointment schedule

Set up a Google Calendar appointment schedule so people pick a slot from a booking page instead of emailing back and forth.

Set working hours in Google Calendar so people can't book you outside them

Set your working hours in Google Calendar, then turn on automatic declining so invitations outside those hours are refused for you.

Set up a recurring task in Google Tasks

Make a task in Google Tasks repeat daily, weekly, monthly or yearly, choose when the repeats stop, and find out where finished occurrences go.

Turn on Suggesting mode in Google Docs

Switch Google Docs to Suggesting mode so your edits show as proposals the owner can accept or reject, like Track Changes in Word.

Protect a range in a Google Sheet so others can't edit key cells

Lock specific cells in a Google Sheet so the people you share it with can't change them by accident, choose who can still edit, or switch to a warning instead of a block.

Merge duplicate Google Contacts (and stop them coming back)

Combine duplicate entries for the same person using the built-in duplicates tool in Google Contacts, merge stubborn pairs by hand, undo a merge that went wrong, and find out why duplicates keep reappearing.

Share a Google Tasks list with someone else

Google Tasks has no share button, so this guide uses the method that works: a Google Chat space with a Tasks tab everyone can see, where assigned tasks land in each person's own Google Tasks.

Create a self-marking quiz in Google Forms

Turn a Google Form into a quiz that marks itself: switch on quiz mode, set the answer key and points for each question, choose when people see their score, and fix the three settings that stop scores appearing.

Edit a password-protected Word, Excel or PowerPoint file in Google Drive

Open a password-protected Word, Excel or PowerPoint file in Google Drive and edit it in Docs, Sheets or Slides without downloading it first.

Google Docs

Google Photos

Need a calculator rather than a guide? Try Simplicalcs →