Google Spreadsheets Basics

Google Spreadsheets or Sheets, as it is already known, was launched as a standalone product, but it is now a fully integrated part of Google Drive . It has the potential to be extremely useful for anyone who needs to deal with spreadsheets in a group setting. You can access Google Spreadsheets at drive.google.com.

Import and export

In general, Google Spreadsheets requires that you sign in to a Google Account. If you do not have one, it will prompt you to create one. You can import spreadsheets from Excel or another standard .xls or .csv file, or create a spreadsheet on the web and download it as a .xls or .csv file

Share the wealth

This is where Google Spreadsheets is very useful. You can invite other users to view or edit your spreadsheet. This means that you can share a spreadsheet with colleagues in your office to get information about the test project. You can share a spreadsheet with a classroom and give students input. You can share the spreadsheet with you so that you can view and edit it on more than one computer. The files are also available on Google Drive for potential offline editing.

If you share a folder , all items in that folder inherit the sharing properties.

Multiple users, all at once

This feature has existed for centuries. I tested this by having four people edit the cells in the test table at the same time to see how they reacted. Google Tablets had no problem allowing many people to edit cells. In earlier versions, if two people edited exactly the same cell at the same time, anyone who saved their last changes would overwrite the cell. Since then, Google has learned how to handle concurrent edits.

Why do you want to have multiple users in your spreadsheet? We’ve found this to be very useful for testing software, creating feature suggestions, or just brainstorming. When using a spreadsheet, it’s important to set rules in advance, and it’s easiest for us to create a spreadsheet while others add data to the cells. The presence of multiple people makes the columns tend to be chaotic.

Cooperation and discussion

Google Spreadsheets offers a convenient built-in chat tool on the right side of the screen, so you can discuss the changes with anyone else who currently has access to this spreadsheet. This helps reduce the impact of simultaneous cell editing.

Graphics

You can create columns from data in Google Spreadsheets. You can choose from several basic chart types, such as pie, bar, and scatter. Google has also created a mechanism for creating graphical applications from third parties. It is possible to take a chart or gadget and publish it somewhere outside the spreadsheet so that you have a chart that is powered by updated data, for example behind the scenes. Once you create the chart in the standard way, it is embedded in your spreadsheet. You can edit the graphic and save the graphic itself as a png image to import into other programs.

Upload a new version

Google Spreadsheets started out as something aimed at sharing a spreadsheet but keeping a backup on the desktop. It was a wise move with experimental new software, but Google had years to fix the major bugs. You can now overwrite uploaded spreadsheets via Google Drive, but you really don’t need to save the file to Google for editing. The sheet also supports versions.

 

Leave a Comment