Skip to content

1. Introduction to G Suite Certification: Sheets - Part 2

Playback Speed:
Transcript

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 first lesson using Google Sheets in this series before beginning this lesson. Spreadsheets are common and versatile tools that are used to present information in the workplace and at home.

You may be familiar with spreadsheets used for budgeting or project management, but there are many different ways to use a spreadsheet. 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.

If you completed the first lesson in the G Suite Certification series, you formatted a sheet containing raw data about shirts sold for a community fundraiser.

But spreadsheets aren’t just for listing information. They are also useful for making calculations, summarizing, and visualizing data.

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.

In this lesson, you will create filters in your spreadsheet. When you create a filter or use a filter view, you limit the information that you see at any given time or organize the data by a specific value in the cells. This makes it easier to see only the data that is relevant to you. Then, you will use the filters you created, as well as spreadsheet functions, to make calculations and analyze your data.

Finally, you will create charts of your data to better visualize the information.

For example you might: filter your data by the size of shirts, calculate the number of shirts sold in each size, then create a graph that displays this information in a visual format.

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.

If you completed the first lesson in the G Suite Certification series, you will continue using the spreadsheet you started in that lesson. Open Google Drive, and find the file.

If not, you will use the starter project. Open the starter project and make a copy of the spreadsheet. Remove the words “copy of” and add your name to the title. Now, it’s your turn: Sign in to your Google account, Open Google Drive and find your spreadsheet from the previous lesson, Or, make a copy of the starter project, And update the title.

Next
Instructions
  1. Sign in to your Google account.
  2. Open Google Drive and find your spreadsheet from the previous lesson.
  3. Or, make a copy of the starter project.
  4. Update the title.