Formerly Google Apps for Work, now G Suite is a platform for cloud computing, with productivity and collaboration tools, software and products developed by Google, especially for enterprise customers.
It comprises of Gmail, Hangouts, Calendar, and Google+ for communication; Drive for storage; Docs, Sheets, Slides, Forms, and Sites for collaboration, with all applications running in the Cloud. Now, the company has rolled out enhancements to Sheets, including the ability to record macros.
While the ability to record macros was first introduced in Microsoft Office, to automate a repetitive task, so that users can record a macro with the Macro Recorder in Microsoft Excel.
Google’s effort to appeal to more business customers with G Suite product portfolio, led to the launch of macro recording to provide a way to automate repetitive tasks within the G Suite spreadsheet tool, potentially to save enterprises hours spent on the job.
The macro recorder allow G Suite users to record actions within Sheets and then play them back without writing out codes, and the recorded macro is automatically converted into Apps Script, a scripting language derived from JavaScript.
Also, it is possible for users to write custom Apps Script functions and import them as new macros to spreadsheet.
Other new features introduced to Sheets include the ability to add printing page breaks, custom paper sizes, and more options for row and column grouping. The updates come as Google plan to attract more enterprise customers to its productivity suite, which now has more than three million paying customers.
The new features adds to Google’s recent enhancements to Sheets, involving pivot tables, and machine learning capabilities, to simplify the management of large datasets.
No comments