|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-google-sheets-course-beginner-to-advanced/
课程评论：没有评论
**课程名称：** The Complete Google Sheets Course: Beginner to Advanced! **课程概述：** 本课程旨在教授您 Google Sheets 的全部知识，从基础操作到高级技巧，并且其中许多内容也适用于 Microsoft Excel。您将学习基本功能，如加减法，还将掌握 VLOOKUP、INDEX(MATCH()MATCH())、IMPORTRANGE 等强大的高级公式。 即使您之前从未听说过这些术语，也请放心，课程将从基础开始，循序渐进地讲解，确保您能理解。通过学习，您将构建一套全面的电子表格工具包，其中包括： * **基础入门：** 如何创建 Google 账户和 Google 表格。 * **算术函数：** 如 SUM、COUNT 和 AVERAGE。 * **高效操作：** 如公式填充到数千个单元格的快捷方式。 * **可视化图表：** 创建高级图表和精美的可视化效果。 * **数据分析：** PIVOT TABLES（数据透视表）。 * **高级函数：** INDEX MATCH MATCH 和 IMPORTRANGE。 * **强大的 QUERY 函数：** 掌握“万能”的 QUERY 函数。 本课程的最终目标是帮助您掌握实用的电子表格技能，无论是用于专业还是个人目的，并且让学习过程充满乐趣！ **教学方法：** 本课程打破了传统在线课程的模式，不只是观看他人操作，而是结合实际职业经验，提供更具实践意义的学习体验。课程内容包括： * **讲座** * **活动** * **项目** * **练习** * **幻灯片** * **全面的电子表格工作簿（附带答案密钥）** * **额外的学习资源** **内容更新：** 课程会根据 Google Sheets 的更新（如 Tables 功能等）进行内容补充，敬请期待。 **立即报名，体验 Google Sheets 学习的乐趣、精彩和价值！**
In this course you will learn the fundamentals of Google Sheets (some of which translates to Microsoft Excel!). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like VLOOKUP, INDEX(MATCH()MATCH()), and IMPORTRANGE.Never heard of those before? Don't worry! I start from the beginning - so those terms will become clear when the time is right. Along the way, you will develop an amazing spreadsheet toolkit. Wondering what tools will be in that toolkit? Check out the list below for some highlights of the course:Learn the basics like how to create a Google Account and a Google Spreadsheet Arithmetic Functions like SUM, COUNT, and AVERAGEShortcuts like filling formulas across THOUSANDS of cellsAdvanced charts & Beautiful VisualizationsPIVOT TABLES - though I don't particularly like them...Advanced functions like INDEX MATCH MATCH and IMPORT RANGEQUERY, the function that DOES IT ALL! Ultimately, the point of this course is to get some awesome skills for professional or personal use. And - above all - have fun doing it!My course isn't like a lot of other online Excel or Google Sheet courses. Most of these courses force you to watch them build things and hope that you understand what they are doing. Instead of that old model, I've incorporated everything I've learned from my experience in the real professional world to make this the best online Google sheets course. The course includes:LecturesActivitiesProjectsExercisesSlidesComprehensive Workbooks WITH Answer KeysExtra Learning ResourcesIf you have any questions, please don't hesitate to contact me. Sign up today and see how fun, exciting, and rewarding web development can be!There are some updates to Google Sheets like Tables and others. We may be adding more content to the course to address these - stay tuned!
