Take your analysis skills and career to the next level with Apps Script.
Be in high demand with clients. Get your pick of projects. Build fantastic Google Sheets-based applications that are impossible with formulas or add-ons alone.
Learn to do Automation with Apps Script in this premium, online video training course.
Save time at work. Automate the tedious tasks.
Connect Google Sheets to external web services to import your own data.
Take your career to the next level.
This course is for you if you answer YES to any of the following questions:
Hi! I’m an experienced data analytics instructor and freelance spreadsheet developer.
I help individuals and businesses better understand their data through analytical insights and visualizations.
Over 20,000 professionals from 1,000+ companies have enrolled in my training courses, including employees from PwC, Netflix, Verizon, Google, Capital One and other Fortune 500 companies.
My training has helped 1,000’s of people advance their careers. I’ve also helped small and large organizations migrate from Microsoft Excel and Office to Google Sheets and G Suite.
Google recognized me as a Google Developer Expert for G Suite Technology in 2019, one of only a handful worldwide.
I work primarily with Google Sheets and Apps Script, and also have extensive experience with Google Data Studio, Microsoft Excel, SQL and Tableau. I’ve previously taught data courses and workshops for General Assembly in Washington, D.C..
Once you know a little bit of Apps Script, you can immediately start to build useful tools.
The cool tools I was building was the main reason I was able to stick with learning Apps Script when I hit the inevitable hurdles.
It’s really motivating to see early wins when you’re learning a new subject. Especially when you’re learning something that’s technical and potentially challenging.
If you use Gmail, Google Sheets, Docs, or other G Suite apps, then you’re already familiar with the look and feel of Google tools. Apps Script is no different and seamlessly extends the possibilities of what you can do with G Suite tools.
It’s very, very easy to get started. There’s no risk of you getting lost in the terminal installing packages or configuring programs.
There are only three steps to get started: 1) Open your browser, 2) Create a new Apps Script project, and 3) Start coding!
An introduction to the course and notes to help you get the most from the course.
Fundamental topics within Apps Script, including an overview of the documentation, Variables, Functions, Objects, script performance and much more!
This module focuses on working with data in Google Sheets, covering everything from copying data to another Sheet to setting schedules to run your scripts.
How to automate the tedious task of importing CSV data from individual files, from folders of files or from email attachments.
Build a time saving tool that automatically creates draft Gmail replies to survey responses from a Google Form.
Connect Google Sheets to Google Calendar and use Apps Script to transfer data and create calendar events.
An introduction to APIs and how to retrieve data from third-party web services and transfer into Google Sheets, including an example using a NASA API!
An API case study using publicly available College data, including how to deal with paginated data.
An API case study using the MailChimp API, showing how to do basic authentication with API Key in the headers.
An API case study using the PayPal API, showing how to connect using the OAuth 2 authentication protocol.
An API case study using the Facebook API, showing how to connect using the OAuth 2 authentication protocol and Google’s OAuth 2 Apps Script library.
Build a tool to save time by automatically generating pre-filled documents, for example when you onboard new clients or employees or students.
You should be familiar with Google Sheets and have had at least some prior exposure to Apps Script, for example through Macros or custom functions.
(Note: If you’re brand new to Apps Script then I recommend that you also sign up for the free Apps Script Blastoff course, and work through that one first.)
There are no reviews yet.
You must be <a href="https://wislibrary.net/my-account/">logged in</a> to post a review.