Course Overview:
The Google Apps Script training course give you a detailed knowledge on coding like Automating data calculation, Fetching and sending data from third party software like Trello & Salesforce, connecting different sheets, Documents and other tools, Setting a trigger based on an event. This course is ideal for someone who use google sheets and have no coding background.
Course Objectives:
- Know Handling Spreadsheet and Loop
- Understand IF Statement and Array
- Using Commonly used Functions in Spreadsheet
- Understand usage of Menus, Dialogs and Sidebars, User Interfaces, Add-Ons
- Store and Serve Data
- Know about Triggers & Events and Sending email with details from Google Form
Pre-requisites:
- Fundamental knowledge of Google Spreadsheet
- Basic Experience with coding will be helpful but not mandatory
Course Duration:
- 35 hours – 5 days
Course Content:
- Introduction
- Introduction
- script Editor: Where codes are written
- Writing the first line of code
- Good Practices for writing Codes
- Handling Spreadsheet and for Loop o Accessing an outside spreadsheet
- What can we do with the Spreadsheets?
- Introduction to for Loop
- More on for Loop
- IF Statement and Array
- IF Statements o Array of Variables
- Combining Array and for Loop
- Commonly used Functions in Spreadsheet
- Get Last Row of Spreadsheet
- Copy to: Copying from one cell to another
- Change Name, Hide and Show Sheets
- Customized Menu
- Pop Up Dialogue Box
- Menus, Dialogs and Sidebars
- Custom Menus
- Dialogs / Sidebars
- User Interfaces o Create and Serve HTML
- Client-to-Server Communication
- Template HTML o Restrictions
- Migration to IFRAME
- Add-Ons o Translate for Google Docs
- Notification for Google Forms
- Translate for Google Slides
- Progress bars for Google Slides
- Store and Serve Data
- Script/user/Document Properties
- External Databases via JDBC
- Content Service
- Live Project: Send email with details of Google Form
Course Customization Options
To request a customized training for this course, please contact us to arrange.