Google Apps Script Training Intermediate Cambridge

Cambridge Intermediate Google Apps Script Overview

Google Apps Script Training Intermediate Kings College chapel Cambridge

The science park to St. John's Innovation centre. The university city of Cambridge is a regular training venue. We've trained various companies in and around Cambridge as far out as Cambourne, Newmarket, Huntingdon and St. Ives. A Intermediate Google Apps Script Training at the offices we use at the Regus in Cambourne is easy to set up and conduct even at short notice. Or maybe you just want us to come to you bringing a projector, laptops with Google Apps Script preloaded along with fully comprehensive course notes.

Cambridge is renowned for its prestigious university and stunning architecture.

Cambridge was actually the first area we started training. From Cambridge Consultants on the science park to ARU, CRC (Cambridge Regional College) and many more have taken advantage of the computer training courses conducted by us.

Course Duration: 1 Day

Course Prerequisites for your training in Cambridge

This intermediate-level course is ideal if you've already dabbled in Apps Script or similar tools. Before joining, we recommend the following:

Experience using Google Sheets, including formulas and basic spreadsheet tasks
Some familiarity with Google Apps Script or JavaScript concepts, no need to be an expert, but you should be comfortable looking at simple code
Previous use of custom functions or basic automation in Google Sheets is helpful but not essential

Complete Course Outline

Introduction to Google Apps Scripting

What is Google Apps Scripting
JavaScript or Google Apps Script
Google spreadsheet limitations

Viewing the Code

Google Apps Script - examples
Executing the code

User Defined Functions

Built-in functions and user defined functions
Why write user-defined functions?
Using user-defined functions
Introducing JavaScript functions
User-defined functions and JavaScript functions
Error checking

Calculations

Numeric calculations
Date functions
Text functions
Using JavaScript library methods
Function callbacks
Getting information about the spreadsheet

Programming Constructs

Variables and data types
Conditional logic using IF and SWITCH
Looping statements (do | while | for)

Excel VBA and Google Apps Script Comparison

Boilerplate code
Worksheets
Protect sheets
Ranges
Selection
UsedRange / getDataRange()
Colours
Can I still use Offset?
Other VBA / GAS comparisons

Other Related Courses

Google Sheets Beginners Training Course

Google Sheets Intermediate Training Course

Google Apps Script Beginners Training Course

Post-Course Resources

Training notes & exercise files
Online materials: video tutorials & shortcuts
3 months post training support