|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/google-sheets---advanced-topics
课程评论：没有评论
课程名称：Google Sheets - 高级主题 课程概述： 本课程在之前的Google Sheets课程基础上进一步深入。学员将学习在Google Sheets中应用和自定义主题，以及探索条件格式选项。课程将介绍一些Google Sheets的高级公式和函数，学员将学习如何使用函数创建公式，并学习如何在Google Sheet中引用和验证数据。 电子表格可以容纳数百万个数字、公式和文本。没有摘要或可视化，理解这些数据可能会困难。本课程探讨了Google Sheets中的数据可视化选项，如图表和透视表。 Google 表单是用于收集数据的在线调查，提供了快速数据分析的机会。学员将探索表单与电子表格的结合方式，包括将收集的表单数据连接到电子表格，或从现有电子表格创建表单。 课程大纲： 1. 课程介绍：本模块涵盖课程议程，并介绍“On the Rise”以及课程商业挑战。 2. Google Sheets中的高级格式：讨论应用主题和条件格式选项，以自定义电子表格并利用数据。 3. 高级公式和函数：讲解如何创建公式、使用函数及引用和验证数据，讨论命名范围的使用。 4. 数据分析与报告：探讨数据可视化选项，如图表和透视表，以及如何使用Google Workspace集成轻松分享图表和表格，并使用宏来自动化重复任务。 5. 使用Google表单填充数据：探索Google表单与Google Sheet的结合，连接收集的表单数据或根据现有电子表格创建表单。 6. 商业挑战：通过帮助虚构的Google Workspace客户解决其商业挑战，将所学知识付诸实践。 本课程旨在帮助学员掌握Google Sheets的高级功能，提高数据处理和分析的能力。
Name:Course introduction
Description:This module covers the agenda. It also introduces students to On the Rise and the course business challenge.
Name:Advanced formatting in a Google Sheet
Description:There are many advanced formatting options that help you customize your Google Sheets and leverage your data. In this module, we are going to talk about applying themes and conditional formatting options.
Name:Advanced formulas and functions
Description:Formulas and functions allow you to make quick calculations and better use your data. Google Sheets supports many of the formulas found in other spreadsheet applications. In this module, we are going to look at creating a formula, using functions, and referencing and validating data. We will also discuss how using named ranges can assist you when working with data sets.
Name:Analyze and report
Description:Spreadsheets can hold millions of numbers, formulas, and text. Making sense of all of that data can be difficult without a summary or visualization, especially when presenting the data to colleagues, partners, prospects, or clients. In this module, we are going to explore the data visualization options in Google Sheets, such as charts and pivot tables. We will discuss how Google Workspace integration makes it easy to share your charts and tables in Google Docs and Google Slides. We also look at ways to automate repetitive tasks using macros.
Name:Populate data using a Google Form
Description:Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. In this module, we’re going to explore how Google Forms and Google Sheets work together by connecting collected form data to a spreadsheet, or by creating a form from an existing spreadsheet.
Name:Business challenge
Description:In this module, you will put everything you have learned into practice by helping our fictional Google Workspace customer solve their business challenge.
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.
