Placeholder Image

Subtitles section Play video

  • Here's how to use Google sheets.

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

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

  • A drop down menu will appear.

  • Scroll down and select sheets to start.

  • 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.

  • Choose the location of your file.

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

  • Each document is made up of a sheet.

  • 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.

  • Type your new name and press enter.

  • 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.

  • Change color on, then selecting one.

  • 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.

  • Select your file and then click.

  • 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.

  • Let's click on this cell.

  • The column G is highlighted at the top.

  • 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.

  • Let's select all of our cost prices.

  • 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 is called the Range.

  • 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.

  • This is where the formulas are stored.

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

  • HM.

  • 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.

  • Press enter.

  • 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.

  • An air, a symbol will appear like this.

  • 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.

Here's how to use Google sheets.

Subtitles and vocabulary

Operation of videos Adjust the video here to display the subtitles

B1 click sheet select chart file spreadsheet

How To Use Google Sheets

  • 2 0
    林宜悉 posted on 2020/12/31
Video vocabulary