Google Apps Script Training Intermediate Hammersmith

Hammersmith Intermediate Google Apps Script Overview

If you're wanting to book your Google Apps Script Training and are wondering about the following:

• You don't know what course to take!
• You have no idea of your skill level.
• You are wanting training for your team.

Then we'll be happy to help you choose or design a course that suits you. We can come to you but should you want to get away to do the Google Apps Script Training then the offices we use in Hammersmith are at:

Hammersmith
Crown House
72 Hammersmith Rd
Hammersmith
London W14 8TH

An ideal location for your Google Apps Script Training Intermediate training course. The training centre is situated in the heart of west London between Hammersmith and Kensington.

The building, Crown House, is bright and modern with large windows giving the training course location a spacious, airy and comfortable feel. Within easy walking distance of Hammersmith High Street.

The training course location is close to major roads, local bus routes and several London Underground stations the closest being Barons Court.

There are many other computer training courses in Hammersmith & Fulham available. Please see if there is a course for you.

Hammersmith is a lively area with a thriving arts scene, including the famous Hammersmith Apollo.

Course Duration: 1 Day

Course Prerequisites for your training in Hammersmith

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