Name: How To Use Google Sheets
Uploaded: 2020-12-31T18:20:20.000Z
Duration: 7 min 34 s
Description: Thousands of YouTube videos with English-Chinese subtitles! Now you can learn to understand native speakers, expand your vocabulary, and improve your pronunciation...

Use the clickable sections below to skip through different parts of this tutorial.

Participle clauses

Once logged in, click on the Google Maps icon at the top right corner of your screen.

You can also launch sheets through Google Drive.

Click on plus new Google sheets on then blank spreadsheet.

When using sheets, Google Drive automatically saves everything as you go.

Just make sure you're connected to the Internet.

You'll represented with a blank sheet and other template options.

Google Sheets offers ready made templates for personal and business use, such as the invoice Template weekly Planner on Expenses report.

We'll start with a blank sheet to name your sheet, click on untitled spreadsheet and type the name.

By clicking on the folder icon, you'll be able to choose from an existing Google Drive folder or create a new one.

You'll see this at the bottom where it says sheet one.

You can have multiple sheets within each document to add a new one.

Click on the plus icon to rename your sheet double click on sheet one.

Click on the arrow positioned next to the title to see more ways to organize your sheet.

You could duplicate your sheet or copy it to another spreadsheet to keep certain sheets private.

Within a document, you can activate a password by clicking here.

You can also change the color of your sheet by hovering your cursor over.

To import data into your sheet, go to the top menu and click file and then import.

A pop up menu will appear and you'll be presented with options of where you can upload your file from.

Let's upload an Excel file from our computer, click on upload and click Select file from your device.

Choose Google Sheets will ask you how you'd like to format your uploaded data.

You can create a new spreadsheet, replace data at selected cell or replace the entire spread shoot.

We'll select to create a new spreadsheet.

You'll need to ensure that your Excel file is converted to ensure it works properly in Google Sheets.

To do this go to the Google Drive settings tool.

Click on settings, then click the box next to convert up loads.

Your files will now be automatically converted in the future.

Sheet consists of cells, columns and rows, columns that indicated alphabetically at the top and rose numerically down the side.

You can select each column or each row by clicking on its letter or number.

You can double click on a cell types of information and press enter.

When using Google sheets, you'll want to know which sell your information is in when using formulas.

Each cell is named by the column letter, followed by the row number.

The Row nine is highlighted on the left G nine.

You can select multiple cells, which is useful when you need to create formulas or want to move cells around, click on a cell and drag your cursor across other cells to select a group.

We'll click on C five and then dragged down to see 13.

Once selected, you can hover over the edge of the selection until you see the grab icon, click and drag to move yourselves around.

When using formulas in Google sheets, you may need to refer to a group of cells you're selecting.

This range would be called C five colon H 13.

You can use basic formulas in Google sheets to create a formula.

Select the cell where you want to see your answer at the top of your screen.

Click on the white Bar next to the FX sign.

For each cell, you'll be able to write formulas here as well as edit.

Let's use a formula to add up how much stock we have.

First, double click where you want the total and then type the equation in the FX bar always started formula with an equal sign followed by the formula instruction type equals, followed by some in capital letters, followed by open bracket, followed by the range Our ranges from D five to D 13 as thes air the numbers we want to total.

So will type D five colon D 13, followed by a closed bracket sign to complete the equation.

If the formula has been entered correctly.

The total will immediately be showed in the cell.

If you've made a mistake, perhaps you've misspelled something.

Then you should go back to your FX bar, and you can edit it until it's correct.

You could learn how to create other formulas by learning the Google Sheets language.

Create a header so it remains at the top of your sheet.

When you scroll down, hover your mouse over the gray line at the bottom of the top left corner, sell and it'll turn blue, click on it and drag past the head of cell and release.

All the cells in Row one are now a header.

You can use the same method to lock cells in a column, customize your header by clicking on it and using the format icons at the top of your page.

First, highlight the data you want to use in your chart, then go to insert and click on chart.

Your chart will appear alongside and editing window to change from a to D bar chart to a different style of graph.

Select chart type and choose the design you want.

You can add a Siri's to your chart by selecting.

Add Siri's to delete it, click on the three dots and then select.

Remove for more ways to change your chart, click on the customized tab to change your background color and format your chart.

 Click on charts style and select your preferences. 