Computer Tutoring Logo

Cost Calculator

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

Course price: £ *
Price per head:
£ .

Duration:
1 Days

* Price is exclusive of VAT.

Tell Me More






First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.

Training feedback from Milton Keynes learners

Network Rail

"Great introduction into Power Apps. Simon was flexible with the course and was able to go into detail regarding the specific learning needed"

Macintyre Hudson

The training was delivered very clearly and with a good level of detail. The trainer was very enthusiastic and knowledgeable, which kept everyone interested in the course. He also ensured any questions were answered fully

Aquaterra Energy

This was a great training course and one I enjoyed. Kevin was very clear on the training provided and explained all the steps very clearly. Ginny & I had slightly different requirements and these were meet without any problems. His interaction with us both help to allow us to get first hand practice and when stumbling was very quick to show us what was wrong. Enjoyed this course with Kevin I was also asking on other training, such as the Excel course.

Network Rail

Live Online Excel Power BI "A very well delivered course. The trainer was very knowledgeable and was aware of the different levels of understanding. The pace was quick enough to deliver the course material and slow enough for everyone to keep up. Very informative course."

Google Apps Script Training - Intermediate Training in Milton Keynes

Milton Keynes Intermediate Google Apps Script Overview

Google Apps Script Training Intermediate training in Milton Keynes

Milton Keynes is a strong business location and a practical place to run Google Apps Script Training training for teams travelling from different parts of the country.

The venue is well suited to automation-focused Google training, where delegates can work through practical scripting examples and process-based workflows.

Fairbourne Drive
Atterbury
Milton Keynes
MK10 9RG
United Kingdom

The Atterbury Lakes venue provides a professional setting with good access from the motorway network. That is especially useful for teams looking to automate repetitive tasks and improve consistency across shared systems.

If you are reviewing other options, you can also explore our computer training courses in Milton Keynes.


Google Apps Script Training training for Milton Keynes teams

We can deliver Google Apps Script Training Intermediate training for organisations in Milton Keynes and nearby areas such as Bletchley, Newport Pagnell, Buckingham, Bedford, Northampton and Aylesbury. Sessions can be run live online, at your premises, or at a local training venue where that suits your team better.

Access and venue details

The Milton Keynes venue at Atterbury Lakes, Fairbourne Drive, is useful for teams travelling by road and gives delegates a focused setting away from day-to-day work.

Local training use cases

Google Apps Script Training training in Milton Keynes is useful for teams who want skills they can apply quickly in real work. The venue is well suited to automation-focused Google training, where delegates can work through practical scripting examples and process-based workflows. That is especially useful for teams looking to automate repetitive tasks and improve consistency across shared systems. It suits learners who want practical workflow automation skills using Google tools.

If you need Google Apps Script training in Milton Keynes at intermediate level, this page gives you a location-specific overview of the course. That is especially useful for teams looking to automate repetitive tasks and improve consistency across shared systems. It suits learners who want practical workflow automation skills using Google tools.

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 Days

Course Prerequisites for your training in Milton Keynes

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

Location FAQs for Milton Keynes

Where can this training take place in Milton Keynes?

We can deliver this Google Apps Script training at your premises in or around Milton Keynes, live online, or at a suitable local training venue if you would prefer an external location.

Can you come to our office in Milton Keynes?

Yes. We regularly deliver on-site training for teams in Milton Keynes and can usually tailor the session to your team, your documents and the way you work.

IT skills training centres near Milton Keynes

If Milton Keynes is not the most convenient option, we can also arrange instructor-led IT skills training at nearby Computer Tutoring training centres.