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

The TBA

"Just finished my training with Simon and couldn't be more delighted with how it went - it exceeded all my expectations. It's a daunting subject but from the moment the training began, Simon put me at ease and just made everything to easy to understand. He's obviously well versed on the software and so keen to pass on his knowledge and experience. He was patient and understanding if I ever got lost and was kind enough to share some ideas on how I could make Power BI work for us. I can wholeheartedly recommend Simon and Computer Tutoring to anyone looking to master Power BI - If you have the opportunity to learn from him, seize it - you won't be disappointed! I'm off to put my new found skills and knowledge to the test! "

BBI Services

"Great day of training. Loved how interactive it was and lots of time to test and try things ourselves. Simon was really thorough and clear in his instructions and was easy to follow. Learnt lots from the days session"

AEA

"I had previously finished a similar course and felt that I hadn't learnt enough from it, this course however was perfect and I now feel much more confident to work on Power BI. The course was run extremely well via Zoom with details being given if we asked for in depth on certain areas but usually the trainer explained everything so clearly there was little need for more questions. I am looking forward to the next level of training on it now as well."

Morgan Sindall

"Thoroughly enjoyed the training course, great friendly instructor Simon. Taught me a lot I didn't know. Many Thanks"

Google Apps Script Training - Intermediate Training in Peterborough

Peterborough Intermediate Google Apps Script Overview

Google Apps Script Training Intermediate training in Peterborough

Peterborough is a practical location for businesses that want focused, instructor-led Google Apps Script Training training with straightforward access from across the surrounding area.

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

Stuart House - East Wing
St John's Street
Peterborough PE1 5DD
United Kingdom

The venue is close to transport links and central amenities, which makes it a convenient setting for training. That is especially useful for teams looking to automate repetitive tasks and improve consistency across shared systems.

If you are also looking at other options, take a look at our training courses in Peterborough.


Google Apps Script Training training for Peterborough teams

We can deliver Google Apps Script Training Intermediate training for organisations in Peterborough and nearby areas such as Stamford, Spalding, Huntingdon, Wisbech, March and Cambridgeshire. 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 Peterborough venue at Stuart House on St John's Street is close to central amenities and transport links, making it a convenient option for focused training days.

Local training use cases

Google Apps Script Training training in Peterborough 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.

Peterborough is a strong setting for Google Apps Script Training Intermediate training. The venue is well suited to automation-focused Google training, where delegates can work through practical scripting examples and process-based workflows. 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 Peterborough

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 Peterborough

Where can this training take place in Peterborough?

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

Can you come to our office in Peterborough?

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

IT skills training centres near Peterborough

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