|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sheetsforschoolleaders200/
课程评论：没有评论
**Google Sheets for School Leaders - 200 Level 课程概要** 本课程是为学校领导者设计的进阶课程，旨在帮助您利用 Google Sheets 更快、更轻松、更有效地做出数据驱动的决策。如果您已掌握 Google Sheets 的基础知识，本课程将助您将数据管理能力提升至新水平，重点关注能够实现数据动态更新的公式和技巧。 **核心学习内容：** * **FILTER 和 INDIRECT：** 学会无需复制粘贴即可将数据从一个工作表移动到另一个工作表。 * **UNIQUE 和 SORT：** 掌握在不同位置处理数据，自动去除重复项或重新排列数据。 * **ARRAYS 和 ARRAYFORMULA：** 学习即时修改数据，并编写一个公式即可应用于整组数据，无需逐行复制。 * **IMPORTRANGE：** 掌握从您或其他人的 Google Drive 中的完全不同的 Google Sheet 导入数据。 **每节课程包含：** * 包含分步说明和讲解的视频课程。 * 供您跟随练习的练习 Google Sheet。 * 检验您理解程度的个人练习活动。 * 完整的课程记录。 * 可下载的演示文稿。 **先修课程建议：** 如果您需要学习 Google Sheets 的基础知识，建议先完成本系列课程的 100 Level 课程。
Welcome to Sheets for School Leaders, a self-paced course for learning how to use Google Sheets as a school leader to make data-based decisions quicker, easier, and more effectively.This course is designed to take your Google Sheets data management to the next level by focusing on FORMULAS and tricks that will help you make your data update dynamically as adjustments in student data occurs at the school. If you need to work on the basics of Google Sheets, I recommend my 100 Level course first before taking this course.In this course, you will learn:FILTER and INDIRECTMove data from one sheet to another without having to copy and paste!UNIQUE and SORTManipulate data from one place to another, removing duplicates or rearranging automatically.ARRAYS and ARRAYFORMULAModify data on the fly, and write one formula to be run repeatedly on a whole set of data. No more copying formulas all the way to the bottom of a table!IMPORTRANGECopy data over from a completely different Google Sheet in your, or someone else's, Google Drive!Each of these lessons includes:Video lesson with step-by-step instructions and explanations.Practice Google Sheet to follow along with the guided practice.Individual practice activity to test your understanding.Full transcripts of each lesson.Downloadable slide deck.
