Google Docs, Sheets, Slides

Information on the GSuite productivity apps

How to Share Something on Google Docs for a Limited Time (Expiration Dates)
We often need to share documents, folders, and files on Google Drive with collaborators, both inside and outside the organization. But what about the scenar...
Mon, Apr 4, 2016 at 1:52 PM
Using Google Docs/Sheets/Slides When You're Offline
A common criticism of the G Suite of applications is that they're accessed through a web browser. This means that you can't use Google Docs, She...
Mon, Feb 12, 2018 at 10:52 AM
How to Create Mailing Labels in Google Docs
The free Avery Label Merge add-on for Google Docs will allow you to create custom mailing labels and nametags based on data that you have in a Google She...
Mon, Oct 31, 2016 at 2:46 PM
Converting Google Docs to PDFS
Google Docs has a built-in PDF converter that you probably already know about. You go to the file menu, select "Download as", then "...
Tue, Jan 10, 2017 at 9:07 AM
Use VLOOKUP to Let Google Sheets Do Your Searching For You
When you're faced with doing a repetitive task in a spreadsheet, there's a key question you should always ask yourself:  "Could I ...
Fri, Nov 11, 2016 at 11:35 AM
Two Ways to Separate First and Last Names in Google Sheets
Ima guess this has probably happened to you: you've got a giant list of full names in a spreadsheet, names like "Tina Popintosh". Unfortuna...
Fri, Nov 11, 2016 at 1:03 PM
Relative and Absolute References in Google Sheets and Excel
Both Google Sheets and Microsoft Excel refer to cells by their addresses using a system called 'A1 notation'. Most folks who use spreadsheets are ...
Wed, Jun 21, 2017 at 4:26 PM
Type Styles in Google Docs (or "How Do I Change My Default Font?")
Google Docs, like most word processing programs, uses Type Styles to manage your typefaces. Your type styles determine what font you see when you start ty...
Mon, Dec 12, 2016 at 10:04 AM
Using Google Docs Version History for Good (and Evil)
Google Docs, Sheets, Drawings, and Slides documents record every change and/or edit that's ever made. This catalog of document changes is called the Ve...
Tue, Apr 3, 2018 at 10:05 AM
How to Use the AutoCrat Extension to Perform Mail Merges with Google Sheets
Unlike Microsoft Office, Google Docs and Sheets don't have the ability to perform mail merge operations. If you're not familiar with mail merges o...
Sun, Nov 26, 2017 at 10:04 AM