Computer Tutoring Logo
Est. 2002
Menu Button

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

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

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 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

Intermediate Google Apps Script Prices from:

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

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

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

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