Google Sheets is an online spreadsheet program for collaboratively creating and sharing data. This video tutorial provides an overview and basic navigation of Google Sheets.
- [Instructor] Let's take a look at Google Sheets. Google Sheets is an online spreadsheet program. It's compatible with Microsoft Excel, so I can upload Excel files directly into Google Sheets and have access to them from anywhere or share them with anyone. To open Google Sheets from my Google Drive I'm gonna go to New, and then Google Sheets. This will launch a new blank Google Sheet. If I click on the green rectangle in the top left corner that will take me to my Google Sheets homepage. From here I can open a Blank Google Sheet, I can access my recently used Google Sheets, or I have access to a Google Sheets template gallery.
Let's go back into a new Google Sheet. I'm gonna click on Blank from the Google Sheets homepage. I can give my spreadsheet a name by clicking on Untitled spreadsheet at the top of the screen. I can add data to my cells by double-clicking in the cell I want to type in. There are tabs across the bottom of the sheet. If I need to add an additional tab I can click on the Add Sheet button at the bottom of the screen. If I click on the down arrow next to a tab I can see my options for managing my tabs.
I can Delete a tab, Duplicate or make a copy of a tab, Copy this sheet to another place in my Google Drive, Rename the tab, Change the color, Protect or Hide this specific sheet, or I can navigate the tabs. I can also click on the tabs to drag them across the bottom. Let's head over into a different document that already has some data entered. I wanna show some of the features I use most often for calculating data.
A Pivot table is a quick way to analyze data that allows you to pivot easily from one analysis to another. I can create a Pivot table by going to Data, and then selecting Pivot table. If I have a list of quiz scores I can add functions to my cells to automatically calculate data for me. Let's say I wanna find the average of these scores. I'm gonna click in the cell where I want the average to appear, I'm gonna go to Insert, Function, and I wanna find the Average, but there are some other features here as well.
Now it's asking what cells I wanna find the average of. I can use the arrows on my keyboard to navigate to the first cell, put in a colon, and then enter the last cell. If I hit Enter it's gonna go ahead and calculate that average for me. If I change one of the scores in this list it's going to change the average score as well. I can upload an existing Microsoft Excel document to Google Sheets. From Google Sheets I just go to File, and then Import.
From here I can choose a file that's already on my Google Drive, choose a file that's been Shared with Me, access a recently used file, or Upload a file from my computer hard drive. If I clicked on Select a file from your computer I can navigate to the file I wish to use. I'm gonna click on Open, and now it's asking me if I want this file to be a new spreadsheet, if I wanna insert it into an existing spreadsheet, or if I want to replace a spreadsheet? I'm gonna Create a new spreadsheet and click Import.
This let's me know that my file was imported successfully and if I click Open now I can access that document. There's no need to save my work, all changes are automatically saved in Google Sheets, and I can just exit out of the document when I'm ready to move on. Google Sheets is a great way to calculate and track data.
- Sending large attachments with Gmail
- Filtering email in Gmail
- Uploading and downloading files in Google Drive
- Creating student assignment folders
- Adjusting Google Docs sharing and security options
- Providing feedback in Docs
- Voice typing and translating content
- Collaborating with Google Sheets
- Presenting with Google Slides
- Creating and sharing Google Forms
- Building a self-grading quiz in Google Forms
- Creating events and appointments in Google Calendar