2. Introduction to Google Workspace: Sheets - Part 1
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 yourability 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 certificationexam. For more practice, you may choose to complete the rest of the lessons in this seriesthat use Google Sheets. Spreadsheets are a common and versatile toolused to present information. You may be familiar with budgeting or projectmanagement spreadsheets, but there are many different ways to use them.
You might use a spreadsheet to organize information, such as travel expensesor a shopping list, create a tracker to manage the people andtasks for a project, or keep a log of grades or assignments inschool or sales and invoices in a small business.
It’s possible to use a pen and paper to record similar information, but with a digitalspreadsheet, 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 itfrom 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 youcompile large amounts of data, ensure accuracy, and frequently update the spreadsheet whenmore data is available. In this lesson, you will use a spreadsheetof data from fundraiser sales. At this community fundraiser, people bought t-shirts, and volunteerskept 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 responsesto 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 viewedin detail and more easily compared. To complete this lesson, you will use thedata from the fundraiser sales in a spreadsheet. You will make a copy of the spreadsheet withthe 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 yourspreadsheet by adding limits to what values can be entered in each cell and sorting thedata. Customizing your sheet by formatting, editing,and organizing makes it more visually appealing and easier for a team of collaborators touse. While you might not use sales data in yourwork, the skills in this lesson will prepare you to manage complex spreadsheets for manyfuture tasks. This lesson uses Google Sheets, but you canapply these concepts in any spreadsheet application. To work on this lesson, sign in to your Googleaccount. Open a new tab in your browser, and navigate to Google.com. If you are notsigned 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.