Formulas can get pretty complex in Google Sheets (or any spreadsheet for that matter), and the one line formula bar raises the annoyance bar. Being able to extend the formula bar is a godsend! Excel already has the ability, and apparently Google added the ability back in 2016. I just found out about it last…
What’s changing We’re introducing three new features that will help you clean up and work with your data in Sheets. These features are:* Remove duplicates* Trim whitespace* Compatible spreadsheet shortcuts Source: G Suite Updates Blog: Three new features to format and work with data in Sheets These are some great features that will be a…
Source: Google Docs on Twitter: “Introducing a ✨ .new ✨ time-saving trick for users. Type any of these .new domains to instantly create Docs, Sheets, Slides, Sites or Forms ↓… https://t.co/BaW2PAHNg4” Google, who owns the .new top level domain, has set it up for you to quickly create several types of Google Documents. In the url…
Remove duplicates with this Google Sheets Add-on. Source: Remove Duplicates – Google Sheets add-on Remove Duplicates is a Googel Sheets add-on that will help you manage duplicate information in a spreadsheet. There is an extensive help page available on how to use the add-on.
Here’s how to embed a spreadsheet into a Google Doc, and how to keep it up to date. Open the Google Sheet Open the Google Sheet that contains the information you want to embed. Click and drag over the cells that you want to include in your Google Doc. In this example, I included the…
Use conditional formatting in Google Sheets to analyze data and grades. After a formative assessment, you can use a Google Sheet to analyze student performance on individual items on the assessment. This will allow you to spot trends in the students answers, to which you’ll need to investigate what students answered the way they did…
There’s a common phrase among reporters: “The news never sleeps.” This is why many news outlets rely on cloud-based productivity tools like Google Docs and Sheets to share information, check facts and collaborate in real time. And The New York Times is no exception. In May 2017, the U.S. House of Representatives voted on a new health care law affecting millions…
But the best of the best use Google Sheets differently than most. The experts use Sheets to automate their work. To help you take your Google Sheets game to ?, meet David Krevitt. David is the Mozart of Google Sheets. Ha, 2017 composer! Time-consuming tasks which take most entrepreneurs hours, David is able to do in just minutes. (Thanks,…
Two big updates to Google sheets, the ability to visualize data with machine learning and syncing data in Google Sheets to Google Docs or Google Slides. Machine language charting allows you to ask Google Sheets questions about your data, and let Google Slides figure out the best way to present the information to you. This is…
Easily create QR Codes in Google Sheets with the QR Code Generator add-on. To use the add-on, put the data you want converted to QR Codes in cells in column A. The data can be text, email address, website addresses, etc. In column B, put a description of the QR code. This will be used to name…