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 产品与服务方面的熟练度。 您需要在交互式实操环境中参加考核，证明自己运用所学知识的能力后 才能获得此徽章。完成此技能徽章挑战任务和作为最终评估的实验室挑战赛， 获得数字徽章，在您的人际圈中秀出自己的技能。