Google Sheets updates charting, filtering and pivoting features to take on Excel

Google Sheets updates charting, filtering and pivoting features to take on Excel

Google Sheets is getting a bit more powerful today in its battle to take on Excel thanks to a slew of updates.

Now you can add data labels to display the exact value for bars or points on a graph. You can also change the shapes of your data points – stars, triangles, pentagons and more are available to pretty up your document and differentiate different lines.

Ever been to a tech festival?

TNW Conference won best European Event 2016 for our festival vibe. See what's in store for 2017.

Charts-Data Labels_Shapes

When you input formula, Sheets will now automatically preview results instantly as you type – Google says it’s particularly useful for catching errors quickly.

You can also filter rows and columns by conditions such as “greater than”and “text contains,” while pivot tables now allow you to add calculated fields to apply formulas to your data. A GETPIVOTDATA function also makes it easier to retrieve data from your tables.

A big part of Google Docs is the ability to collaborate with users, but that has it’s consequences too. Previously, your choices were pretty black and white; either you allow someone to collaborate or you deny them access.

Heads Up.png (1)

Now you can also add a warning to prompt users before they make changes to a cell – useful to prevent accidental mistakes.

The updated sheets is rolling out to everyone today.

Google Sheets: Do more with your data [Google Docs Blog]

Read next: Adobe launches its first Creative Cloud mobile apps on Android

Here's some more distraction

Comments