G Suite Custom Functions and Automation Introduction
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.
Contact us for pricing
PrerequisitesParticipants should be experienced GSuite users - or MS Office Advanced users.
A GSuite custom functionA simple custom function
A more complicated custom function
Automating a taskThe 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 scriptWhen 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 / scriptA new feature in GSuite is the ability to record a macro.
Customising a recorded macro.
Launching a macro.
DocsG SuiteGoogle AppsGoogle Cloud PlatformGoogle DocsGoogle SheetsGoogle SuiteGSuiteSlidesGoogleGoogle Apps Script