Government Technology: Can Dashboard Tools Finally Knock Out Excel Sheets?. “Transparency, efficiency and citizen input are among the main ideals of the post-pandemic government landscape. Dashboard technology offers a way to do that but must overcome historical challenges.”
Make Tech Easier: 8 of the Most Useful Google Sheets Formulas. “Thanks to Google Sheets formulas, you can do far more than just perform general sorts or add columns. The most useful formulas go beyond adding, counting, and giving you averages, though all of those are useful too. Imagine if you could easily import just the data you needed into another spreadsheet or only count cells that match specific criteria. That’s just the start of what’s possible.”
How-To Geek: Google Sheets Is Adding Colorful “Chips”. “Google has announced that Sheets is gaining support for dropdown chips. You can add dropdown chips to cells within your spreadsheet and assign different colors, serving as an additional visual indicator and letting you know the status of something at a glance.”
9to5 Google: Google’s Simple ML for Sheets add-on can predict missing and spot abnormal values. “Google today announced an add-on for Google Sheets that applies ‘Simple ML’ to your data that was built by the TensorFlow team to help make ‘machine learning accessible to all.’”
How-To Geek: How to Convert a JSON File to Microsoft Excel. “Have you received a JSON file that you’d like to convert to Microsoft Excel format? Excel offers a built-in option to help you import it without third-party parsing tools. Here’s how you can do it.”
Wolfram Blog: Wolfram CloudConnector: Excel’s Data Science Superpower. “Wolfram CloudConnector for Excel can transform Excel into a data science powerhouse by injecting Wolfram Language functions straight into your spreadsheets. It does this by providing a connection between Excel and Wolfram Language, extending the computational power of your spreadsheets.”
How-To Geek: 13 Google Sheets Date and Time Functions You Need to Know. “When you use a spreadsheet for things where the timing is essential, you likely include dates and times. Google Sheets offers a collection of functions for formatting, converting, and calculating dates and times to help with your data entry.”
Digital Inspiration: Formulas in Google Sheets Disappear When New Rows Are Added – The Solution. “The formulas in Google Sheets may get deleted when new rows are added in the sheet or when new responses come in through Google Forms. The fix is simple!”
How-To Geek: How to Import Data With Google Sheets Functions. “You may want to work with data in your spreadsheet that resides elsewhere. Using a set of Google Sheets functions, you can import data from a CSV file, RSS feed, web page, or another spreadsheet. With the functions we’ll describe here, you can pull data into your sheet from external sources. Then, analyze, manipulate, format, and do what you please with your new data.”
MakeUseOf: How to Build a Simple and Effective Content Calendar in Google Sheets. “With many content calendar software available, it can be challenging to pick one. Some are overcomplicated, some are outside your budget, and others give you a suite of tools you’ll never use. It may even be that you’re still trying to pick your favorite and need a solution in the meantime—one without a paywall or trial period. Whatever the situation, you can create one that offers what you need—and nothing more—using spreadsheet software.”
Hackaday: Organise Your Hacks With Treesheets: An Open Source Hierarchical Spreadsheet. “TreeSheets is described as a hierarchical spreadsheet, which is intended as a replacement for several distinct tools; think spreadsheets, mindmaps and text editors and similar.”
9to5 Google: Google Sheets adds XLOOKUP, Named Functions, and a few other advanced features. “Ben Collins, a Google Developer Expert working with Sheets, shared this week an explanation detailing several new features that have been released for Google Sheets. Specifically, 10 new functions that will be helpful for power users.”
MakeUseOf: How to Transpose Data in Google Sheets . “Have you got a table in Google Sheets that’s in the wrong direction? Whether you want to turn a vertical table horizontal, or the other way around, transposing is your best friend.”
How-To Geek: 6 Effective Ways to Use Explore in Google Sheets. “The Explore feature works differently in Google Sheets than in Google Docs. You can use it to get useful details about your data to help you analyze it. You can also use pieces that the tool provides in your spreadsheet. If you’re looking for a handy way to learn more about the data in your Google Sheet, here are various ways to use the Explore feature.”
TechCrunch: Dropbase can help turn your messy spreadsheet into queryable SQL database. “It’s not unusual for a tech company to be born by accident. Famously, Slack was created as a byproduct of a now defunct gaming company. Similarly, when Dropbase founders Jimmy Chan and Ayazhan Zhakhan were in the Y Combinator Winter 20 batch, they were testing the product they had built at the time and accidentally stumbled upon the thing that would become Dropbase.”
The ResearchBuzz Firehose is regular RB content presented as individual posts.
For digest-type posts a couple of times a day, please visit ResearchBuzz.
Want to know how to best use the Firehose for content discovery?
Check out this handy article.