|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-apps-script-sheets/
课程评论：没有评论
课程名称：Google Apps Script 项目 - 自定义 Google Sheets 功能 课程概述：本课程将引导您探索如何在 Google Sheets 的用户界面菜单中创建自定义选项。通过弹出提醒功能，连接 Google Apps Script 来运行自定义电子表格代码，以查找和选择符合特定值的单元格。您将深入了解 Google Apps Script 的功能，以及如何利用电子表格中的数据运行代码，发掘 Google Apps Script 的各种应用。 课程内容涵盖了一些最常被请求的功能，如添加自定义 UI 菜单和高级选项，以提升您的电子表格功能。例如，搜索功能将通过 UI 提示让用户输入搜索词，搜索所有工作表并突出显示匹配内容的单元格。邮件功能允许用户将选定内容通过电子邮件发送给自己，并构建一个 html 表格。复制功能则可以将选定内容复制到新工作表，并基于选定数据创建内容。 需注意，课程要求学员具备 JavaScript 和相关编程经验，请确保具备此基础再进行学习。本课程由拥有超过 20 年网页开发经验的讲师 Laurence Svekis 授课，他将引导您实现一些令人惊叹的功能，帮助您高效利用 Google Apps Script 和 G Suite 内容。课程也提供源代码，最好通过试验代码并创建您自己的项目版本来学习。此外，课程的问答部分提供快速友好的支持。 如果您希望改变使用 Google Apps 和 G Suite 的方式，不妨考虑参加本课程！
Explore how you can create a custom Google Sheet option within your Google Sheets UI menu.PopUp alert connects to Google Apps Script to run custom spreadsheet code o find and select cells that match the value.Explore Google Apps Script and how it can be used to run code using data from your SpreadsheetDiscover the amazing things you can do with Google Apps ScriptCourse covers some of the commonly asked for functionality using Google Apps Script and Google SpreadsheetsDo more with your Spreadsheets adding a custom UI menu with advanced optionsSearch - uses UI prompt to ask the user for a search term, searches all the sheets within the spreadsheet and highlights the cells with matching content. Email - Lets the user email themselves the selected content from the spreadsheet, construct an html table some selected active spreadsheet data. Send the email.Copy -Copy selected content to a new sheet, takes the selected data create a new sheet and builds the content from the selection.JavaScript and prior coding experience is REQUIRED DO NOT TAKE THIS COURSE WITHOUT JavaScript ExperienceSource code is included - Best way to learn is to try the code and create your own version of this projectTaught by an instructor with over 20 years of web development experience ready to help you learnGoogle Developer Expert - Laurence Svekis walks you through how to do some amazing functionality to save time and get the most out of Google Apps Script G Suite contentFast friendly support is always available in the Q & A sectionWhat are you waiting for - this could change everything - at least change the way you use Google Apps and G Suite Google Sheets
