Course Information

  • Sessions 1 day
  • Duration 7.5 hrs
  • Level Beginner
  • Assessment NA

Venue

Kuala Lumpur: G-3A-02, Suite Pejabat Korporat, KL Gateway, No 2, Jalan kerinchi, Gerbang kernichi Lestari, 59200 Kuala Lumpur, Malaysia
Penang: Jalan Sungai Dua, 11700 Penang, Malaysia.

Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

Basic IT Automation with Google Apps Script Training

Course Code: C187

What's This Course About

Unlock the boundless possibilities of automation within the Google Workspace through our specialized Automation with Google Apps Script Training. Kickstart your journey with a deep understanding of what Google Apps Script entails and explore its seamless integration across the suite, be it Sheets, Slides, Doc, Calendar, or Drive.

Dive deeper into the nuances of crafting custom triggers, and empower your operations with the creation of automated email alerts, ensuring you stay abreast of every essential update. By the end of this comprehensive training, you'll be proficient in automating tasks, enhancing workflow efficiency, and maximizing the potential of the Google Workspace environment.

WSQ Funding

Full Fee 1,050.00 Before GST
GST 94.50 9% of fee
Baseline Nett 619.50 SG/PR age 21+ · 50% funded
MCES / SME Nett 409.50 SG age 40+ · 70% funded
Funding and Grant Applications

No funding is available for this course.

For WSQ funding, please checkout the details at WSQ - IT Automation with Google Apps Script

Course Fee

MYR1,050.00

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Disclaimer: The course dates displayed on our website are tentative and subject to trainer availability. We will confirm the final date after checking with the trainer. You are also welcome to email us your preferred date at sales@tertiarycourses.com.my, and we will do our best to coordinate with the trainer's schedule.

Post-Course Support

  • We may provide consultation related to the subject matter after the course.
  • Please email your queries to sales@tertiarycourses.com.my and we will forward your queries to the subject matter experts and get back to you as soon as possible.

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. The minimum class size to start a class is 3 Pax.

Course Details

Course Details

What You'll Learn

Topic 1. Getting Started

What is Google Apps Script

Google Apps Script Editor

Write Your First Google Apps Script

Mail Service

Run You Script

Topic 2. Google Sheet Script

Spreadsheet Service

Sheet Methods

Range Methods

Get and Change Cell Values

Apply Formula

Topic 3. Google Doc Script

Document Service

Document Methods

Body Methods

Text Methods

Modify and Append Text

Topic 4. Google Slide Script

Slide Service

Presentation Methods

Slide Methods

Modify Slide Font

Topic 5. Google Calendar Script

Calendar Service

Event Methods

Recurrence Methods

Create Calendar Events

Create Recurrence Events

Module 6. Google Drive Script

Drive Service

Create Folder and File

Topic 6. Google Drive Script

Drive Service

Create Folder and File

Topic 7. Triggers

What is Trigger

Time Driven Trigger

Setup an Auto Email Alert

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

  • Positive Learning Attitude
  • Enthusiastic Learner

Experience

  • Minimum of 1 year of working experience.

Target Age Group: 21-65 years old

Minimum Software/Hardware Requirement

Software: NIL

Sign up for free Google account

Hardware: Windows or Mac Laptops

Job Roles

Job Roles

  • Google Apps Script Developer
  • IT Automation Specialist
  • Technical Project Manager
  • Systems Analyst
  • Business Process Engineer
  • Cloud Solutions Architect
  • Data Analyst
  • IT Support Specialist
  • Workflow Automation Engineer
  • Application Developer
  • Integration Specialist
  • Database Administrator
  • Information Systems Manager
  • Enterprise Software Developer
  • IT Consultant
  • Quality Assurance Tester
  • Technical Trainer
  • DevOps Engineer
  • User Experience Designer
  • Software Engineer

Trainers

Trainers

Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc.  Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations. Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide.  An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes. Truman Ng: Truman Ng is a ACTA certified trainer that graduated with Bachelor Degree in Electrical Engineering from NUS in year 2002. He designed Artificial Intelligence (AI) controller for DC-DC Power Convertor by using Fuzzy Logic and Neural Network (NN) as his university Final Year Project. Truman has over 15 years project experiences across Database & Web Design, PLC machinery, Data Center Design , Structure Cabling System(SCS) and Enterprise Network Design and Implementation. He used to be a network architect for Hewlett Packard, working with a group of virtual team from the US in handling network design and projects in the States. Truman is the founder of Nexplore (S) Pte Ltd. He provides solutions of Cloud SaaS, IaaS & PaaS and Software Defined Network (SDN), VoIP and Internet Security. He was engaged by Huawei Global Training Center to provide 60+ consultations and trainings for Internet Service Providers(ISP) from Malaysia, Singapore, Brunei, Philippines, Australia, Poland, Iran, South Africa, Swaziland, Cote Dlvoire, Syria, Uzbekistan, New Zealand and countries over the world.As achievement, Truman has successfully completed 100+ IT network projects for Bank, Hotel and Factory within 5 years.Truman is certified in PMP, Cisco CCNP, CCIP, CCDP, HP Ase and Huawei HCNP, HCIE R&S, HCNA Cloud, HCNA Security, etc. Terence Ee: Terence Ee is a ACTA certified trainr that has delivered IT training in Singapore and Myanmar. He has also facilitated faith formation courses for Christians in Singapore and Myanmar. As a trainer, his mission is to co-create insightful and actionable learning experiences with his learners.His current areas of focus include project management, information security management, quality management and office productivity applications. Terence has more than 25 years of corporate IT experience. He has held senior management roles in the public and private sectors. He holds a Master of Science in Technology Management, a Bachelor of Science in Computer and Information Sciences, a Diploma in Family Education, and the Advanced Certificate in Training and Assessment (ACTA). Part of his spare time goes towards tutoring his children in their studies (while learning a thing or two along the way). He is also imparting to them the essential skills for thriving in a digital world. Fritz Lim: Fritz is ACTA-certified, as well as a registered MOE instructor, and a graduate of the 2018 ConsenSys Blockchain Developer Program, with a Bachelor in Electrical and Electronic Engineering (Computer Specialisation) from Nanyang Technological University. With more than 10 years of experience teaching at a local polytechnic, Fritz is passionate about imparting knowledge to teens, adults, and children. He believes that an education in technology and in how things work is essential for everyone, so that they can harness and invent the technologies of the future. He is excited about exploring anything related to computers and IT, with a keen interest in electronics and native cross-platform mobile app development so that our ubiquitous mobile phones can be conveniently used to control and interact with devices wirelessly and over the Internet.  Leon Ye Jin Hong: Leon Ye Jin Hong is a ACTA certified trainer.  He have exprience in RPA Architect, Test Automation lead, Coach and Trainer, Cloud Engineer(Azure) and Data Analysis. The Automation solutions have benefited Land Transport Authority, MINDEF Singapore, Ministry of Education(MOE), Ministry of Development(MND) Singapore Press Holdings(sph),ST Engineering, Accenture, Defence Science & Technology Agency(DSTA) and Singapore Exchange. Some Robotic Process Automation that he experience in: Automated Booking System(Customer Service), Finance Invoice Processing, HR Recruitment, HR onboarding & Offboarding and Automated Data Exchange & Reporting Generation.

Review

Write Your Own Review

You're reviewing: Basic IT Automation with Google Apps Script Training