Udemy

Google Apps Script Project Sheet UI custom Functions

立即報名
  • 2,213 名學生
  • 更新於 11/2024
4.7
(19 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
0 小時 52 分鐘
教學語言
英語
授課導師
Laurence Svekis
評分
4.7
(19 個評分)
3次瀏覽

課程簡介

Google Apps Script Project Sheet UI custom Functions

Search Sheet data and select Sheet cells create custom Google Apps Script code to run within your Google Sheets 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 Spreadsheet

Discover the amazing things you can do with Google Apps Script

Course covers some of the commonly asked for functionality using Google Apps Script and Google Spreadsheets

Do more with your Spreadsheets adding a custom UI menu with advanced options

  • Search - 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 Experience

Source code is included - Best way to learn is to try the code and create your own version of this project

Taught by an instructor with over 20 years of web development experience ready to help you learn

Google 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 content

Fast friendly support is always available in the Q&A section

What are you waiting for - this could change everything - at least change the way you use Google Apps and G Suite Google Sheets

課程章節

  • 2 個章節
  • 21 堂課
  • 第 1 章 Introduction to Google Sheets functions with Apps Script
  • 第 2 章 Google Apps Script Common Questions and Answers with Source Code examples

課程內容

  • Perfect for anyone who wants to learn more about Google Apps Script
  • Anyone who wants to learn how to select content from Sheets and add to HTML table
  • Anyone who wants to search sheets and highlight the found content in cells


評價

  • M
    Mark Weng
    5.0

    非常棒的講解

  • G
    Guillermo Ithier
    5.0

    Great course! simple to follow and practical scripts that are applicable to many various extensions on google sheets. Laurence is also active on responding to your inquires.

  • M
    Miguel A. Reyes
    5.0

    Easy to follow and useful for real life cases. Well done Lawrence!

  • H
    Hung Nguyen
    5.0

    helpful course

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意