In this lesson, you made a copy of a spreadsheet that was automatically generated from salesdata. Although it was accurate, it wasn’t verywell organized, easy to read, or visually appealing. Formatting, color coding, and organizingyour spreadsheet makes it easier for you -- and the people you share it with -- to find andanalyze 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 collaboratorsby making it easier to read with data validation. The skills you learned in this lesson areuseful for other types of spreadsheets, as well.
For instance, you might use Cell merging to clearly delineate headersand subheaders in a personal budget, borders to divide sections of a spreadsheetcovering 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!
1. Introduction to G Suite Certification: Sheets - Part 1
2. Sheets: Duplicate Your Sheet and Add New Data — Add, Delete and Insert Data
3. Sheets: Format and Organize Spreadsheet Data — Use Bold and Italics, Merge Cells, Set Alignment, and Format Dates
4. Sheets: Continue Formatting and Organizing — Freeze Cells, Columns, and Rows, Add Borders, Set Fill Color, Add Borders, and Change Fonts and Sizes
5. Sheets: Add Data Validation to Limit Options
6. Sheets: Sort Your Data — Name and Sort Sheets or Ranges