The Google G Suite is a set of cloud-based apps that can be used to create documents, spreadsheets, presentations, and more. Earning your G Suite certification demonstrates your ability to use digital skills to work collaboratively and productively in a professional environment.
Completing this lesson about Google Sheets will help prepare you for your G Suite certification exam. For more practice, you may choose to complete the rest of the lessons in this series that use Google Sheets. Spreadsheets are a common and versatile tool used to present information. You may be familiar with budgeting or project management spreadsheets, but there are many different ways to use them.
You might use a spreadsheet to organize information, such as travel expenses or a shopping list, create a tracker to manage the people and tasks for a project, or keep a log of grades or assignments in school or sales and invoices in a small business.
It’s possible to use a pen and paper to record similar information, but with a digital spreadsheet, you can easily keep track of a lot of information, analyze, filter, and sort the data, and make difficult calculations quickly.
When compiling data for a spreadsheet, you may add the information yourself, take it from an existing document, or use another source.
Or, you can download data from a computer application or website directly into a spreadsheet.
Many programs will do this for you automatically. Creating a spreadsheet from an app helps you compile large amounts of data, ensure accuracy, and frequently update the spreadsheet when more data is available. In this lesson, you will use a spreadsheet of data from fundraiser sales. At this community fundraiser, people bought t-shirts, and volunteers kept track of how many shirts were purchased and what styles and designs they chose.
Similar survey data might be collected with a form in other scenarios, such as responses to a customer satisfaction questionnaire or feedback on a new business practice.
In this example, the responses were downloaded into a spreadsheet so the data could be viewed in detail and more easily compared. To complete this lesson, you will use the data from the fundraiser sales in a spreadsheet. You will make a copy of the spreadsheet with the data, update headers so they are more meaningful, add borders between sections, and resize columns to make the information easier to read. Then, you will organize your spreadsheet by adding limits to what values can be entered in each cell and sorting the data. Customizing your sheet by formatting, editing, and organizing makes it more visually appealing and easier for a team of collaborators to use. While you might not use sales data in your work, the skills in this lesson will prepare you to manage complex spreadsheets for many future tasks. This lesson uses Google Sheets, but you can apply these concepts in any spreadsheet application. To work on this lesson, sign in to your Google account. Open a new tab in your browser, and navigate to Google.com. If you are not signed in, do so now.
If you do not have a Google account, pause the video and create one.
To begin, open the starter project and make a copy of the spreadsheet.
Remove the words copy of and add your name to the title.
Then, move onto the next lesson to begin editing your spreadsheet.
Now, it’s your turn: Sign in to your Google account, Make a copy of the starter project, And update the title.
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
7. G Suite Certification: Sheets - Part 1 Wrap-Up
- Sign in to your Google account.
- Make a copy of the starter project.
- Update the title.