Sparklines : A small embedded line graph in a cell that illustrates a single trend.Slicer : Filter your data (or pivot table, pivot chart) by clicking on the type of data you want.Pivot Table : Summarize the data and create powerful cross tables.Google Sheets can be used as a database and perform various data operations: Cell Formatting : Add border or background color to a cell or cell ranges.Text Formatting : Change text font, size, color, weight or style.Toolbars : A collection of options that provide one-click access to commonly used commands such as Save, undo, and many more.Entering Formatted Number : You can also enter formatted data like time, date, currency, percentage, etc.Entering data : You can enter text, link, image, or number in your sheets.Templates : It has a variety of elegantly designed ready-made templates for different purpose.Like any other spreadsheet tool, Google Sheets has all the general features that you expect from a spreadsheet tool: The following feature of Google Sheets makes it worth using: How to insert image in Google Spreadsheet (Learn to insert image in a cell or outside of cells in a spreadsheet).How to Save a Google Sheet (Learn to save a spreadsheet for offline access).Rather than wasting your precious time manually writing down everything on paper, you can use Google Sheets to quickly prepare a test report. It is used across all business functions and at companies from small to large scale.īefore you make any assumption that Google Sheet is only used by business professionals, let me tell you this online tool can be used by anyone who wants to organize data.įor example Let’s say you are a class teacher and you want to prepare a test report of all the students in your class. Google Sheets is typically used to organize data and perform data analysis. It is similar to how Microsoft Excel, MS Word, and PowerPoint are individual tools within the Microsoft office suite. Google Sheets along with Google Docs and Google Slides is part of what Google calls “ Google Workspace” previously known as G Suite. Google Sheets is a web-based online tool that is used to create, update and modify spreadsheets and share the data online in real-time.

Google sheets for windows 10