Skip to content
Need to learn or teach remotely? Check out our new resources to help you work, learn or teach from anywhere.

7. G Suite Certification: Sheets - Part 1 Wrap-Up

Playback Speed:

In this lesson, you made a copy of a spreadsheet that was automatically generated from sales data. Although it was accurate, it wasn’t very well organized, easy to read, or visually appealing. Formatting, color coding, and organizing your spreadsheet makes it easier for you -- and the people you share it with -- to find and analyze data quickly. To make it more engaging, you: Duplicated the original sheet and assigned it a tab color, Added rows and columns, Typed data into cells, Added and edited headers, Added data validation to certain cells, And sorted your data by a specific column.

You also learned how to make a spreadsheet more useful for you and your collaborators by making it easier to read with data validation. The skills you learned in this lesson are useful for other types of spreadsheets, as well.

For instance, you might use Cell merging to clearly delineate headers and subheaders in a personal budget, borders to divide sections of a spreadsheet covering months of the year in job application tracker, data validation to assign a team member to a task in a project tracker, or sorting to arrange a list of volunteers in alphabetical order.

Keep creating new spreadsheets to master the skills you learned in this lesson.

Or you can explore more G Suite Certification lessons to learn and practice with other applications!

Certificate of Completion

certificate thumbnail

Certificate of Completion

certificate thumbnail
As a teacher, you can print a blank template.