How-To Geek: How to Automate Google Sheets With Macros

How-To Geek: How to Automate Google Sheets With Macros. “When you record a macro in Google Sheets, it automatically creates an Apps Script with all the code to replicate your actions for you. This means you can create complex macros without knowing how to write code. The next time you run it, Sheets will do everything you did when you recorded the macro. Essentially, you’re teaching Google Sheets how to manipulate a document to your liking with a single command.”

ZDNet: Microsoft starts rolling out ability to turn photos of table data into Excel spreadsheets

ZDNet: Microsoft starts rolling out ability to turn photos of table data into Excel spreadsheets. “Microsoft has started making available its ‘Insert Data from Picture’ feature that allows users to take pictures on their phones of table data and automatically turn it into an Excel spreadsheet. Microsoft announced this feature at its Ignite conference last September.”

MakeUseOf: 6 Google Spreadsheet Tricks That Are Easy to Learn and Remember

MakeUseOf: 6 Google Spreadsheet Tricks That Are Easy to Learn and Remember. “Google Sheets is a popular Microsoft Excel alternative. As with other Google tools, the Sheets is a core part of Google Drive. In this article, we have taken the liberty to dive deep and unearth a handful of super useful Google Sheets tricks that you may have never heard before.”

MakeUseOf: The 7 Best Online Databases as Simple as Spreadsheets

MakeUseOf: The 7 Best Online Databases as Simple as Spreadsheets. “When you think of database apps, your mind probably pictures Microsoft Excel first. The app has been the de facto market leader for at least two decades. But it’s not the only show in town. There are plenty of web-based database apps that are just as simple as using a spreadsheet. They each have their own strengths and weaknesses and are targeted at different types of users.”

How to: uncover Excel data only revealed by a drop-down menu (Online Journalism Blog)

Online Journalism Blog: How to: uncover Excel data only revealed by a drop-down menu. “Sometimes an organisation will publish a spreadsheet where only a part of the full data is shown when you select from a drop-down menu. In order to get all the data, you’d have to manually select each option, and then copy the results into a new spreadsheet. It’s not great. In this post, I’ll explain some tricks for finding out exactly where the full data is hidden, and how to extract it without getting Repetitive Strain Injury.” Ooo. Spreadsheet forensics. I like.

MakeUseOf: How to Automate Repetitive Tasks in Google Sheets With Macros

MakeUseOf: How to Automate Repetitive Tasks in Google Sheets With Macros . “While Google Sheets has long allowed users to write their own Apps Script functions, macros open up this kind of functionality to all Google Sheets users—no coding experience required. Macros are particularly useful if you find yourself dealing with multiple sheets over and over with similar data or information. For instance, any kind of monthly trackers with elaborate functions to collate data will benefit from the of macros.”