Spreadsheet Automation 101

Focused View

Andrew Kamphey

2:53:27

103 View

1. Pre-Course Material

1. Introduction.mp4

03:00

2. Functions.mp4

04:59

3. Variables.mp4

05:04

4. Dot Notation.mp4

02:20

5. Camel Case.mp4

04:26

6. Parentheses.mp4

05:22

2. GetValue

1. GetValue - Introduction to SpreadsheetApp.mp4

05:22

2. Spreadsheet Taxonomy.mp4

05:06

3. A1 Notation vs Row,Column Syntax.mp4

05:45

4. getActiveSpreadsheet() vs getActiveSheet().mp4

04:19

5. Trigger onOpen() - Custom Menu.mp4

07:26

3. GetValues

1. Get Values Introduction.mp4

02:40

2. Arrays.mp4

06:27

3. For Loop.mp4

05:05

4. Bracket Notation.mp4

13:42

5. Logger.log().mp4

05:18

6. If ( ){ } and Checkboxes.mp4

09:50

7. Trigger onEdit().mp4

08:38

4. Email Yourself

1. Email Yourself Introduction.mp4

01:47

2. MailApp.mp4

03:43

3. Email Yourself For Loop.mp4

05:54

4. Send Email Every Week Trigger.mp4

04:44

5. Email Other People For Loop.mp4

05:16

5. Access APIs

1. Access APIs Introduction.mp4

01:56

2. UrlFetchApp.mp4

02:54

3. OmdbAPI get ApiKey, get Data in URL.mp4

04:46

4. OmdbAPI get data in Apps Script.mp4

04:21

5. JSON (beautifier) and OmdbAPI parameters.mp4

03:49

6. OmdbAPI Parameter Picker.mp4

03:34

6. Bonus Videos

1. Coding is Complex, How can I learn Apps Script better.mp4

25:54

Description

Transform your Google Sheets skills with the power of code - and automate your business tasks like a pro!

What You'll Learn?

Learn to automate Google Sheets, so your sheets perform like web apps
You'll learn how to write, read, and use Google Apps Script, faster
Automate anything, so that your sheets work while you sleep
Learn what Google Sheets can't do, so you don't waste time!

Who is this for?

Google Sheet Nerds who want to take their Google Sheets skills to the next level.

Managers who want to automate their team updates, and keep on top of projects better.

Startup Founders who want to build an MVP organization that will last through the first five years of their newest venture.

Small business owners who want to keep on top of their metrics.

More details

Description
Too much of your time is spent in spreadsheet hell. Learning, researching, functions and formulas can feel like a lonely job.
Learn to build magical & effective sheets by learning how to automate with Apps Script -- saving you thousands of dollars, hours, and therapy sessions.
Key outcomes

Learn to automate Google Sheets, so your sheets perform like web apps
Learn to automate almost anything, from data analysis to email notification. You can make Google Sheets do your bidding, even while you sleep. I call this Advanced Sorcery.

You'll learn how to write, read, and use Google Apps Script, faster.
You'll learn how to write actual code in Google Apps Script. Also learn how to read code and do more, faster. We use practical, every day uses of code to learn how it can be used most effectively. I've used code for more than 8 years.

Automate anything, so that your sheets work while you sleep.
I'll show you all the triggers possible for your Apps Script. Trigger scripts to run while you sleep. Trigger email sequences. Trigger reports. Trigger nearly anything.

Learn what Google Sheets can't do, so you don't waste time!
I've lived to tell the tale. I've broken Google Sheets and run up against its limits. Find out what's actually impossible to do in Google Sheets. You can learn to overcome some of these limits.
Who this course is for:
Google Sheet Nerds who want to take their Google Sheets skills to the next level.
Managers who want to automate their team updates, and keep on top of projects better.
Startup Founders who want to build an MVP organization that will last through the first five years of their newest venture.
Small business owners who want to keep on top of their metrics.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Andrew Kamphey

Instructor's Courses

As a Resident Google Sheets Wizard at Better Sheets. Andrew Kamphey's primary focus is on teaching tutorials and building tools with Google Sheets. In his role, he provides guidance and expertise to help individuals and businesses make the most of this powerful spreadsheet program. He is skilled in using Google Sheets to create complex formulas, automate tasks, and integrate with other Google apps and services. Andrew regularly creates and shares resources such as video tutorials and blog posts to help others learn how to use Google Sheets more effectively. By leveraging his deep knowledge of the program, Andrew helps people unlock the full potential of Google Sheets and achieve their goals.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.