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!