11 new Google Sheets functions are on the way to help you better splice your data

Google Sheets is mostly considered a weaker database tool than its main competitor Microsoft Excel, but Google is gently improving the features of its database software to ensure it’s competitive with Excel. In recent months, we’ve even seenMicrosoft Excel nab oneof the bestGoogle Sheets featuresfor its own software. Now, inan upcoming update, Google Sheets will be gaining eleven new functions that you may find helpful.

It’s unlikely all of these new features will be useful for you, but some may improve the way you use Google’s database software. These are expert functions, so they’ll likely prove more helpful for those who are particularly skilled with Google Sheets or similar database software. For example, one of the new features is a Margin of Error function that will calculate a sampling error of selected values and a confidence level for each result. Here’s Google’s changelog for each of the new functions:

4

These are undeniably expert features that you’ll likely only want to be using if you’re already adept at using Google Sheets. For those who do use Google Sheets regularly to splice their data, these new features may prove game-changers.

The good news is that these new features are coming to everyone who uses Sheets no matter what Google accounts you’re using. So it’ll be for all personal Google accounts and Workscape customers as well as legacy G Suite Basic and Business customers. We’ve yet to spot this running on any of our accounts, and Google has yet to say when it’ll arrive, so it may be a bit of a wait until we see these new functions land. In the meantime, take a look at our guide to the11 best add-ons for Google Sheets.

Google Sheets logo on top of a page of formulas

The note-taking app I should have used all along

Broader branding hints at wider paid-tier ambitions

Browsers

Pixel downsides never change

Samsung’s making a bold move

Samsung Notes logo in front of image containing S Pen and devices using Samsung Notes

This article is sponsored by Total Wireless.

Keep privacy a priority with the best VPNs

Google Home icon with some gadgets around it.