Sheets

試算表

Start 0:00 開始

Introduction 0:03 簡介

Start Page 0:28 首頁

Interface 2:10 介面

Search the Menus 3:46 表單

Navigating and Selecting Cells 5:51 選擇儲存格

Entering and Editing Data 8:37 輸入及編輯數據

Explore 11:49 探索

Performing Simple Calculations 17:03簡單計算

Saving 19:57儲存

Introduction to Google Drive 21:04 雲端硬盤

Building Basic Formulas 24:22建立試算表函式

Using Simple Functions 28:03 使用基本功能

Copying Formulas and Functions with AutoFill 32:50 自動填寫功能

Relative vs Absolute Reference 37:15相對及絕對參考

Inserting Rows and Columns 43:30插入列和欄

Moving, Copying, and Pasting Data 46:57 移動、複製及貼上數據

Using AutoFill to Complete a Series of Values 49:54 自動填寫

Cell Formatting - Align, Text Rotation, Text Wrapping 53:07 儲存格格式

Formatting Worksheet Data and Using Cell Design 57:19 更改格式

Using Sheets Templates 1:00:29 使用模板

Inserting, Deleting, Renaming, Moving, and Copying Worksheets 1:02:02 插入、刪除、更改名稱、移動及複製工作表

Freeze Panes 1:04:49 限制頁面查閱方式

Currency Formatting 1:07:44 貨幣格式

Hiding Rows and Columns 1:08:34 隱藏列和欄

Spell Check 1:10:39 檢查拼寫工具

Using the Full-Screen View 1:12:00 全屏模式

Printing 1:12:55 列印

Download Options 1:14:31 下載選項

Publishing Sheets to the Web 1:15:16 線上模式

Sending Sheets as Emails 1:16:21 把工作式變成電郵附件

Conclusion 1:18:14 總結

0:00 Intro 簡介

0:25 Why these functions? 影片學習目標

0:41 SUM 總和

1:08 The info window of Functions 如何使用功能

1:28 SUMIF Set conditions for your function 建立不同條件

2:35 Joining strings or text together using these three functions.使用不同功能

2:55 CONCATENATE 連鎖功能

3:55 JOIN 匯合

4:54 TEXTJOIN 匯合文字

5:30 COUNT Count how many numeric values there are in the selected range 統計

6:14 COUNTA Count the number of values (All values) 統計總和

6:47 COUNTIF Set conditions before counting the number of values 在特定條件下進行統計

7:21 AVERAGE Whats the average of the selected range? 平均數

7:52 TODAY Whats the date today? Interactive and updated automatically自動更新

8:35 DATE Use a date using a set format.日期格式

9:23 Find out the difference in days between today and a set date in the past or future. 比對現在及其他日期

9:55 VLOOKUP Use this to find specific information from a larger dataset. 快速找尋數據

11:20 SPARKLINE The number one function needed for a quick visual chart within a cell. 顯示圖表

11:58 GOOGLETRANSLATE Translate any language into another, automatically! 自動翻譯

12:37 GoogleTranslate to automatically create flashcards in Google Slides (Link: https://youtu.be/4J8WJDTjA9Y) 把翻譯內容轉換成抽認卡

14:04 CHAR Use a Unicode Character incells. This is great when creating Bullet points and lists. List of all characters: 文字格式 http://www.unicode.org/charts/

15:46 UNIQUE Get an overview of all unique results 檢視特定結果

16:15 RANDBETWEEN Get a random number to use in class 隨機抽樣

Google Sites

Report abuse