[SMK] Social Media Knowledge

DIGITAL MARKETING NEWS

Martech Mashup: Macros in Google Sheets

Office aficionados are often proud of macro manipulations that streamline work flows. But not all productivity suites are equal.

Now, macros have launched in Google Sheets.

How to macro

Macros are series’ of actions recorded within an app, that can be replayed when needed. They can speed up your reporting a lot.

To record one in Sheets, open the ‘Tools’ menu, hover on the ‘Macros’ item and click ‘record’. Perform the actions you want recorded, then click ‘save’.

To replay the saved actions takes two clicks, or your can assign a keyboard shortcut for frequently-used favourites.

G Suite have published a pro-tip tutorial on YouTube that sums it all up in a tidy two minutes and thirty-six seconds.

Who needs code?

Macros are saved as a script that can be replayed whenever the user wants. Users don’t need to know scripting language nor write any code: the record and save buttons do all the work within the app.

That said, Google is letting code-savvy folks edit the recorded scripts directly, or even write their own macros from scratch.

Micro macros

By recording macros in Sheets, G Suite chalks another one up against rival Microsoft Office.

Indeed, the blog post that launches the capability links to a guide on how to make the leap from Microsoft’s Excel to Sheets.

What are the main obstacles that Google must yet overcome to take down Microsoft Office as the default productivity suite?

Copy Transmission is a Melbourne-based agency :: Better Brands. Loud & Clear.

Learn with SMK W/C 4th July 2022

Start your SMK: Digital Excellence 30-day free trial today and unlock unlimited, on-demand access to hundreds of hours of digital masterclasses, training courses and hands-on tutorials.

Your risk-free trial offers the perfect opportunity to expand and upgrade your digital intellectual property.

Each month SMK releases 30 hours of new and updated social media and digital marketing educational course content, ensuring you never get left behind – be it on digital strategy, tactics or implementation.

Alongside this, SMK offers live help and support weekly within the SMK Working Group. It might be a quick fix or the root of a bigger problem; either way, a problem shared is a problem halved. On a day-to-day basis, SMK’s team gives you hands-on support and fresh ideas.

Not to mention a shoulder to cry on, occasionally

SMK Labs running this week

Mon 4th July: Member Clinic from 1 pm – 2 pm AEST

  • Live help and support from SMK’s team of analysts
  • Book in to request a personalised discussion for 15 or 30m via Zoom within the Facebook Working Group

Tues 5th July: Member Clinic from 1 pm – 2 pm AEST

  • Live help and support from SMK’s team of analysts
  • Book in to request a personalised discussion for 15 or 30m via Zoom within the Facebook Working Group

Thurs 7th July: 2022 Social Media Strategy Optimisation, 10 am – 12 pm AEST

  • Module Three in SMK’s updated and expanded 2022 Social Media Strategy Optimisation strategy course 

Fri 8th July: Digital Design for Non-Designers: 10 am – 12 pm AEST

  • Module Three in SMK’s Digital Design for Non-Designers, helping businesses maximise creative results 

Leave a Comment