Google Apps Script Training Intermediate Oxford

Oxford Intermediate Google Apps Script Overview

Intermediate Google Apps Script Training training course in Oxford - Radcliffe Camera

The university town of Oxford. They say that people go to Cambridge to study science, and Oxford to study politics. Whatever the reason, Oxford a fantastic place to conduct your Intermediate Google Apps Script Training training course.

Other training courses in Oxford.

Oxford, the City of Dreaming Spires, is famous for its prestigious university and beautiful architecture.

Course Duration: 1 Day

Course Prerequisites for your training in Oxford

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