Placeholder Image

字幕列表 影片播放

自動翻譯
  • 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.

    你也可以通過Google Drive啟動工作表。

  • Click on plus new Google sheets on then blank spreadsheet.

    在空白的電子表格上點擊加新的谷歌表格。

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

    使用sheet時,Google Drive會自動將所有內容隨手保存。

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

    Google Sheets提供了現成的模板,供個人和企業使用,如發票模板每週計劃員的支出報告。

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

    通過點擊文件夾圖標,您將能夠從現有的Google Drive文件夾中選擇或創建一個新的文件夾。

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

    我們從電腦上上傳一個Excel文件,點擊上傳,然後點擊選擇設備上的文件。

  • Select your file and then click.

    選擇你的文件,然後點擊。

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

    選擇Google Sheets會問你想如何格式化你上傳的數據。

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

    你需要確保你的Excel文件被轉換,以確保它在Google Sheets中正常工作。

  • To do this go to the Google Drive settings tool.

    要做到這一點,請進入Google Drive設置工具。

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

    G列在頂部突出顯示。

  • The Row nine is highlighted on the left G nine.

    行九在左G九上突出。

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

    我們點擊C五,然後向下拖動就可以看到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.

    在Google工作表中使用公式時,你可能需要參考你所選擇的一組單元格。

  • This is called the Range.

    這就是所謂的範圍。

  • This range would be called C five colon H 13.

    這個範圍就叫C五冒H13。

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

    你可以在Google sheets中使用基本公式來創建一個公式。

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

    點擊FX標誌旁邊的白色Bar。

  • This is where the formulas are stored.

    這是存儲公式的地方。

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

    對於每個單元格,你可以在這裡寫公式,也可以編輯。

  • HM.

    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.

    首先,雙擊你想要總計的地方,然後在FX欄中鍵入公式,總是以等號開始公式,然後是公式指令鍵入等號,後面是一些大寫字母,後面是開放的括號,後面是範圍我們的範圍從D五到D13作為空氣的數字,我們要總計。

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

    所以將打出D五冒號D13,後面再打上一個封閉的括號來完成等式。

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

    那麼你應該回到你的FX欄,你可以編輯它,直到它的正確性。

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

    你可以通過學習Google Sheets語言來學習如何創建其他公式。

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

    您的圖表將出現在旁邊和編輯窗口,以改變從一個到D條形圖到不同風格的圖形。

  • Select chart type and choose the design you want.

    選擇圖表類型,選擇你想要的設計。

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

    您可以通過選擇將Siri的添加到您的圖表中。

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

    添加Siri的要刪除它,點擊三個點,然後選擇。

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

以下是如何使用谷歌表。

字幕與單字
自動翻譯

影片操作 你可以在這邊進行「影片」的調整,以及「字幕」的顯示

B1 中級 中文 點擊 單元格 工作表 公式 表格 圖表

如何使用Google Sheets (How To Use Google Sheets)

  • 2 0
    林宜悉 發佈於 2020 年 12 月 31 日
影片單字