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 sub-headers 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.
Sign in with Google
