Watch trailer
Course at a glance
Included in these subscriptions:
- Dev & IT Pro Video
- Dev & IT Pro Power Pack
| Release date | 11/30/2021 | |
| Level | Beginner | |
| Runtime | 3h 7m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
Course description
Learn Google App Script from top to bottom to interact with Google Services. This course covers: Google speadsheets, UI, rows, cols, selecting and ranges to master using Script with sheets.
Prerequisites
HTML, CSS, JavaScript are strongly recommended
Some programming Background
Understanding of web technologies and how websites work
Google Account
Meet the expert
Providing Web development courses and digital marketing strategy courses since 2002. An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications. Web & application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about ;everything to do with web application development, programming to online marketing with a strong focus on social media and SEO.
Course outline
Module 2
Introduction Sheets (25:46)
- Introduction (00:08)
- Google Sheets (02:43)
- Macros in Spreadsheets (08:22)
- Introduction Class SpreadsheetApp (06:57)
- Spreadsheet Sheets (07:27)
- Summary (00:08)
Sheets and Spreadsheet Selection (31:10)
- Introduction (00:08)
- Sheets and Spreadsheet Selection (07:21)
- More Ways to Select a Sheet (07:57)
- Create New Sheet (04:44)
- Interact With Sheets (04:34)
- Range Selection (06:15)
- Summary (00:08)
Selecting Range From Sheets (23:14)
- Introduction (00:08)
- Selecting Range From Sheets (08:40)
- Set Values to Rows (08:08)
- Debugging Dashboard Options (06:09)
- Summary (00:08)
Module 3
Sheet Data Cols and Rows (31:53)
- Introduction (00:08)
- Sheet Data Cols and Rows (04:24)
- Full-Sheet Ranges (06:00)
- Active Sheet and Selections (05:22)
- Active Range (05:06)
- Copy Values Into New Sheet (10:42)
- Summary (00:08)
Spreadsheet UI (28:09)
- Introduction (00:08)
- Spreadsheet UI (06:19)
- Custom Logger into Sheet (10:36)
- Spreadsheet UI Alerts and Prompts (05:09)
- Prompts (05:48)
- Summary (00:08)
Module 4
Spreadsheet UI Modal Dialog (25:53)
- Introduction (00:08)
- Spreadsheet UI Modal Dialog (04:51)
- Template Files (04:32)
- Show Sidebar HTML Code (07:03)
- AppendRow Adding Rows to Sheet (09:10)
- Summary (00:08)
Prepend Row Exercise (21:27)
- Introduction (00:08)
- Prepend Row Exercise (06:58)
- Cell Formulas and Custom Functions (05:59)
- Cell Notes and Comments (05:08)
- Spreadsheet App Overview (03:04)
- Summary (00:08)