Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live online Face to face
First name:

Last name:

Email:

Tel:

Location:

Number of students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Locations outside Heathrow

Google Apps Script Training Intermediate Heathrow

Heathrow Intermediate Google Apps Script Overview

Google Apps Script Training Intermediate training Heathrow

Situated near one of the world’s busiest airports, Heathrow connects travelers to a global network of destinations.

London - (Heathrow)
450 Bath Road
Longford
Heathrow
London, UB7 0EB

In your busy life the convenience of a Google Apps Script Training Intermediate training course near Heathrow airport could be the ideal solution.

The Google Apps Script Training Intermediate course in the 3 storey Heathrow Airport training centre is five minutes from Heathrow's Terminal 5. Set in secluded grounds, the building has an impressive high-ceilinged reception and there are views of the planes taking off and landing from some offices. Close by car from Terminal 5, there is also easy access to the London Underground, Heathrow Express and the M25 and M4 motorways. It is a short drive to cafes, restaurants, bars and shopping in West Drayton.

If a Intermediate Google Apps Script training course isn't what you need. Then please take the time to look at other computer training courses in Heathrow.


Course Duration: 1 Day

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 training courses:

Google Sheets Beginners Training Course

Google Sheets Intermediate Training Course



At Computer Tutoring, we prioritise your privacy and only collect the necessary information to provide our services. We will only share the personal data you provide in a form if you have opted in for those services. Our website also uses Google Analytics. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.

For more details, please read our full Privacy Policy.