Call +65 6100 0613

Instructor-Led Classroom Adult Training in Singapore - Learn New Skills to Enhance Your Employability from our SkillsFuture Courses

Automation with Google Apps Script Training

Google Apps Script is a powerful tool to automate your Google G Suite apps such as Google 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


Click here to submit SkillsFuture Credit for Individual

SSG WSG SkillsConnect WDA Absentee Payroll for Company

Course Code: CRS-N-0040152

Course Booking

$298.00

Course Date

Course Time

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Training Grant and Subsidy

All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website www.skillsfuture.sg/credit to choose from the courses available on the SkillsFuture Credit course directory

Course Details

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

Who Should Attend

  • System administrators that us Google script for automation
  • Data Scientists planning to use Google script

Prerequisite

Nil

Trainers

Google  Apps Script TrainerDr. Sarita Singh received her Ph.D. degree for her work done in the area of Information Security. She is the recipient of the prestigious Infosys fellowship for pursuing her Ph.D. Programme. She has more than twenty-five years of teaching and research experience in Singapore, Malaysia and India in the field of Programming, Information Security, Web-application Development, Computer Networks and Engineering related modules.

She has presented papers at several National and International Conferences and has written articles for magazines. She has authored text-books for Engineering courses as well.

Google Apps Script TrainerCarey is an undergraduate at the Singapore University of Technology and Design (SUTD). He has previously interned at DSO National Laboratories, where he co-wrote a research paper on differential cryptanalysis on block ciphers. As an avid game developer, he has clinched 1st-runner twice consecutively at the Singapore Games Creation Competition.

Besides having a vested interest in machines, he tries in his capacity to make a difference in society. In 2014, he co-wrote a research paper pinpointing the location of various civil unrests in Singapore, and advocated for the importance of civil unrest commemorative markers at the Anatomy of a Riot conference organised by the Singapore Heritage Society. Thereafter, he was invited to intern at the Ministry of Home Affairs to finetune the research. If one pays attention when crossing the junction of Alexandra Road and Tanglin Road, one can spot a blue rectangular marker commemorating the 1955 Hock Lee Bus Riots. The commemorative marker was established by the National Heritage Board after consultations with his team and the Ministry of Home Affairs.

When he is not trying to meet the demands of being an undergraduate in Singapore, he might be taking solitary walks in parks, or working on his pet projects involving Arduino or Raspberry Pi microprocessors.

Google Apps Script TrainerDr. Alfred Ang is the founder of Tertiary Courses. He is a serial entrepreneur. He founded OSWeb2Design Singapore Pte Ltd in 1997 offering web development, e-commerce store development, graphics design, ebook publishing, mobile apps development, and digital marketing services. He established the first online gardening store in Singapore, Eco City Hydroponics Pte Ltd in 2000, offering a wide range of gardening products such as seeds, plant nutrients, hydroponics kits etc. Eco City Hydroponics has become the most popular and successful gardening store in Singapore. He founded Tertiary Infotech Pte Ltd in 2012 and transformed the business to a training platform, Tertiary Courses in 2014. Tertiary Courses offers a wide range of SkillsFuture courses for PMETs to upgrade their skills and knowledge. He also established Tertiary Courses Malaysia in 2016. He also founded Tertiary Robotics in 2015 offering Arduino, Raspberry Pi, Microbit and Robotics products

Dr. Alfred Ang earned his Ph.D. from National University of Singapore in 2000, majoring in Electrical and Electronics Engineering. He also completed an online MBA course with U21 Global based in Australia. He obtained his B.Sc (Hons) from National University of Singapore in 1992, majoring in Physics. He topped his Physics cohort for 3 consecutive years and funded his degree study with Book price, awards and tuition. He has worked in Defence, Electronics and Semiconductor Industries. His current interests include Machine Learning, Deep Learning, Artificial Intelligence, Internet of Things, Robotics and Programming.

Dr. Alfred Ang was Distinguished Toastmasters (DTM) and Senior Member of IEEE. He has published more than 20 peer reviewed papers and co-inventors for more than 20 inventions.

Write Your Own Review

You're reviewing: Automation with Google Apps Script Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha

Tags

Other people marked this product with these Subjects:

Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses