Google Apps Script Training Intermediate Kensington

Kensington Intermediate Google Apps Script Overview

We are pleased to be able to support businesses or even private households in Google Apps Script at a Intermediate level.

Located in the heart of London, Kensington is a thriving hub for businesses and residents alike. Whether you're a small local company or a private individual looking to enhance your skills, we’re here to help you succeed in Google Apps Script. Known for its rich cultural history and prestigious institutions, Kensington provides an excellent backdrop for learning and growth.

Let us come to your business – we can bring laptops and can squeeze into the tiniest spaces. So basically, if you can find a space, we can train you. We can also provide:

• Laptops with software if required
• Google Apps Script Training Notes
• Post-training support

Beyond the training, Kensington offers a range of great amenities and attractions for visitors. Take a stroll through Hyde Park or explore the renowned museums like the Natural History Museum and the Victoria and Albert Museum. After your training session, why not enjoy one of Kensington’s many charming cafes and restaurants?

Please take the time to check out the various other computer training courses in Kensington. We are sure that you'll find one that suits you.

Visit Kensington, home to world-famous museums and beautiful Victorian architecture.

Course Duration: 1 Day

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 training courses:

Google Sheets Beginners Training Course

Google Sheets Intermediate Training Course