G Suite (Google) New Features

Google is always working to improve and add new functions and features to all their products.  We will post here any new updates on the products we use.

December 7, 2017

Google Sheets

  • Check out a refreshed UI for pivot tables in Sheets, and new, customizable headings for rows and columns.
  • View your data differently with new pivot table features. When you create a pivot table, you can “show values as a % of totals” to see summarized values as a fraction of grand totals. Once you have a table, you can right-click on a cell to “view details” or even combine pivot table groups to aggregate data the way you need it. We’re also adding new format options, like repeated row labels, to give you more fine-tuned control of how to present your summarized data.
  • Create and edit waterfall charts. Waterfall charts are good for visualizing sequential changes in data, like if you want to see the incremental breakdown of last year’s revenue month-by-month. Select Insert > Chart > Chart type picker and then choose “waterfall.”
  • Quickly import or paste fixed-width formatted data files. Sheets will automatically split up the data into columns for you without needing a delimiter such as commas between data.

These new Sheets features will roll out in the coming weeks—see specific rollout details below. To learn more about how G Suite can help your business uncover valuable insights and speed up efficiencies, visit the G Suite website. Or check out these tips to help get started with Sheets.

Google Sites

Embed HTML and JavaScript in the new Google Sites

Posted: 05 Dec 2017 12:50 PM PST

We recently made it possible to embed webpages as iframes in the new Google Sites. With this launch, we’re giving you one more tool to customize your sites—you can now embed HTML and JavaScript code directly into your sites.

Easily add a site-wide footer in the new Google Sites

Posted: 28 Nov 2017 12:07 PM PST

Many websites, especially those created for business purposes, require a consistent footer across all of their pages. These footers often house crucial information, like an organization’s contact information, privacy policy, and more. With this launch, we’re making it easy to create and manage these site-wide footers in a single place in the new Google Sites.

To add a footer, simply scroll to the bottom of your page and click “Add Footer.” This same footer will then appear across all of the pages on your site. To hide the footer on a single page, click the eye icon in the bottom left corner of the text box. If you then want to create a custom footer for that page only, you can create a new section (not using the “Add Footer” functionality) at the bottom of the page.

Google Photos

Changing how you view photos and videos in Google Drive

Posted: 04 Dec 2017 01:30 PM PST

Today in Google Drive you can view your Google Photos directly via a tab in the left navigation and from folders within My Drive.

In early January 2018, we will simplify Drive navigation by removing the Google Photos tab. You can continue to access your photos and videos in Drive by creating a Google Photos folder in My Drive. Learn more in the Help Center.

You can still access your photos and videos in Google Photos on the web, Android, and iOS.