Google at U-M Learning Resources

Resources: 98
Start using G Suite in 7 easy steps

G Suite was formerly known as Google Apps

Google Team Drives Overview

Google Team Drives is a new features 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. 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. See data sensitivity information by role- Students, Researchers, Faculty, and Staff

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

Request a shared account, Overview, Benefits, Manage a shared account (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)
Top 10 ways to use G Suite in Project Management
Top 20 ways to use G Suite for Administrative assistants
Google working with Mcommunity groups

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.

Google: Accounts for People Who Leave U-M

Roll-off procedures, What happens with my U-M Google account when I retire, Cooperative and uncooperative departures

Managing MCommunity Groups & UMICH Passwords for Shared Accounts

Managing the MCommunity Directory group profile associated with a shared account, 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 you 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 Box.

Signing In and Out of Your U-M Google Account Via the Web

This document provides tips for signing in to and out of your U-M Google account in ways that protect your privacy and the security of your password.

Get Started with Gmail

Compose & send, Reply, Organize your inbox, Find email, Create signatures

Get Started with Google Calendar

Schedule events, Add reminders, Share and view, Create a team calendar, Customize

Get started with Google Docs

Create or import, Edit and format, Share and collaborate, 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

Build your form, Share and collaborate, Send your form, Analyze responses

Get started with Google Hangouts

Start Chats or video calls, Join a video call, Share your screen and add more people

Get started with Google Sheets

Create or import, Add content, Share and collaborate, Print and download

Get started with Google Sites

Create your site, Update and personalize your site, Share and collaborate, Preview and publish your site

Get Started with Google Slides

Create or import; Add content; Share and Collaborate; 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

Ideas for how to use Gmail with descriptions and instructions; Get more out of using Gmail

Google Calendar Tips & Tricks

Ideas for how to use Google Calendar with descriptions and instructions; Get more out of using Google Calendar

Google Docs Tips & Tricks

Ideas for how to use Google Docs with descriptions and instructions; Get more out of using Google Docs

Google Drive Tips & Tricks

Ideas for how to use Google Drive with descriptions and instructions; Get more out of using Google Drive

Google Forms Tips & Tricks

Ideas for how to use Google Forms with descriptions and instructions; Get more out of using Google forms

Google Hangouts Tips & Tricks

Ideas for how to use Google Hangouts with descriptions and instructions; Get more out of using Google Hangouts

Google Mobile tips and tricks

Ideas for how to use G Suite for mobile devices with descriptions and instructions; Get more out of using Google with mobile devices

Google Sheets Tips & Tricks

Ideas for how to use Google Sheets with descriptions and instructions; Get more out of using Google Sheets

Google Sites tips & tricks

Ideas for how to use Google Sites with descriptions and instructions; Get more out of using Google Sites

Google Slides Tips & Tricks

Ideas for how to use Google Slides with descriptions and instructions; Get more out of using Google Slides

Google Spreadsheets Function List

Categorized & filter-equipt list of all available functions

Google Team Drive and My Drive Differences

Google Team Drives is a new features 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 other differences between Team Drive and My Drive.

Google Team Drive IT4U

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

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

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

Gmail quick-reference diagrams

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

Google Calendar Quick-Reference Diagrams

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 Docs Quick-Reference Diagrams

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, Collaborate with your team in real time. (Can download as a PDF)

Google Drive Quick-Reference Diagrams

Upload any files (such as PDFs, videos, and pictures) and folders from your computer, Create new documents right in your browserWork with files you’ve stored in Drive, Share your files and folders and choose what collaborators can do, Add shared files to My Drive, Access your files from any device. (Can download as a PDF)

Google Forms Quick Reference Diagrams

Design your form, Share and collaborate on your form, Choose where to collect your responses, Preview and send your form, View and analyze responses. (Can download as a PDF)

Google Hangouts Quick Reference Diagram

Start a chat or video call in Gmail; Join a call from Gmail and Inbox, Calendar, or your browser; Work with video calls. (Can download as a PDF)

Google Sheets Quick Reference Diagrams

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; Work with functions. (Can download as a PDF)

Google Sites Quick-Reference Diagrams

Open Google Sites; Customize your site and homepage; Add pages and navigation; Add content to pages; Share, preview, or publish your site. (Can download as a PDF)

Google Slides Quick-Reference Diagrams

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. (Can download as a PDF)

Working with Gmail

Information and instructions for best working with Gmail. Includes Mail labels and filters, Manage large volumes of email, Work with attached files and Best practices for Gmail.

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

Walkthroughs and comparisons

Create a new Google Site

Create, name, or rename a site; add a logo; Add, order, nest, and delete pages; System requirements and browsers

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 bulleted or numbered lists; 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; Suggest edits in Google Docs; Edit and use a document outline; Add or delete columns in a document

Create, edit, and format Google Forms

How to use Google Forms, Create a survey, Create and grade quizzes, Edit your form, Add a theme to a form, Show questions based on answers, 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

Popular Articles, Manage your Gmail account, Read and organize emails, Settings, Send emails, Gmail App, Fix a problem

Gmail Help Center Popular Articles

Sign in to Gmail, Add or remove inbox categories and tabs in Gmail, Change or reset your password, Change your Gmail settings, Change email notifications, Can't sign in to your Google Account

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 advanced editing tools

Use add-ons & Apps Script, See what’s changed in a file, Search and use find and replace, Use spell-check and auto correct, Count the words in a document, Translate documents or write in a different language, Use equations, See and use suggested content, Keyboard shortcuts, Type with your voice

Google Forms advanced tools and troubleshooting

Set rules for your form, Use add-ons and Apps Script, Keyboard shortcuts for Google Forms, Can't open a form

Google Forms from Start to Finish (13:09)

How to use Google Forms

Google sending email to large audiences

Gmail, Sending an email to a large number of people can have certain negative effects:

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

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; Issues editing

How to use Google Sheets

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

Insert items in Google Docs

Add, edit, or remove a link, bookmark, or page break; Insert or delete images or videos; Add headers, footers and page numbers; Insert special characters; Add a chart or table to Google Docs or Slides

Intro to Google Forms (3:30)
Manage your new Google Site

Find or delete your site, Collect analytics data, Migrate classic Sites to new Sites, Classic Sites vs. New Sites, Troubleshooting, Screen readers for new Google Sites, Keyboard shortcuts for new Google Sites

New Google Sites - Deeper Dive (5:58)
New Google Sites Overview (5:45)
Organize and find your files in Google Drive

Organize your files, Delete and restore files, Find or recover files, Sort your files, View activity and file descriptions, Change notification settings

Organize your Google Mail (46:41) | Mar 17, 2016
Preview, share, and publish your new Google Site

Preview and publish your site on the web, Choose who can edit your website, Access a site from secondary domains

Share files with Google Drive

Share files from Google Drive; Stop, limit, or change sharing, Make someone else the owner of your file; Share folders in Google Drive; Share files with team drives; Anonymous or unknown people in a file

Share your Google Form and collect responses

Send your form to people, Choose where to save form responses, View and manage form responses

Spear Phishing Don't Get Hooked (32:04) | Apr 28, 2016
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 at a glance, Work with email, Do more with Gmail

Switching to Google Docs from Microsoft Word

Differences at a glance, Work with documents, Do more with Google Docs

Sync Google Drive files to your computer

Install Google Drive on your Mac or PC, Change your sync settings, Stop syncing files between your computer and Google Drive, Fix problems syncing to your computer

The New Inbox by Gmail (40:54) | Nov 17, 2016
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.

Use and manage Google Hangouts

Change your status and profile photo, share photos/videos/location, keyboard shortcuts, delete or turn off your message history, block or ignore someone, manage your contacts, turn off notifications, Use Google voice with Hangouts

What's New with Google Sites (38:40) | Jan 25, 2017
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; Use arrays in Google Sheets; Separate cell text into columns

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

Quick start information, Get started with Google Sync, Gmail features with Google Sync

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: Create and populate a spreadsheet, Create a template and region (Add live data content to your sign), Design the layout, and an Example.

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, Change or turn off Calendar notifications

Manage Resource 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 IT 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.

Migrate to U-M Google (Gmail) from Microsoft Outlook

Instructions and documentation for Google's migration tool, GSMMO. Important: This tool does not work on a Mac.


Page settings and printing

Print or change page setup, Zoom or change your document view.

Switching to Google Slides from Microsoft PowerPoint

Differences at a glance, Work with Slides, Do more with Slides

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 labled as spam, manage the way your incoming mail is sorted and see why a message was flagged as spam.

Work with 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, Use Google Calendar appointment slots

Search Other Resources