Skip to content

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

Playback Speed:
Transcript

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!

Next