Video Training / Learning Office Tutorials →Spreadsheet Automation 101

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!
Requirements
No programming experience needed, but a strong desire to code is preferred.
While you don't need extensive Google Sheet experience, if you consider yourself "intermediate" then this will help you get to "Advanced Google Sheet User"
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 outcomesLearn to automate Google Sheets, so your sheets perform like web appsLearn 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.
https://www.udemy.com/course/spreadsheet-automation-101/