Google Apps Script Training Intermediate Luton

Luton Intermediate Google Apps Script Overview

Computer Tutoring has been training companies in and around Luton for a little while now. Admiral Group, Thomson, Easyjet, Europa Components, GKN Aerospace and more.

We can come to you with all the equipment necessary to conduct the training course at your premises.

Using offices in Capability green makes it possible for you to get out of the office and learn free from distractions.

960 Capability Green
Luton
LU1 3PE
United Kingdom

Luton Capability Green is ideally situated at the end of a boulevard on the Capability Business Park. Located approximately 30 miles from central London, the Centre offers easy access to the M1 motorway and London Luton Airport. An ideal spot for your Intermediate Google Apps Script Training.

Alternatively if you live in and around Luton and wish to have your training on-site the we can provide all the equipment, included laptops and projector, required. All we ask is that you provide a little space for the trainer to set up.

Luton is known for its diverse community and vibrant annual carnival.

Course Duration: 1 Day

Course Prerequisites for your training in Luton

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