Haylee Luedtke

This course builds on some of the concepts covered in the earlier Google Sheets course. In this course, you will learn how to apply and customize themes In Google Sheets, and explore conditional formatting options. You will learn about some of Google Sheets’ advanced formulas and functions. You will explore how to create formulas using functions, and you will also learn how to reference and validate your data in a Google Sheet. Spreadsheets can hold millions of numbers, formulas, and text. Making sense of all of that data can be difficult without a summary or visualization. This course explores the data visualization options in Google Sheets, such as charts and pivot tables. Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. You will explore how Forms and Sheets work together by connecting collected Form data to a spreadsheet, or by creating a Form from an existing spreadsheet.

完成 在 Google 試算表使用函式、 公式及圖表 任務，即可獲得技能徽章。這項中級任務說明如何運用函式分析資料， 並以圖表呈現。您會學到如何搜尋、 驗證、呈現資料，以及如何設定資料的格式。「技能徽章」是 Google Cloud 核發的 獨家數位徽章，用於肯定您對於 Google Cloud 產品與服務的精通程度。 獲得技能徽章代表您已通過測驗，能在互動式實作環境 應用相關知識。完成技能徽章任務和結業評量挑戰實驗室之後， 即可取得數位徽章並與他人分享。