Course Content
01 – Introduction
0/5
001 Important Information.mp4
01:26
002 Writing the first line of code.mp4
07:34
003 Introduction.mp4
02:30
004 script Editor Where codes are written.mp4
02:41
005 Good Practices for writing Codes.mp4
09:32
02 – Handling Spreadsheet and For Loop
0/4
001 Accessing an outside spreadsheet.mp4
07:24
002 What can we do with the Spreadsheets.mp4
05:41
003 Introduction to for Loop.mp4
09:25
004 More on For Loop.mp4
09:12
03 – IF Statement and Array
0/3
001 IF Statements.mp4
11:35
002 Array of Variables.mp4
17:00
003 Combining Array and For Loop.mp4
08:23
04 – Commonly used Functions in Spreadsheet
0/5
001 Get Last Row of Spreadsheet.mp4
04:35
002 CopyTo Copying from one cell to another.mp4
05:02
003 Change Name, Hide and Show Sheets.mp4
02:45
004 Customized Menu.mp4
05:59
005 Pop Up Dialogue Box.mp4
10:05
05 – Live Project 1 Send email with details of Google Form
0/4
001 Creating Google Form.mp4
05:29
002 Setting up For Loop.mp4
07:00
003 Writing code for Loop.mp4
13:17
004 Automatically trigger the code.mp4
04:17
06 – NEW COURSE Introduction
0/2
001 Introduction.mp4
01:45
002 What is Google Apps Script and how code runs.mp4
17:38
07 – NEW COURSE Interacting with Google Sheets
0/4
001 Clarification on Authentication.mp4
01:22
002 Read Data from Google Sheet.mp4
24:03
003 Write data to Google Sheet.mp4
19:32
004 More action with Google Sheet.mp4
19:18
08 – NEW COURSE ARRAY
0/3
001 What is an Array.mp4
20:48
002 Read and Write Array in Google Sheet.mp4
10:29
003 Functions associated with Array.mp4
23:00
09 – NEW COURSE Conditional Executions (IF) and Loops
0/3
001 IF statements.mp4
13:37
002 FOR Loop.mp4
16:17
003 WHILE Loop.mp4
06:14
10 – NEW COURSE Basic Projects
0/3
001 Project 1 Combining Data from Individual Sheets.mp4
18:38
002 Project 2 Combining Multiple Rows of Data.mp4
24:15
003 Project 3 Combining Data from Different Google Spreadsheets.mp4
21:08
11 – NEW COURSE GMAIL APP
0/3
001 Read Email from Inbox.mp4
19:04
002 More action on Inbox.mp4
31:59
003 Send Email via Apps Script.mp4
16:24
12 – NEW COURSE CALENDAR APP
0/2
001 Read Events from Google Calendar.mp4
17:05
002 Write or Update Events in Google Calendar.mp4
36:33
13 – DOCUMENT APP & SLIDE APP
0/3
001 Read and Write to a Google Doc.mp4
11:06
002 Read from Google Slide.mp4
14:05
003 Write to Google Slide.mp4
08:22
14 – NEW COURSE Interact with Google Drive and UI Elements
0/3
001 Get Files and Folders.mp4
23:27
002 Create PDF.mp4
16:28
003 UI Alert and Prompt.mp4
18:09
15 – NEW COURSE Projects
0/18
010 Project 12 Client onboarding.mp4
33:28
018 Project 20 Creating Personal Library of Images and PDF.mp4
16:13
017 Project 19 Slot Booking System.mp4
22:51
016 Project 18 Create Profile Card in Google Slides and save as PDF.mp4
28:15
015 Project 17 Store all Gmail Attachment in Google Drive.mp4
20:18
014 Project 16 Scrap Gmail Data.mp4
21:00
013 Project 15 Create Real Estate Documents.mp4
44:04
012 Project 14 Send Certificate using Google Doc.mp4
18:55
011 Project 13 Send Certificate from Sheet.mp4
20:49
001 Project 4 Get Item from Orders.mp4
34:04
009 Project 11 Invoice Management.mp4
27:15
008 Project 10 Managing Vendors & Quotations.mp4
42:10
007 Project 9 Compare Data.mp4
18:24
006 Project 8 Annexure.mp4
02:23
005 Project 8 Pingpong Winning Streak.mp4
33:26
004 Project 7 Merge Assemblies.mp4
17:03
003 Project 6 Attendance Sheet.mp4
14:55
002 Project 5 Salary Report & History.mp4
17:12
[Last updated 3/2023] Google Apps Script: From Level Zero with 20 Projects (2023) (Udemy – Engsub)
Previous
Next
0% Complete