Work Smarter with Google Spreadsheet on G suites

What is G Suites

G Suite (formerly Google Apps for Work and Google Apps for Your Domain) is a brand of cloud computingproductivity and collaboration tools, software and products developed by Google, first launched on August 28, 2006 as “Google Apps for Your Domain” G Suite comprises GmailHangoutsCalendar, and Google+ for communication; Drive for storage; DocsSheetsSlidesForms, and Sites for collaboration; and, depending on the plan. It also includes the digital interactive whiteboard Jamboard  and the app development platform App Maker.

So what is new on G Suites?

According to G suites launch calendar, Google will be launching several new features and tools that will help you create more compelling and stylized reports in Sheets

Google Sheets makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. All for free. Google sheets are really helpful for collaborative working.

These new features will include
  • Guides
  • Multi-Selecting Objects
  • Enhanced Pivot Table Insertion
  • Copy and paste images into Sheets
  • Formula backed charts inserted from Answers

Guides 

  • You can use guides to help you align, size, and position various objects within your sheets. Guides are also helpful in making sure multiple objects within the same sheet are in proportion to one another.

Multi-selecting objects 

  • To select multiple charts, drawings, and images to move, resize, or delete in bulk, hold down the Control or Shift key and select.

 


Enhanced pivot table insertion 

  • When adding a new pivot table, you’ll now have the option to either place it in a new sheet or in a custom location on an existing sheet.
    • To create a new pivot table, go to Data > Pivot Table and select a data range.
    • In the dialogue box, under Insert to,select New sheet or Existing sheet, and click Create. Note that if you select existing sheet, you’ll have to select a specific cell location for the pivot table.

 

Copy and paste images into Sheets 

  • Recently, we made it easier to add images to your spreadsheet by inserting images into cells. Now, you can copy images from other websites and paste them directly into your sheet.
    • Simply right click on an image and hit copy, then in Sheets right click and hit Paste to insert the image over the grid.

Formula backed charts inserted from Answers

  • Now, when you use Sheets Explore to create charts, the charts you insert from the Q&A feature (Answers) will be backed by formulas. This means that charts will automatically update if the underlying data changes, ensuring you always have a fresh chart with the latest information.

 

Availability

Rollout details

 

Leave a Comment