|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/google-sheets
课程评论：没有评论
课程名称：Google Sheets 课程概述：本课程介绍了Google Sheets，Google的基于云的电子表格软件，包含在Google Workspace中。使用Google Sheets，您可以直接在网页浏览器中创建和编辑电子表格，无需特殊软件。 多个人可以同时协作，您可以实时看到他人的修改，所有的更改都会自动保存。 您将学习如何打开Google Sheets，创建空白电子表格，并从模板创建电子表格。您将通过Google Sheets添加、导入、排序、过滤和格式化数据，并学习如何处理不同类型的文件。 公式和函数使您能够快速进行计算，更好地利用数据。我们将学习如何创建基本公式、使用函数和引用数据。您还将学习如何为电子表格添加图表。 Google Sheets电子表格易于共享。我们将探讨与他人分享的不同方式，并讨论如何跟踪更改和管理版本。 Google Workspace使您与团队、客户等人方便协作。我们将探索Google Sheets中的一些协作选项，包括评论、待办事项和通知。 课程大纲： 1. 课程介绍：本模块涵盖课程议程，介绍On the Rise及课程商业挑战。 2. Google Sheets介绍：本模块将介绍Google Sheets，并讨论如何打开和创建新电子表格，还将学习如何将现有电子表格导入Google Sheets。 3. 使用Google Sheets管理数据：本模块将讲述如何添加和组织数据。您将学习如何添加、粘贴和导入数据，并学习如何排序和过滤数据，特别是在处理大量数据集时。 4. 格式化Google Sheets电子表格：本模块将探索一些电子表格格式化的方法，包括基本格式选项（如单元格颜色和文本换行）及冻结单元格和保护数据的选项。 5. 基本公式、函数和图表：本模块将学习如何创建基本公式、使用函数、命名范围和引用数据。您还将学习如何创建图表，并了解Google Explore，这是一种强大的工具，可以根据从数据中获得的洞察回答问题并提出建议。 6. 共享Google Sheets电子表格：本模块将讨论与他人共享电子表格的不同方法。您将学习如何添加协作者并分配角色和权限，以及如何通过链接共享Google Sheets电子表格。您还将了解如何将电子表格转让给其他协作者、跟踪更改和管理版本。 7. 使用Google Sheets协作：本模块将介绍与Google Sheets的协作选项，包括评论、待办事项和通知。 8. 商业挑战：本模块将帮助您将所学知识付诸实践，帮助虚构的Google Workspace客户解决商业挑战。
Name:Course Introduction
Description:This module covers the agenda. It also introduces students to On the Rise and the course business challenge.
Name:Introduction to Google Sheets
Description:In this module, we will introduce Google Sheets and discuss how to open and create a new spreadsheet. We will also look at importing an existing spreadsheet into Google Sheets.
Name:Manage data using Google Sheets
Description:In this module, we will talk about adding and organizing data with Google Sheets. You will learn how to add, paste and import data. You will also learn how to sort and filter data in your spreadsheets which is especially useful when working with large datasets.
Name:Format a Google Sheets spreadsheet
Description:In this module, we will explore some of the ways you can format your spreadsheets. This includes some of the basic formatting options, such as cell colors and text wrapping, and options to freeze cells and protect data in your Google Sheet.
Name:Basic formulas, functions, and charts
Description:In this module, we will look at creating a basic formula, using functions, named ranges and referencing data. You will also learn how to create a chart, and be introduced to Google Explore, a powerful tool that can be used to answer questions and make suggestions based on insights gained from your data.
Name:Share your Google Sheets spreadsheets
Description:In this module, we will look at the different ways to share your spreadsheets with others. You will learn how to add collaborators and assign them roles and permissions, and also learn how you can share your Google Sheets spreadsheet with a link. You will understand how to transfer ownership of your spreadsheets to another collaborator, track changes, and manage versions.
Name:Collaborate with Google Sheets
Description:In this module, we will look at some of the collaboration options available to you with Google Sheets. Examples include commenting, action items, and notifications.
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.
In this course we will introduce you to Google Sheets, Google’s cloud-based spreadsheet software, included with Google Workspace. With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically. You will learn how to open Google Sheets, create a blank spreadsheet, and create a spreadsheet from a template. You will add, import, sort, filter and format your data using Google Sheets and learn how to work across different file types. Formulas and functions allow you to make quick calculations and better use your data. We will look at creating a basic formula, using functions, and referencing data. You will also learn how to add a chart to your spreadsheet. Google Sheets spreadsheets are easy to share. We will look at the different ways you can share with others. We will also discuss how to track changes and manage versions of your Google Sheets spreadsheets. Google Workspace makes it easy to collaborate with your team, clients, and others wherever they are. We will look at some of the collaboration options available to you in Google Sheets. Examples include commenting, action items, and notifications.
