We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

SkillsFuture Course - Google Apps Script Training

Meet Google Apps Script, the master key that unlocks the power of your favorite Google apps, including Docs, Sheets, Gmail, Calendar, and Drive. This JavaScript-based platform allows you to access data from the Google cloud, edit files, automate tasks, and extend apps' power. You can even share your scripts with others in the form of add-ons. Interested in learning more?  This Google Apps Script course will show you how to use simple scripts to edit documents and spreadsheets, work with files in Drive


Topics include:

  • What is Google Apps Script?
  • Understanding script types
  • Logging and debugging your scripts
  • Scripting common tasks
  • Building custom spreadsheet functions
  • Creating add-on functionality such as dialogs and sidebars
  • Sharing your script as a web app

Outline

Module 1. Getting Started

  • What is Google Apps Script
  • What can Google Apps Script Do? 
  • Bound Script
  • Standalone Script
  • Your First Script

Module 2. Working With Document and Spreadsheet

  • Create New Document
  • Edit Document
  • Create New Spreadsheet
  • Edit Spreadsheet

Module 3. Custom Function

  • Create Custom Function
  • Output to Multiple Columns
  • Output to Multiple Rows

Module 4. Triggers & Event

  • Trigger Types
  • Simple Trigger
  • Installable Trigger
  • Time Driven Trigger
  • Alert & Custom Dialog

Module 5. Web Apps

  • Requirement of Web Apps
  • Serve HTML as Web Apps
  • Pusblish Web Apps

Speaker/s

Mr. Tan Wee Giap has several years of software development experience in Windows and Windows Phone. He is also familiar with Google Apps and has done a far amount of Google App Script development. Having taught in a secondary school for 4 years in Computer Applications such as MS Office, Scratch, Inkscape, etc, he has acquired the pedagogy to help him deliver the lesson more effectively.

Special Offer

Follow us on FB and subscribe to our newsletter to get updates on our Monthly Promotional Offers.

Reviews
Be the first to write a review about this course.
Write a Review

Tertiary Courses Singapore offer many SkillsFuture courses in Singapore. We offers wide range of classroom instructor-led technical training courses for working professionals and executives in Singapore. Many of our courses and trainings are SkillsFuture Approved and eligible for WDA Absentee Payroll Grant.

Our courses include Infocomm, Digital Media, Robotics, Semiconductor,Telecommunication, Life Science, Horticulture Industries , and Business Administration . Below are some of our popular courses

  1. Python Programming
  2. R Programming
  3. Tableau
  4. Machine Learning
  5. Raspberry Pi
  6. Arduino
  7. 3D Printing
  8. iOS Apps Development
  9. Android Apps Development
  10. Magento eCommerce
  11. Wordpress
  12. Joomla
  13. Search Engine Optimization
  14. Web Design
  15. Google Analytics
  16. Facebook Marketing
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.