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.”
Google Sheets
The Verge: Google Docs, Sheets, and Slides can now be edited and shared within Dropbox
The Verge: Google Docs, Sheets, and Slides can now be edited and shared within Dropbox. “Dropbox Business now integrates directly with Google Docs, Sheets, and Slides within G-Suite, letting you create and collaborate on files directly from within the file-sharing service’s interface.”
OPEnS Hub: Real-time Data Logging, Connecting Field Sensors to Google Sheets (ScholarsArchive@OSU)
ScholarsArchive@OSU: OPEnS Hub: Real-time Data Logging, Connecting Field Sensors to Google Sheets. “In Earth science, we must often collect data from sensors installed in remote locations. Retrieving these data and storing them can be challenging. Present options include proprietary commercial dataloggers, communication devices, and protocols with rigid software and data structures that may require ongoing expenses. While there are open-source solutions that include telemetry, such as EnviroDIY’s Mayfly, none presently generate real-time, remotely accessible workbooks (EnviroDIY, 2018). The Openly Published Environmental Sensing (OPEnS) Lab developed the OPEnS Hub, a new approach to using low-power, open-source hardware and software to achieve real-time data logging from the field to the web.”
Lifehacker: How to Translate Languages With Google Sheets
Lifehacker: How to Translate Languages With Google Sheets. “There are more efficient ways of keeping track of important foreign language vocabulary than a hand-held dictionary. If you’re learning a new language or making basic translations, try using the Google Translate formula in Google Sheets for an easy access list of what you know—or want to know.”
How-To Geek: The Best Google Sheets Add-Ons
How-To Geek: The Best Google Sheets Add-Ons . “Google Sheets add-ons work similarly to browser extensions. They are third-party apps you install to Sheets to gain additional features. Some add-ons increase productivity, and some add more extensive capabilities. Here’s how to get started.”
How-To Geek: How to Automatically Generate Charts in Google Sheets
How-To Geek: How to Automatically Generate Charts in Google Sheets. “Google Sheets gives you a wide variety of free graphs from which to choose. Whether you want to use a pie chart or something a little more complicated like a radar chart, you won’t be disappointed with the options available.”
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.”
