Computer Tutoring Logo
Est. 2002
Menu Button

Live Online Prices

1-8 Students

£250 + VAT - 3hrs (bespoke)

£500 + VAT - 6hrs (full day*)

* Full training days can be split into 2 sessions

Classroom Course Calculator

Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live Online Classroom
First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive training special offer emails
I would like to be notified about free software hints and tips

Google Apps Script Training Intermediate

Google Apps Script Training Overview

Google sheets has built within it the Google Apps Script or (GAS). If you are used to the VBA in Excel it can be a little baptism of fire moving across to Google Apps Script.

This course will help you migrate with ease from Excel VBA to Google Apps Script.

Course Duration: 1 Day

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

Live Online Instructor Led Training

1 - 8 Students

£250 + VAT - 3hrs (bespoke)

£500 + VAT - 6hrs (full day*)

* Full training days can be split into 2 sessions


Classroom based Intermediate Google Apps Script Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the the following form to calculate how much.

Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

Live Online Classroom
First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

I would like to receive training special offer emails
I would like to be notified about free software hints and tips





Google Apps Script Training Intermediate