New Charts and Analysis Tools in Google Sheets

Google have long been known as one of the best email providers for small and mid-sized businesses, and their document management software tools are ideal for collaboration, particularly when employees are working remotely or in branch or satellite offices. And now, thanks to an upgrade in Google Sheets, the cloud app just became even more user-friendly.

Clear presentation and easy analysis of data is vital to the performance of Google apps’ spreadsheet application, Google Sheets. The latest update of the app is packed with a raft of tools and features designed to make life – and work – easier for Sheets users. Read on for a closer look at what you can expect.

Data Labels

One of the first things you will notice about the new and improved Google Sheets app is the Data Labels function. As you work, it is important to add clear labels to the data you input into charts, enabling easy and accessible referencing for you and whoever you share the sheet with.

Google Sheets makes this easy. Simply click on the chart you are working on and click the Quick Edit icon. This will give you access to the different parts of the chart, allowing you to edit the label for any field you see fit.

Improved Controls

Another recently added feature is the improved controls that are found in the latest version of Google Sheets. Users are now able to reposition charts more easily, facilitating more concise and accessible ways of presenting complex data.

Users may also resize their charts; an especially effective tool for those who need to share and present their data at board meetings, or amongst other larger groups of individuals.

Cloud Collaboration

Google Sheets has always been about more than just individual work, and the latest update reflects this. Cloud computing technology has enabled quick and easy collaboration between teams operating remotely, and this is something that Google have committed to in the development of the Sheets app.

The updated version of Google Sheets includes improved edit protection, making it more difficult for collaborators to make accidental edits to a shared sheet, and thus skew the data presented in it. This provides an additional layer of security against data corruption, and enables more effective levels of collaborative work than those provided by previous versions of Sheets.

Inline Previews

Previous updates of Google Sheets have offered users an intuitively-designed platform on which to view and analyse their recorded data. However, this latest update goes one step further, enabling inline previews of the data that is inputted into charts, and allowing users to keep track of any calculations and formulae as they work.

This preview function makes it easy to assess whether data has been inputted correctly or erroneously while you work, eliminating the risk of finding out much too late that one dodgy calculation has skewed all your data. Users can also employ improved filtration commands to filter the data they input, allowing more versatility in their data presentation methods.

Improved Pivot Functions

Pivot tables have been an intrinsic part of Google Sheets’ functionality since the app was first developed. The updated version of the app has given them a new lease of life, supporting the addition of calculated data to pivot tables as you work. The effect is a more user-friendly, versatile and useful version of Google Sheets that responds intuitively to the needs of the user.

Developers have also added the GETPIVOTDATA command, which facilitates the retrieval of data directly from pivot tables. This adds another layer of functionality to the latest update of Google Sheets.

Comprehensive Script Rendering

Last but certainly not least in our rundown of what’s new for the latest update of Google Sheets is the app’s improved script rendering. Growing numbers of businesses are expanding into international markets, which means an increased need for rendering data in different scripts or alphabets, either for presentations to overseas partners and clients, or for remote, international collaboration.

The latest update of Google Sheets supports text rendering for a further 16 writing systems, on top of the standard Latin script used in the UK, US and most European markets. These include Bengali, Gujarati, Telugu and Tibetan, amongst others.

If you’d like to know more about how Google Sheets and the rest of their suite of productivity-boosting tools and apps can help your business run more efficiently, get in touch with the team at Damson Cloud today.
[code-snippet name=”cta4″]

Training Video