Create a Spreadsheet to Structure Data

In this lesson, you will collect and organize information about important locations in Google Sheets to create a guide to an area.

You could create a guide to an area in a document or presentation, but the user would have to manually search through long lists or many slides to find what interests them.

Putting information or data into a spreadsheet allows you to structure it into columns and rows that are easily manipulated.

Columns are vertical groups of cells... ...While rows are horizontal groups of cells.

When you structure data in a spreadsheet, you can: Sort it, to group data in different ways, filter it, to see only what you need, and manipulate it, so you can identify patterns.

In this lesson, you will: Change font styles and sizes, wrap and align text, resize columns and rows, and use borders, fill, and alternating colors to make your guide useful and fun.

If you'd like, you can use helpful features within Google Sheets like a screen reader or keyboard shortcuts.

These features can make your spreadsheet easier to navigate and allow you to work more efficiently.

Click on the links next to this video to learn how to use these and other features.

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 don't have a Google account, pause the video and create one.

Then, open your drive and create a new spreadsheet in Google Sheets.

Now, it's your turn: Create a blank spreadsheet in Google Sheets.