Enrolment options
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
15
•
Activities:
0
•
Resources:
65
- 001-Important Information
- 002-Writing the first line of code
- 003-Introduction
- 004-script Editor Where codes are written
- 005-Good Practices for writing Codes-
- 007-Accessing an outside spreadsheet
- 008-What can we do with the Spreadsheets
- 009-Introduction to for Loop
- 010-More on For Loop
- 011-IF Statements
- 012-Array of Variables
- 013-Combining Array and For Loop
- 014-Get Last Row of Spreadsheet
- 015-CopyTo Copying from one cell to another
- 016-Change Name Hide and Show Sheets
- 017-Customized Menu
- 018-Pop Up Dialogue Box
- 019-Creating Google Form
- 020-Setting up For Loop
- 021-Writing code for Loop
- 022-Automatically trigger the code
- 023-Introduction
- 024-What is Google Apps Script and how code runs
- 025-Clarification on Authentication
- 026-Read Data from Google Sheet
- 027-Write data to Google Sheet-
- 028-More action with Google Sheet
- 029-What is an Array
- 030-Read and Write Array in Google Sheet
- 031-Functions associated with Array
- 032-IF statements
- 033-FOR Loop
- 034-WHILE Loop
- 035-Project 1 Combining Data from Individual Sheets
- 036-Project 2 Combining Multiple Rows of Data
- 037-Project 3 Combining Data from Different Google Spreadsheets
- 038-Read Email from Inbox
- 039-More action on Inbox
- 040-Send Email via Apps Script
- 041-Read Events from Google Calendar
- 042-Write or Update Events in Google Calendar
- 043-Read and Write to a Google Doc
- 044-Read from Google Slide
- 045-Write to Google Slide
- 046-Get Files and Folders
- 047-Create PDF
- 048-UI Alert and Prompt
- 049-Project 4 Get Item from Orders
- 050-Project 5 Salary Report History
- 051-Project 6 Attendance Sheet
- 052-Project 7 Merge Assemblies
- 053-Project 8 Pingpong Winning Streak
- 054-Project 8 Annexure
- 055-Project 9 Compare Data
- 056-Project 10 Managing Vendors Quotations
- 057-Project 11 Invoice Management
- 058-Project 12 Client onboarding
- 059-Project 13 Send Certificate from Sheet
- 060-Project 14 Send Certificate using Google Doc
- 061-Project 15 Create Real Estate Documents
- 062-Project 16 Scrap Gmail Data
- 063-Project 17 Store all Gmail Attachment in Google Drive
- 064-Project 18 Create Profile Card in Google Slides and save as PDF
- 065-Project 19 Slot Booking System
- 066-Project 20 Creating Personal Library of Images and PDF