Google at U-M Learning Resources

Resources: 105
G Suite Quick Start Guide

Sign in, send email, schedule events, store and share files, collaborate, hold video meetings, and power up your G Suite services.

Google Team Drives Overview

Team Drives are a new feature in Google's G Suite. It offers shared space in Google Drive where teams can create, store, search, collaborate on, and have access to all their team-owned files. The difference between a Team Drive and My Drive is that all data (files, folders, spreadsheets, forms, and presentations) are owned by the team and not an individual.

CTools Project Site Migration (43:33) | Jun 22, 2017 

What to expect and how to select alternative tools. Learn how Shared Accounts, Team Drive, U-M Discussion Groups and MCommunity Groups can enhance collaboration and communication. John demos migrating from a CTools site. Also see CTools Project Sites Transition Website.

Sensitive Data Guide

Shows which services can be used for which data types, search or browse by data types and IT tools & services, or see data sensitivity information by role.

Shared Accounts in U-M Box and U-M Google

How to request and manage a shared account in U-M Google and U-M Box.  (Shared accounts allow a group to have a U-M Google or U-M Box account that is owned by that group rather than by an individual)

Top 10 ways to use G Suite in Human Resources (HR)

Review the best ways to utilize G Suite's features to help in Human Resources (HR).

Top 10 ways to use G Suite in project management

Review the best ways to utilize G Suite's features to help with project management.

Top 20 ways to use G Suite for administrative assistants

Review the best ways for administrative assistants to utilize G Suite's features.

Google Accounts for People Who Leave U-M

Roll-off procedures, what happens with a U-M Google account when someone retires/graduates/leaves, and dealing with cooperative and uncooperative departures.

Managing MCommunity Groups & UMICH Passwords for Shared Accounts

How to manage the MCommunity Directory group profile associated with a shared account and how to change the UMICH password used for that account.

MCommunity Group Synchronization to U-M Google and Box

MCommunity Directory groups are synchronized to U-M Google and U-M Box so a user can use them when sending email, sharing resources, and collaborating. This document lists what parts of MCommunity groups are sent to U-M Google and U-M Box.

Working with MCommunity Groups in Google

MCommunity groups can collaborate in U-M Google. Access to items is managed in MCommunity instead of U-M Google. For privacy, the "members list is viewable to" setting in MCommunity is synced to U-M Google. When using sensitive data, ensure that all group members are in compliance.

Get started with Classic Google Hangouts

Start chats or video calls, join a video call, and share your screen and add more people.

Get Started with Gmail

Learn how to create and send email, organize your inbox, find email, create signatures, and access your calendar, notes, and tasks.

Get Started with Google Calendar

Schedule events, add reminders, share and view, create a team calendar, and customize the layout.

Get started with Google Docs

Create or import, edit and format, share and collaborate, and print and download.

Get Started with Google Drive

Upload and store, sync and access, view and update, organize and search, share and collaborate.

Get Started with Google Forms

Create your form, choose settings and preview, send your form, analyze responses, and print a form.

Get started with Google Sheets

Create or import, add content, share and collaborate, and print and download.

Get started with Google Sites

Create your site, update and personalize your site, share and collaborate, and preview and publish your site.

Get Started with Google Slides

Create or import, add content, share and collaborate, and present, print, and download.

Getting Started with Google Team Drives

Set up a team drive, add files and folders, organize files, share and collaborate.

Gmail Tips & Tricks

Get more out of using Gmail with these ideas for how to use it - descriptions and instructions included.

Google Calendar Tips & Tricks

Get more out of using Google Calendar with these ideas for how to use it with descriptions and instructions.

Google Docs Tips & Tricks

Get more out of using Google Docs with ideas for how to use it, with descriptions and instructions.

Google Drive Tips & Tricks

Get more out of using Google Drive with ideas for how to use it with descriptions and instructions.

Google Forms Tips & Tricks

Get more out of using Google Forms with ideas for how to use them with descriptions and instructions.

Google Hangouts Tips & Tricks

Get more out of using Google Hangouts with ideas for how to use it with descriptions and instructions.

Google Mobile Tips and Tricks

Get more out of using Google with mobile devices with ideas for how to use it with descriptions and instructions.

Google Sheets Tips & Tricks

Get more out of using Google Sheets with ideas for how to use them with descriptions and instructions.

Google Sites Tips & Tricks

Ideas for how to use Google Sites with descriptions and instructions.

Google Slides Tips & Tricks

Get more out of using Google Slides with ideas for how to use it with descriptions and instructions.

Google Spreadsheets Function List

These functions can be used to create formulas that manipulate data and calculate strings and numbers within Google Sheets.

Google Team Drive IT4U (42:30) | Sept 14, 2017

Jen Mruk and Brian Cors (ITS) demonstrate the new Google Team Drives for team-based ownership of files. Learn how Team Drives can solve sharing and collaboration issues and how to get started using them in your unit. 9/14/17. Resource links provided during the webinar.

Google Team Drives and My Drive Differences

Google Team Drives is a new feature in Google's G Suite. Unlike files in My Drive, files in Team Drive are owned by the Team rather than an individual. The table in this document outlines the major differences between Team Drives and My Drive.

Google Team Drives Best Practices

Google Team Drives is a new feature in Google’s G Suite offering shared space in Google Drive where teams can create, store, search, collaborate on and have access to all their team-owned files. This document contains a list of best practices for using your Team Drives here at the University of Michigan.

Google Team Drives comparison with Shared Accounts in Google My Drive and Box

U-M Google Team Drives, My Drive, and U-M Box are great for maintaining a shared document repository. However, there are important differences in how they work. Tables in this document outline how the three compare.

Google Team Drives Data Migration

The items that can and cannot be migrated, how this will affect other collaborators, and how to move a file into Team Drives (includes demos without audio).

Gmail Cheat Sheet

Create a new email message, read a message in your inbox and send a reply, and organize your inbox. (Can download as a PDF)

Google Calendar Cheat Sheet

Schedule a new event and enter event details, click any event on your calendar to join a video call or edit events and invites, add more people or propose a new time, add and customize calendars. (Can download as a PDF)

Google Classic Hangouts Cheat Sheet

Start a chat or video call in Gmail, join a call from Gmail, Calendar, or your browser, and work with video calls. (Can download as a PDF)

Google Docs Cheat Sheet

Edit and add styles to your text, work with different versions and copies of your document, enhance your document by adding features, share your document and choose what collaborators can do, and collaborate with your team in real time. (Can download as a PDF)

Google Drive Cheat Sheet

Upload any files (such as PDFs, videos, and pictures) and folders from your computer, create new documents right in your browser, work with files you’ve stored in Drive, share your files and folders and choose what collaborators can do, add shared files to My Drive, and access your files from any device. (Can download as a PDF)

Google Forms Cheat Sheet

Diagrams on how-to create your form, choose settings and preview your form, send your form, and analyze responses. (Can be downloaded as a PDF)

Google Sheets Cheat Sheet

Customize your spreadsheet and data, work with rows, columns, and cells, share your spreadsheet and then choose what collaborators can do, collaborate with your team in real time, create different versions and copies of your spreadsheet, and work with functions. (Can download as a PDF)

Google Sites Cheat Sheet

Diagrams and quick how-to's regarding creating a new Site, customizing your Site and homepage, adding new pages and navigation, adding content to pages, and sharing, previewing, or publishing your Site. (This can be downloaded as a PDF)

Google Slides Cheat Sheet

Add and edit content in your slides, add and organize slides, work with different copies and versions of your presentation, share your presentation and choose what collaborators can do, and collaborate with your team in real time. (Can download as a PDF)

Working with Gmail

Information and instructions for best working with Gmail. Includes mail labels and filters, managing large volumes of email, working with attached files, and best practices for Gmail.

A tour of Google Forms (3:30)
Backup & sync files with Google Drive

You can back up and sync your files with your Mac or Windows computer. Note: If you use a Google Account through work or school, you may need to use Drive File Stream instead of Backup and Sync. Learn how to install and use Drive File Stream.

Collaborate with Box & Google Shared Accounts (40:41) | Dec 1, 2016

Walkthroughs and comparisons of how U-M Box and U-M Google operate using shared accounts.

Create dynamic project plans with Google Sheets

Set up your project plan, collaborate with your team, and do more with G Suite. Includes diagrams

Create, edit, and format Google Docs

Create a document, change how paragraphs and fonts look, add a bulleted or numbered list, copy and paste text and images, edit and view text from right to left, add a title, heading, or table of contents in a document, delete a document, spreadsheet, or presentation, suggest edits in Google Docs, edit and use a document outline, and add or delete columns in a document.

Create, edit, and format Google Forms

How to use Google Forms, create and grade quizzes, edit your form, choose a question for your form, change the theme or font of your form, show questions based on answers, and share your form with collaborators.

Edit Your New Google Site

Add text, images, and other content. Choose the style of your site. Edit and format text and photos.

Gmail Help Center

Explore popular articles with topics like manage your Gmail account, read and organize emails, settings, send emails, the Gmail App, and fix a problem.

Google Discussion Groups

Warning: You must contact the ITS Service Center to request a Discussion Group in the UMich domain. The Create Group button creates a Google Group outside of the UMich domain that is not protected by our contract with Google. Discussion Groups are not MCommunity groups and there is no relationship between them.

Google Docs Editing Tools

Use add-ons & Apps Script, see what’s changed in a file, search and use find and replace, use spell-check and autocorrect, count the words in a document, translate documents or write in a different language, use equations in a document, see and use suggested content in a document, keyboard shortcuts for Google Docs, type with your voice, and use Google Keep in a document or presentation.

Google Forms advanced tools and troubleshooting

Set rules for your form, use add-ons and Apps Script, keyboard shortcuts for Google Forms, and can't open a form.

Google Forms from Start to Finish (13:09)

How to use Google Forms.

Google Sheets Functions and Formulas

Add formulas and functions to a spreadsheet, see the sum and average in a spreadsheet, reference data from other sheets, and visit the Google spreadsheets function list.

Google Sheets Help Center

How to use Google Sheets; create, edit, and format; work with sheets, rows, and columns; publish and embed your spreadsheet; functions and formulas; create and edit charts; tools; spreadsheet settings, views, and printing; work with data.

Google Slides Help

Get started with Google Slides; create, edit, and customize slides; insert shapes, images, and other objects; tools and animations; present or print slides; publish and embed your presentation; and issues editing Slides.

How to use Google Sites

Create a new site, add content to your site, publish and share your site, differences between old and new Google Sites.

Insert items into Google Docs

Add, edit, or remove a link, bookmark, or page break, insert or delete images or videos, add headers, footers & page numbers, insert special characters, and link a chart, table, or slides to Google Docs or Slides.

New Google Sites - Deeper Dive (5:58)

Walkthrough of creating and editing a New Google Sites webpage.

New Google Sites Overview (5:45)

A quick overview of the New Google Sites.

New vs. Old Google Sites

Convert your site to New Sites, compare Classic Sites & New Sites, and what to expect when you convert a site.

Organize your files in Google Drive

If you don’t want to back up your files from your computer, you can stop syncing. Create a folder, move a file or folder, make a copy of a file, and delete a file or folder.

Publish and share your New Google Site

Preview and publish your site on the web, check your sharing options, and search a Google Site.

Sending email to large audiences with Gmail

When using Gmail, sending an email to a large number of people can have some negative effects. UM-ITS provides you with some helpful tips on avoiding these effects.

Share files with Google Drive

Find the file you want to share, choose who to share with & how they can use your file, and limit how a file is shared.

Share your Google Form and collect responses

Send your form to people, choose where to save form responses, and view and manage form responses.

Spear Phishing Don't Get Hooked (32:04) | Apr 28, 2016

Introduction on how to avoid phishing scams online.

Store files in Google Drive

Upload and download files and folders, supported file types, view and open files, back up photos and videos automatically, store and play video, save, edit and share Microsoft Office files, save web content, convert PDF and photo content to text.

Switching to Gmail from Outlook

Differences between Gmail and Outlook at a glance. Download instructions on how to make the switch from Outlook to Gmail.

Switching to Google Docs from Microsoft Word

Differences at a glance, work with documents, and do more with Google Docs. (PDF available for download).

U-M Box and Google Drive: Ownership and Permissions

While both U-M Box and Google Drive are great for maintaining a shared document repository, ownership, and permissions settings (including inheritance of these settings between top-level folders and their sub-folders) works very differently in each.

What's New with Google Sites (38:40) | Jan 25, 2017

Tutorial regarding the new features of Google Sites.

Work with Data in Google Sheets

Create and use pivot tables, name a range of cells, sort and filter your data, create an in-cell dropdown list, automatically create a series or list, use conditional formatting rules in Google Sheets, using arrays in Google Sheets, separate cell text into columns, customize a pivot table, and add & use checkboxes.

A quick introduction to the new Gmail

A quick look at how the new Gmail can help you accomplish more from your inbox. Overview of new features and interface looks.

Accessing U-M Google via a mobile device, Google Sync

Quick start information, get started with Google Sync, and Gmail features with Google Sync.

Compare Backup and Sync & Drive File Stream

If you want to sync files between Google Drive and your computer, there could be two options for your work or school account: Backup & Sync or Google Drive File Stream.

Course Groups in MCommunity and Google

U-M instructors on the Ann Arbor campus can use the MCommunity Directory to create groups based on course roster data in Wolverine Access. These groups are synchronized to U-M Google and can be used for sending email and sharing U-M Google resources.

Digital Signage: Connect to a Google Calendar

This document outlines the process for using a Google Calendar API (Application Program Interface) to customize how a calendar displays on digital signage. Note: a Google Calendar can also be added to digital signage simply as a website (live data content item). However, this method will display the calendar exactly as it appears in a web browser.

Digital Signage: Manage Content Using a Google Sheet

Presented as both a guided simulation and step-by-step instructions, learn how to create digital signage. Create and populate a spreadsheet, create a template and region, add live data content to your sign, and design the layout.

Events and Google Calendar

Create an event, invite people to your calendar event, change the privacy settings for your event, respond to event invitations, delete an event, transfer Google calendars or events, invite groups to calendar events, and use Google Calendar appointment slots.

Google Calendar Popular Articles

Share your calendar with someone, sync Calendar with a phone or tablet, import events to Google Calendar, change your Calendar settings, fix sync problems with the Google Calendar app, get started with Google Calendar, see Google Calendar events on Apple Calendar, and change or turn off Calendar notifications

Google Hangouts, Hangouts Meet, and Hangouts Chat Differences

Learn the differences between Google's "Classic" Hangouts and the new Hangouts Meet and Chat.

Google Jamboard Help Center

Google's Help Center which provides useful resources regarding Jamboard, including an overview, set-up, and support.

How to Install Google Drive File Stream

You can see and find your files in Google Drive on your computer with Drive File Stream. 

Introduction to Google Jamboard

Learn more about Google's newest product, Jamboard! It features a 55-inch, digital, collaborative whiteboard that works in the cloud.

IT4U83: Gmail Got a Makeover! (37:06) | June 7, 2018

Brian Cors (ITS) demonstrates the new web interface, with quick actions, Google’s suggested replies and even more integrations with other G Suite apps. 6/07/18. Resource links provided during the webinar.

Jamboard Quick Start Guide

Use this Quick Start Guide to learn about Jamboard features.

Learn what's new in Gmail

Gmail has a new look for the features you already use, plus new ways to organize your inbox, view upcoming events, and take action on emails.

Manage Resource Calendar Permissions

Once a resource calendar has been created, control of that calendar is turned over to the department that controls the resource itself. Access to the calendar, including who can see or reserve the resource is controlled by calendar permissions, permissions which are assigned to an MCommunity Group. This document is intended for ITS staff who manage resource calendars for their unit.

Managing Group Calendars & Resource Calendars

Group calendars -- for example, a unit vacation calendar -- are created and shared by the owner as secondary calendars. U-M Google resources are physical resources -- for example, conference rooms or loaner laptops -- that can be booked using the “Rooms, etc.” area in the calendar invite. 

Migrate Microsoft Outlook content to U-M Gmail

Important! This tool will not run on a Mac. What is a PST? Microsoft Outlook users may create a personal storage (.pst) file that contains archived email and calendar data. These files are stored outside of your normal mailbox on your local hard drive or shared drive. Information stored on PST files are not automatically migrated into Google and require additional steps.

New Gmail Interface Overview of Changes

Overview of the major Gmail updates, such as organize emails from your inbox, snooze emails until later, use suggested replies and follow-ups, expand or shrink your inbox view, edit labels & categories, and view Calendar, Tasks, Keep, & add-ons.
 

Overview of Jamboard

Jamboard can be used to host live sessions, create and edit content, control who can remotely access a "jam," and connect to other Jamboards.

Page settings and printing with Google Docs

Print or change page setup and zoom or change your document view.

Stop syncing Google Drive files with Backup and Sync

If you don’t want to back up your files from your computer, you can stop syncing.

Switching to Google Slides from Microsoft PowerPoint

Differences at a glance, work with Slides, and do more with Slides.

This is Jamboard: Introduction (1:36)

See how Jamboard works. It's like a whiteboard but better. It's a new way to collaborate, from Google.

U-M Google Spam email procedures

Here’s a few tips for navigating the Spam label in your U-M Gmail account. This document includes how to: help keep messages you send from being labeled as spam, manage the way your incoming mail is sorted, and see why a message was flagged as spam.

Search Other Resources