Slide thumbnail

Update knowledge G Suite

Knowledge

Additional tools for enhanced reporting in Google Sheets

10/09/2019

What’s changing 

We’re adding three new tools to help you generate more compelling reports and better display data in Google Sheets:

 

  • Slicers
  • Scorecard Charts
  • Themes

 

Earlier this year we announced several new features for objects in Sheets. Together, these new features make for a more impactful reporting experience in Sheets.

 

Các công cụ bổ sung cho báo cáo nâng cao trong Google Sheets

Using Slicers, Scorecard Charts, and Themes together to enhance reporting.

 

Who’s impacted

End users

 

Why you’d use them

You can use these tools to filter, display key data, and customize the look and feel of your spreadsheets, making it easier and faster to generate more engaging and informative reports.

 

How to get started

  • Admins: No action required.
  • End users: See below for how to use each new tool in Sheets.

 

Additional details

 

  • Slicers:

Slicers are a new way of filtering for reports or dashboards by condition and by values. To learn more about using Slicers in Sheets, see our Help Center.

 

  • Scorecard charts:

Scorecard charts is a new way to call out key metrics, such as KPIs or a key stat, within your sheet. You’ll have the option to show your stat in comparison to another number, for instance illustrating percentage increase or decrease over time. See our Help Center for more information on how to insert a Scorecard chart in Sheets.

 

  • Themes:

You can now quickly alter the look and feel of an entire spreadsheet—including charts, pivot tables, and cells—to ensure a consistent look and feel for your spreadsheets. To apply a preset theme, select Format > Theme and choose an option, or to create a custom theme, select Customize in the top right.

 

Gimasys.

 

Knowledge

Update and support center for administrator and user