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

Next

"Simon was absolutely brilliant in his Power BI training, demonstrating an incredible depth of knowledge and making even the most complex concepts feel easy to understand"

Leicestershire Police

"Really informative ! The trainer was patient and knowledgeable and was able to answer all the questions we had. Going over things we have covered again if required .I really enjoyed the session"

Office Principles North

"Gary covered all of the subjects that I wanted to learn more about, plus alot of other random things that I just needed to be reminded of or that I didn't know about. It has made me feel much more confident about my job in the office so feel it was very much worth doing today. I have very much enjoyed the course- Gary made me feel comfortable and I found him to be approachable. Thankyou."

Next

"It was very informative session. All the topics have been covered that is required for you to jump on the power bi for the first time. Crystal clear explanation with real time examples"

Google Apps Script Training - Intermediate Training in Leicester

Leicester Intermediate Google Apps Script Overview

Google Apps Script Training Intermediate training in Leicester

Leicester is a well-placed Midlands location for businesses looking for practical, instructor-led Google Apps Script Training training.

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

1st Floor, Gateway House
Grove Business Park
Enderby
Leicester
LE19 1SY
United Kingdom

The Grove Park venue is easy to reach and provides a professional setting for focused training. That is especially useful for teams looking to automate repetitive tasks and improve consistency across shared systems.

If you are also considering other options, you can browse our computer training courses in Leicester.


Google Apps Script Training training for Leicester teams

We can deliver Google Apps Script Training Intermediate training for organisations in Leicester and nearby areas such as Enderby, Loughborough, Hinckley, Market Harborough, Melton Mowbray and Nottingham. 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 Leicester venue at Gateway House, Grove Business Park in Enderby, provides a professional setting for focused training and is convenient for teams travelling from around Leicestershire.

Local training use cases

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

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

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 Leicester

Where can this training take place in Leicester?

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

Can you come to our office in Leicester?

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

IT skills training centres near Leicester

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