Sheets allows you to handle task lists, create project plans, analyze data with charts and filters, and more.
With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.
Google Sheets is available through Google Drive, one needs to first log in with a Google account in order to create, edit, save, and share files. The Google account acts like a unified sign-in system that gives access to Google’s product catalog–Gmail is not required for using Google Drive/Sheets, as any email address can be associated with a Google account.
Google Sheets offers the basic and frequently-used features that one would expect when working with spreadsheets, such as (but not limited to):
Customize the spreadsheet and data (with autofill capability)
Work with rows, columns, and cells
Implement functions, macros, and scripts for complex calculations
Add charts/graphs, pivot tables, and images
Import and/or search for data in spreadsheets
However, there are some notable strengths to using Google Sheets versus other options:
Work with the same document every time — even from multiple devices, platforms, and/or locations — since files are stored in the cloud (Google Drive). Changes are automatically saved, and offline editing (via mobile app and the Google Chrome web browser) is also available.
Share files with others (instead of emailing multiple copies back and forth) for collaborative, real-time editing, commenting, and chatting. Google Sheets’ built-in revision history tracks all changes (both the people and edits they made) and gives users the option to restore the file to an earlier version.
Integration/access to other Google products, such as Google Forms (for creating/inserting feedback polls/questionnaires/surveys on spreadsheet presentations), Google Translate (cell functions for translating languages), or Google Finance (automatically finds and inputs specified finance info).
Easy to learn/teach and is free for individual use.
This 16 minute video (external link) shows you the capabilities of Google Sheets and how to get started and use them.