Google Spreadsheets are getting even better!

As Google Apps resellers one of the hardest tasks we are faced with is convincing users to change to Google Docs and to move away from using their comfortable and well known Microsoft Office Suite. 

We started using Docs about 5 years ago - and initially the going was tough. You could not use formulae, formatting was difficult and a number of other features were just not available yet. 

Then things changed. And changed. And they have just not stopped changing. 

Google announced that they are going to be spending time working on Google Spreadsheets - with this update being the largest one in recent memory. Now that makes my ears perk up - because with all the awesome changes that have already come in - what else are they going to pull out of the hat?

New Google Sheets: faster, more powerful, and they work offline.

You can now really plough through work using the new Spreadsheets. They are safer, faster, boast a number of new features and on top of all that - they work offline now. 

Bigger and faster spreadsheets.

At OpenNetworks we do a lot of Apps Scripting - and in a couple of projects we have run into data limits on spreadsheets. Crazy - we know - but one particular client just has so much data that needed to be dealt with. So the addition of support for millions of cells eliminates the need for complex solutions. Loading sheets and doing calculations are all quicker even in complex spreadsheets - and that makes the use of the spreadsheets for tasks a complete no-brainer. 

Filter views.

This is a feature that I personally have been waiting for. And just in time for Christmas - here it is! You can now name, save and share different views of your data. I especially like that when collaborating - so I can sort a spreadsheet for my needs and the team collaborating on it do not have to see my filters on their screen. And vice versa. 

Using formulae and complex functions

Using basic formulae or getting stuck into complex functions? New function help makes it much easier and with error highlighting and colouring to spot your mistakes, fixing them is a cinch. 

Offline and need to work? No worries!

Being online all the time is a bonus. But let's be honest, it is not always a reality. So Google have come to our rescue and you can now make edits to Google Spreadsheets offline. When you reconnect to the internet - your edits automatically sync. Want to get set up for that - then follow these instructions to set up offline for Chrome. 

So are you keen to try it out?

Turn on new spreadsheet features by checking the “Try the new Google Sheets” box in your Google Drive settings. From then on, all new spreadsheets you create will work offline and include these new features. Google will be working on Spreadsheets for a while still. They are going to be adding a small list of missing features in the coming months, so keep an eye out for the changes!

Want to know more? Get hold of OpenNetworks on +27 11 317 4900 or mail us on sales@opennetworks.com.