Kick off the new school year with lessons from our Back to School 2021 collection to help students express themselves, build relationships, and stay organized.

1. Introduction to Google Workspace: Sheets - Part 3

Playback Speed:
Transcript

Spreadsheets are a common and versatile tool used to present information.

You may be familiar with using spreadsheets for budgeting or project management, but there are many different ways to use a spreadsheet.

You could: 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 for school or sales and invoices for a small business.

If you completed the first two Google Sheets lessons in the series, you formatted a sheet containing raw data about shirts sold for a community fundraiser, then analyzed the data with filters, functions and charts.

But spreadsheets aren’t just for organizing and analyzing information.

They are also useful tools for making calculations and projections for a business or project.

In this lesson, you will: Import a spreadsheet in another file format into Google Sheets and combine your spreadsheets to create a broader and more inclusive view of the sales data for the fundraiser...

Use functions to make calculations and summarize the data so you and your collaborators can scan the sheet quickly to find the necessary information...

Use conditional formatting to make specific details in your sheet stand out...

And insert non-text elements, such as links and images, into your sheet, to make it more useful and interactive.

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 second lesson in the series, continue using the spreadsheet from that lesson.

Open Google Drive..

and find the file.

If not, 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.

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.