U-M Google Updates

New Features in Google Sheets!

Google announced new features in Google Sheets. They began rolling out today, January 24.

Pivot table updates

  • Create new ones with Explore
  • Customize row and column headings
  • Summarize values as a fraction of grand totals
  • View cell details
  • Combine groups to aggregate data
  • Repeat row labels and format in new ways

See Help Center for more details: Customize a Pivot Table.

Suggested formulas

Using machine intelligence, full formula suggestions appear when “=” is entered in a cell.

More new Sheets features

  • Waterfall charts visualize sequential changes. Click Insert, Chart, and then choose waterfall.
  • Sheets will automatically split up fixed-width formatted data without a delimiter.

Read the full announcement on the G Suite updates blog.

New Collaboration Training

Working with U-M Box (ITS_BOXC100)

2/2/2018
1–3 p.m.
Shapiro 2054
REGISTER

(2 hrs) This hands-on instructor-led session demonstrates how to get the most out of your U-M Box account. Learn about file storage and and sharing. Find out how to set various permission levels depending on collaborators’ roles. Edit files directly from Box and send links for others to view. Bring your laptop if you would like to follow along.

Working With Google Drive (ITS_GOOC102)

2/13/18
1–3 p.m.
Shapiro 2054
REGISTER

(2 hrs) Want to learn how to use Google Drive more productively? This instructor-led session will help familiarize you with the main Google Drive applications: Docs, Sheets, and Slides. Participants will learn how to upload and create files, how to set permissions for files, and how to share files.

Working with the New and Improved Google Sites (ITS_GOOC104)

3/9/18
2–3 p.m.
WOTO G228
REGISTER

(60 mins) Want to create websites that are easy to use but yet dynamic? This instructor-led session will help you create a basic site(s) using Google Sites. Participants will learn how to create a site by adding pages, images, text, graphics, and embed Google Documents, Sheets, Forms and other apps. This 1-hour instructor-led course is scheduled at least 3 times a year. Prerequisite: Basic understanding of Google products.

Coming Soon: Changes to how you view photos and videos in Google Drive

Currently, photos and videos in Google Drive are accessed by a tab in the left navigation and from folders in My Drive.

Early in January 2018 Google will simplify Drive navigation by removing the Google Photos tab. To access your photos and videos in Drive, create a Google Photos folder in My Drive.

You Can Now Embed HTML and Javascript in Sites

Google is launching a new tool for the new Google Sites that will allow you to customize your Sites by embedding HTML and JavaScript code directly into your Site. To embed your code, select Embed from the Insert menu and choose Embed Code.

U-M Google November Summary

The monthly U-M Google Summaries inform campus of Google releases for Core Apps as well as the Non-Core Apps (those that are not part of the G Suite for Education agreement). We communicate important information on Core Apps throughout the month. Core and Non-Core Apps are listed on the G Suite website

Core Apps

Previously Communicated