G Suite Custom Functions and Automation Introduction
Request more details:
This is an introduction to the scripting features that are available in GSuite. There are two broad use cases - creating custom functions and automating tasks. Custom functions can make your sheets easier to understand or can do things that are not possible with the built-in functions. Automating repetitive tasks is another use for scripting and can take help you work smarter rather than harder and eliminate potential sources of human error.
Cost: Price on application
Duration: 1/2 Day
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Participants should be experienced GSuite users - or MS Office Advanced users.
A GSuite custom function:
A simple custom function
A more complicated custom function
Automating a task:
The GSuite custom function second use case is to automate a task.
Perhaps you have to do three operations every time you open a Sheet - you can automate these to become a single operation.
We will create some simple scripts for automating tasks.
Launching a script:
When you have a reusable script you will need to launch it. There are various techniques for doing this. We will look at adding a clickable element to a sheet and modifying the menu structure.
Recording a macro / script:
A new feature in GSuite is the ability to record a macro.
Customising a recorded macro.
Launching a macro.