Google Sheets is a spreadsheet program similar to MS Excel; however, it is primarily Internet-based. Google Sheets are saved in the cloud, specifically, in Google Drive, and can be accessed from a phone, tablet, or computer with or without an Internet connection. Google Sheets can be extended with third-party add-ons.
One of the most powerful features of Google Sheets and other Google applications is that multiple people can work on the same document at the same time. This is a huge plus for education. It is possible to share documents with anyone for viewing or editing.
You can complete common spreadsheet tasks such as displaying data with charts and graphs, format data with conditional formats, analyze data with pivot tables.
There is integration between MS Word and Google Sheets. You are able to import an Excel document, convert it to Google Sheets, and export it back to Excel. It is possible to begin a document by using a template. There is a category dedicated to students and teachers. All edits are automatically saved. Revisions are saved and it is possible to see who made a specific edit.
Essential Requirements
Google Sheets will operate on both a Mac or PC, as well as mobile devices.
Equipment
The only equipment needed is a computer, smartphone, or iPad with a Web browser.
Software
Access to Google Sheets is accomplished through a Web-browser. These are the most common browsers:
- Internet Explorer
- Firefox
- Google Chrome
- Safari
Google Sheets is accessed by going to https://sheets.google.com/
Learning resources information
Key Weblinks
Guides and Beginner Instructions
Here are a number of great guides to help you better understand Google Sheets and their capabilities.
- Google Docs Spreadsheet Tutorial
- Google Spreadsheet Tutorials
- Tutorial: Spreadsheets
- Google Sheets CHEAT Sheet for teachers and students!
Google Sheets Add-ons
Here are a number of recommended add-ons for extending Google Sheets.
Education
Here are a number of great ideas for using Google Sheets in an education environment.
- Everything Teachers Need to Know about Google Spreadsheets
- A Step By Step Guide On How to Create Flashcards Using Google Spreadsheets
- Create Jeopardy-style Games in Google Sheets
- 7 Tips To Use Google Sheets in eLearning
Tips and Shortcuts
Here collections of tips and shortcuts for using Google Sheets better.
- Managing Instagram Photo Call-Outs
- A Handy App for Converting Google Sheets into Google Docs
- Multiple Google Forms to One Spreadsheet
- Turn your Data into a Heat Map
- Extending Conditional Formatting in Google Sheets Using Dynamic Date Calls
- Google Apps: Applying Conditional Formatting Across Sheets
- How to Scrape Data From the Web Using Google Spreadsheet
- Google Sheets: Excluding Weekends in Conditional Formatting
Video Tutorials
Here is a collection of videos that will help you understand and use Google Sheets.
[…] Tools and Methods – Google Sheets […]