Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
547 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Google Sheets: 5 reasons you should be using them Part three of a five-part series of blogs |
---|
This blog lists 5 reasons why you might like to consider using Google Sheets (perhaps as an alternative to Excel?).
Google Sheets is an online spreadsheet application. In this blog we show 5 reasons you should give it a try. |
If you are familiar with recording macros in Excel, you’ll feel at home with the Macros option in Sheets. Click Record macro, perform your actions and watch as the code is written for you.
This Owl humbly recommends a better naming convention than Script2.
You can run a script from the Macros list or you can assign it to a button on the sheet.
There are no built in icons like in Excel but you can import images.
Google Scripts uses JavaScript as its coding language. Those familiar with VBA will see it is also an object-oriented programming language.
Without using variables the references can get quite long!
You don’t have to run a macro manually, instead you can attach it to a trigger. There are event triggers, like the sheet being opened, and time based triggers (like once a day).
The trigger options are currently not as extensive as VBA.
One point to note: some macros will - not that surprising really - only work when the user is logged in.
Parts of this blog |
---|
|
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.