|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-sheets-for-beginners/
课程评论：没有评论
**Google Sheets 入门：Google Sheets 基础课程摘要** 本 Coursera 课程是一门面向初学者的全面指南，旨在帮助您掌握 Google Sheets 的基本使用。本课程特别适合对电子表格感到陌生，希望高效协作并实时保存工作成果的用户。 **课程亮点：** * **入门到进阶：** 从创建新表格开始，循序渐进地学习单元格、行、列、主题、格式化、快捷键等基础知识。 * **增强功能：** 学习插入图片、复选框、评论，以及使用 Google Drawing 添加视频和绘图。 * **数据管理：** 掌握数据清理、数据验证（包括创建下拉菜单）、排序和筛选等实用技巧。 * **核心功能：** 学习基础公式和函数（包括 QUERY 函数），以及如何处理多个工作表。 * **可视化和分享：** 了解如何创建和自定义图表，并学会与他人协作、分享、下载和打印您的 Google Sheets 文件。 * **学习资源：** 课程提供 4 小时的视频教程、38 个视频讲座，以及与讲师相同的配套练习文件，方便您跟随学习。 **学习成果：** 完成本课程后，您将能够： * 熟悉 Google Sheets 的界面和操作方式。 * 熟练处理表格中的单元格、行、列，并进行分组和合并。 * 应用各种格式化选项和条件格式。 * 创建数据验证和下拉菜单。 * 有效地进行数据排序和筛选。 * 理解并使用基础公式和函数。 * 创建和定制各种图表。 * 实现与他人的实时协作和文件分享。 本课程不设硬性教学大纲，但内容涵盖了 Google Sheets 的核心功能，为您的电子表格之旅打下坚实基础。无论您使用 PC 还是 Mac，本课程都将帮助您成为一名熟练的 Google Sheets 用户。
**This course includes course instructor files and exercise files to work with and follow along.**Discover how to use Google's popular online spreadsheet application with this comprehensive beginner course for Google Sheets. This application is perfect for collaboration as it allows you and other users to work on the same spreadsheet at once and have all your changes saved in real-time. No more conflicting changes and lost work! Think of it as using Excel, only better.In this Google Sheets for Beginners course, we start from the very beginning, where we teach you how to create a sheet from scratch. We'll work through rows and columns, themes, formatting, and a handful of keyboard shortcuts. We'll also cover inserting images, checkboxes, and comments as well as using Google Drawing.This course also discusses data cleanup and data validation, including how to create dropdown menus. We then move on to basic formulas and functions, sorting and filtering, working with multiple sheets, adding graphs and charts, and sharing your sheet.This is a beginner-level course designed for Google Sheets novices who would like to get started with spreadsheets and is suitable for both PC and Mac users. We've also included accessible exercise and instructor files the same Google Sheets files that the instructor used in the tutorial so you can follow along.What you'll learn from this course:Different ways of accessing Google SheetsGetting familiar with the Google Sheets interfaceWorking with cells, rows, and columns, including group and mergePC and Mac keyboard shortcutsHow to apply themes, formatting, and conditional formattingInserting images, links, checkboxes, comments, and notesMaking use of Google Drawing to insert videos and drawingsAdding data validations and dropdown selectionsHow to sort and filter data in Google SheetsAn overview of basic formulas and functionsHow to use the Query functionWorking with multiple sheetsCreating charts and graphs and learning different chart typesEditing and customizing chartsSharing your sheet and collaborating with other usersPublishing, downloading, and printing Google Sheets filesThis course includes:4 hours of video tutorials38 individual video lecturesCourse and exercise files to follow alongCertificate of completion
