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"

Automating Google Sheets with Google Apps Script - Beginners Training in Peterborough

Peterborough Beginners Automating Google Sheets with Google Apps Script Overview

Automating Google Sheets with Google Apps Script Beginners training in Peterborough

Peterborough is a practical location for businesses that want focused, instructor-led Automating Google Sheets with Google Apps Script 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.


Automating Google Sheets with Google Apps Script training for Peterborough teams

We can deliver Automating Google Sheets with Google Apps Script Beginners 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

Automating Google Sheets with Google Apps Script 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 Automating Google Sheets with Google Apps Script Beginners 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.

Looking to automate repetitive tasks and boost your productivity in Google Sheets? This practical and supportive course on Google Apps Script will show you how to harness the power of scripting to build custom formulas, streamline workflows, and connect Google Sheets with other Google Workspace tools.

Whether you're new to coding or transitioning from Excel VBA, you'll learn how to reduce manual work, simplify complex tasks, and take full control of your spreadsheets. Join us and unlock the true potential of Google Sheets automation.

This step-by-step course starts with the basics of Google Apps Script, guiding you through the transition from VBA and helping you understand how Apps Script integrates seamlessly with Google Workspace. Through hands-on exercises, you'll learn how to write scripts that automate data processing, create dynamic ranges, and build custom functions tailored to your needs.

With a focus on real-world scenarios, you'll explore how to use triggers, debug your code, and even build your own interactive Google Sheets add-ons. By the end of the course, you'll have the skills to automate everyday tasks and develop powerful solutions that save you time and increase efficiency.

What You'll Learn in this Training Course

  • Understand the basics of Google Apps Script and how it differs from VBA
  • Automate repetitive tasks in Google Sheets using scripts and triggers
  • Write custom formulas and create dynamic workflows
  • Debug and handle errors to keep scripts running smoothly
  • Build and integrate Google Sheets add-ons with other Workspace services
  • Work on practical projects like automating data imports and creating custom tools

Course Duration: 1 Days

Course Prerequisites for your training in Peterborough

To benefit from this course, you should have:

  • Basic knowledge of Google Sheets
  • Familiarity with spreadsheet formulas and functions
  • Willingness to learn coding concepts (no prior coding experience required)
  • Access to a Google Workspace account with Google Sheets
  • Basic understanding of JavaScript is helpful but not mandatory

Complete Course Outline

Introduction to Google Sheets Apps Script

  • Introduction to VBA and extending it to Google Apps Script
  • Enhancing workflows with Google Apps Script
  • Key differences between Excel VBA and Google Apps Script
  • Common use cases for automating Google Sheets with Apps Script

Transitioning from VBA to Google Apps Script

  • Introduction to JavaScript and its role in Apps Script
  • What is Google Apps Script?
  • Key features of Apps Script for users familiar with VBA
  • Accessing and automating Google Sheets via Apps Script
  • Handling quotas, limits, and asynchronicity in Apps Script
  • Comparison between VBA and Apps Script functionality

Automating Google Sheets with Apps Script

  • Running basic scripts to manipulate Google Sheets data
  • Using triggers and events to automate repetitive tasks
  • Writing data across multiple Google Sheets from a script
  • Creating custom menus and extending Google Sheets functionality
  • Example: Automating data imports and exports in Google Sheets

Debugging and Error Handling in Google Apps Script

  • Using the Apps Script debugger
  • Handling errors with try-catch blocks
  • Example: Implementing error handling in a Google Sheets script

Dynamic Ranges and Formulas in Google Sheets

  • Creating dynamic ranges in Google Sheets using Apps Script
  • Writing custom formulas with Apps Script
  • Practice exercise: Automating sum calculation for a list of products

Working with Functions in Google Apps Script

  • Returning values from functions in Apps Script
  • Example: Calculating the last row of data in a Google Sheet
  • Passing arguments between functions for dynamic workflows

Practical Use Cases for Automating Google Sheets

  • Exercise: Dynamically selecting and summing a column in Google Sheets
  • Automating data entry and analysis in Google Sheets with Apps Script
  • Creating interactive forms and reports within Google Sheets

Google Apps Script for Add-ons and Extensions

  • Integrating Google Sheets with other Google Workspace services
  • Creating custom add-ons for Google Sheets
  • Example: Publishing and securing Google Sheets Add-ons

Comprehensive Practice Project

  • Automating a product lookup and pricing tool in Google Sheets
  • Empowering users to automate workflows in Google Sheets

Other Related Courses

Google Sheets Beginners Training

Google Sheets Intermediate Training

Google Apps Script Intermediate Training

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.

Computer Tutoring Training Centres

We can also arrange instructor-led training from these Computer Tutoring training centres.