Skip to content

Notes on science, software and the craft of support

Martin EvansNotes and resources

Software

Google Sheets for shared spreadsheets

Google Sheets is a free cloud spreadsheet application for creating, storing and sharing work online, with formulas, charts and live collaboration.

Google Sheets is a free cloud based spreadsheet application from Google. It allows users to create, store and share spreadsheets online. It offers a range of features for creating, editing and collaborating on sheets, including an easy to use interface, formula support, data validation and support for multiple users.

Google Sheets is a strong tool for organising and analysing data. It has powerful features that allow you to create complex formulas, use data from other sheets and visualise data in a variety of ways. It is also easy to share and collaborate with other users.

Formulas and analysis

One of the most powerful features of Google Sheets is its ability to create formulas. A formula is a set of instructions that tell the computer how to calculate a result. For example, if you wanted to calculate the total cost of a purchase, you could enter a formula that adds up the cost of each item. If you wanted to calculate the average of a set of numbers, you could use a formula for that too. Formulas are an essential part of spreadsheets and allow you to analyse data and make decisions quickly.

Google Sheets also offers tools for analysing data. It has built in functions for sorting, filtering and searching, as well as the ability to create charts and graphs. These features help you identify trends in the data and decide what action to take.

Multiple people can work on the same spreadsheet at the same time. That is useful for teams that need to collaborate on analysis or reports, and for anyone who wants to share data with others. If you are looking for a capable and accessible spreadsheet application, Google Sheets is a good choice.

Sources and further reading

Official documentation and reference material for this topic.