|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-spreadsheet-tutorial/
课程评论:没有评论
**课程名称:精通Google Sheets (并了解它为何优于Excel)** **课程概述:** 本课程旨在帮助您成为Google Sheets的精通用户。更新至2015年11月,课程内容全面,涵盖Google Sheets的基础操作、高级功能以及其独有的强大工具。您将学习如何像使用Microsoft Excel一样使用Google Sheets,并掌握其特有的优势。 **主要学习内容:** * **基础操作:** 掌握Google Sheets的导航、数据和信息显示方式的调整。 * **公式与计算:** 快速轻松地通过“表单填入”方法编写公式,并创建强大的计算。 * **数据可视化:** 使用图表和图形直观地展现数据。 * **数据工具:** 学习排序、汇总和筛选等数据处理工具。 * **自动化与扩展:** 通过编写脚本和使用插件来自动化任务。 * **高级技巧:** 揭示Google Sheets的秘密和快捷方式。 **额外赠送技能:** * **网络数据抓取:** 学习如何从网络上收集数据。 * **在线表单创建:** 学习如何创建在线表单以收集用户信息。 **课程特色:** * 提供挑战和测验,帮助您巩固学习。 * 指导如何寻找和下载免费的Google Sheets模板。 * 完成课程后可获得结业证书。 * 永久访问课程内容,方便回顾和学习新内容。 **课程目标:** 学完本课程后,您将能够像大师一样使用Google Sheets,并能充分利用其超越Excel的独特功能。 **讲师:** Justin Mares (Google Sheets专家)
**Updated to Include Google Sheets November 2015 Updates!!**Become a master Google Docs user with this course on using Google Spreadsheets. You'll learn:How to use Google Spreadsheets just like you use Microsoft Excel3 amazing tools only available in Google SpreadsheetsHow to write your own scripts and use Google addons to get more doneHow to create charts, tables, graphs and format data This course will give you you everything you need to know about Google Spreadsheets.From the fundamentals, to the most advanced features, after taking this class you will be able to use Spreadsheets like a MASTER. Pretty soon, you'll be using Spreadsheets better than most people can use Excel.and be able to take advantage of the super useful features that only Google Spreadsheets has to offer.In this course, you will learn all of the following about Google Spreadsheets:Learn how to navigate around SpreadsheetsLearn how to adjust the way data and information are displayed Learn how to write formulas quickly and easily with the point-and-click methodLearn how to create powerful calculations Learn how to visually represent your data with charts and graphs Learn how to use data tools like sorting, subtotaling, and filteringLearn how to automate tasks with time-saving scripts and addonsLearn Spreadsheets secrets and shortcutsAs bonus material, you will also learn two very incredible, and super valuable, skills:how to harvest data from the webhow to create online forms which allow you to gather data from individualsAs an additional bonus, you can follow along and complete challenges and quizzes as you learn the material. You will also be shown how to find and download free Spreadsheet templates that will allow you to do all kinds of things. Another great aspect of this course is that, at the end of this class, you will be given a CERTIFICATE OF COMPLETION. This class is guaranteed to teach you Google Spreadsheets. Once enrolled, you will have access to this course for the rest of your life. You will always be able to come back to this class to review material or to learn new material. Try this course for yourself and see how quickly and easily you too can learn to use Google Spreadsheets.Justin Mares, Google Sheets wizard