Google is committed to advancing racial equity for Black communities. See how.

Use Google Apps Script in G Suite

Learn to use Apps Script to create and manage user data in G Suite as demonstrated in Sheets.

 

Learn macros and custom functions

Codelab

Learn Apps Script basics to improve your Google Sheets experience.

Use spreadsheets, sheets, and ranges

Codelab

Learn how to read, write, and manipulate data in Google Sheets with Spreadsheet service.

Work with data

Codelab

Learn how to employ data manipulations, custom menus, and public API data retrieval in Apps Script to improve your Sheets experience.

Format data

Codelab

Learn how to format your spreadsheet data in Apps Script.

Chart and present data in Slides

Codelab

Learn how to use the Slides service to export charts to a new presentation in Google Slides.

Fundamentals of Apps Script with Google Sheets Quiz

Take the Fundamentals of Apps Script with Google Sheets quiz to earn the Apps Script badge. You must answer 4 of the 5 questions correctly.