Courses > Learn to Code in Google Sheets | Intro To Scripting

13 Tutorials

Learn how to create automations inside of Google Sheets. Better productivity of day to day tasks.

Are you ready to unlock the full potential of Google Sheets and become a wizard in the world of spreadsheets? Enroll in our "Learn to Code in Google Sheets" course and gain the skills and knowledge you need to master Google Apps Scripts.

"Learn to Code in Google Sheets" is an introductory course that will teach you how to use Google Apps Scripts to automate business tasks and unlock the full potential of Google Sheets. In this course, you will learn the fundamentals of coding and how it applies to Google Sheets, and you will have the opportunity to write and run your own programs using Google Apps Scripts. By the end of the course, you will be able to automate common business tasks using Google Sheets, such as data entry, data manipulation, and reporting.

Additionally, you will gain the skills to troubleshoot and debug common coding issues, and you will be able to create custom functions and macros in Google Sheets to streamline your workflows and improve your efficiency. This course is perfect for business professionals, students, educators, data analysts, researchers, entrepreneurs, and anyone who wants to learn how to use Google Sheets to its full potential. Join us and discover the power of coding in Google Sheets!

By the end of the course, you'll be a certified Google Sheets wizard, ready to take on any challenge that comes your way. Sign up now and join our wizarding community of Google Sheets enthusiasts!

13Tutorials

welcome to part one of Learn to Code in Google Sheets. In this video, we're gonna get started to code.
Find out how I use Apps Script built in features to code very quickly and efficiently. 
Continuing to show you how to write a function in Apps Script.
In this video, I'm going to share with you how to go basically from sheet to script and then back to the sheet again.
Learn to code in sheets. Automate Your Daily Sales Report with Google Sheets: Learn how to create a script that copies data from one sheet to another, including timestamps. Boost your productivity with this easy guide!
Now that we have a script that we wanna run every day, how do we run this? This is a key part of programming. It's like Cron Jobs in Apps Script
this completes learn to code in Google Sheets and I wanted to finish off by giving you a few more quick concepts that expands your mind of what Google Sheets can do.
I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.
Record a macro, to Insert a column every day.
Editing macros in Google Sheets helps you do more in less time.
Automate your apps script and macros you can record.
Create an automatic unchecker for a daily checklist. Fun way to learn Apps Script and simple Google Sheets automation.
I'll show you how to get text from one spreadsheet file to another with Apps Script. Yes you can do this by Importrange() but you might want another way to do it.