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.”
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 . “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.”
HubSpot: 12 Google Sheets Add-Ons to Streamline Reporting. “Google Sheets can be used for a lot more than just storing and organizing your data. With the right add-ons, you can streamline your reporting process, collect big-picture data predictions and analysis, and even send emails — all from your spreadsheets.”
MakeUseOf: How to Use Google Sheets to Keep Every Part of Your Life Organized. “You don’t need shiny new apps and websites if you’re looking to get your life organized. All you need is the trusty spreadsheet. With Google Sheet’s sharing capabilities and some solid, easy-to-use templates, you can stay on top of your budget, schedule, to-do list, and more.”
Google Blog: Think macro: record actions in Google Sheets to skip repetitive work. “We’ve been focused on making Google Sheets better for businesses for this reason, which is why we’ve recently added new features to help teams analyze and visualize their data. Today we’re adding more updates to Sheets, including a way to record macros in the cloud to automate repetitive tasks, as well as more formatting options.”
ZDNet: Microsoft to add new geography, stocks data types to Excel. “Microsoft is bringing new kinds of AI-enabled data types to Excel, starting with geography and stocks. Up next: Companies’ own organizational data.”