Updated: June 14, 2019.
- Overview of Google Sheets
- How to Sign Into G Sheets
- How to Create or Edit Google Sheets.
Whether you are a student, an accomplished professional or a business person, Google Sheets is an online tool you need. If you are in the business of processing complex numbers and information or you carry out simple daily tasks, learning how to use Google Sheets will prove beneficial in no small amount. Be it a project you are starting or just about anything else like planning a wedding, creating an inventory, or organizing an event, Google Sheets is one of the greatest ways to process your data. It is a free web-based office suite that lets you create and edit spreadsheets stored on your Google Drive. If you are Microsoft Excel aware, you will not find it difficult to use.
Google Sheets is a user-friendly online solution that allows you to create, edit, and analyze different types of data using spreadsheets. It is available in different forms such as mobile apps for Windows PC, a desktop application on Google’s Chrome OS, web applications, Android, and iOS. In this article, I will show you the different ways you can use Google Sheets and its interface. You will also learn how to select cells, insert content, delete content, copy and paste cells as well as format cells. With it, you can collaborate real-time with your team member and colleagues from anywhere. You can customize it to serve as a tool for the online survey using Google Drive.
Features of Google Sheets
- Collaboration – You can work with other people in the same spreadsheet at the same time. With it, you can create new spreadsheets or open existing ones and share with others to edit together. Doesn’t that sound interesting?
- Automation – Saves all your changes automatically
- Solid template designs – You have the option to choose a template according to your needs.
- Microsoft Excel compatible
- Offline access
- Instant insights/overview
- Real-time edition and sharing
How to Sign Into G Sheets
There are three basic ways you can use to access Google Sheets. Here are the steps:
- On your web browser, type google.com/sheets/about/
and click on “Go to Google Sheets” tab.
On the Sheets homepage, you will see tabs like “Start a new spreadsheet – Blank”, To-do list, Annual budget, Monthly budget, 2018 Calendar, and Template Gallery.
Click on Blank to launch a new spreadsheet or use any of the tabs depending on your needs.
- You can also access Google Sheets via Google Drive by clicking the “My Drive” drop-down menu. Sheets will appear as one of the options
- Other ways of accessing Google Sheets are via Google’s Homepage, your Gmail account or any Google search results. You can also click the Google Apps Menu in the upper, right-hand corner of your Chrome browser. Then, choose Sheets from the menu. Click on more to reveal the app in case it does not appear as a drop-down menu item. Sheets is the second option after Docs in the Google tab.
How to Create or Edit Google Sheets
To create Google Sheets, launch a blank or new spreadsheet by clicking on the + sign in the “Start a new spreadsheet or Blank” tab. When it opens, you can perform the following actions:
- Enter data in rows and/or columns just like in Microsoft Excel. To copy, delete, hide, or paste entire rows, right-click the number of the row and select your preferred function from the menu that appears. In the same vein, you can perform the same functions to entire columns. Just click on the drop-down arrow that appears when your cursor hovers over that column’s letter.
- You can format an entire row or column by selecting its corresponding number or letter. For example, in order to format a single cell, select that cell alone. Once you have selected your dataset, you may either click the Format tab or select from several formatting options like Font type, Font Size, Bold, Italics, etc. along the toolbar. It should be noted that the Format tab and toolbar will also allow you to determine the alignment and text wrapping for text or data within a cell, column or row.
- Organize your data by sorting or filtering your data. Click on the Data tab to organize your data. You can choose a named range for your data for easier reference.
- You can perform mathematical functions. The ability of Google Sheets to perform calculations is one of its more useful functionalities and capabilities. Functions can be found under the Insert tab at the far, righthand side of your toolbar. Click the toolbar button to reveal several commonly used functions such as SUM, IF, AVERAGE, SUMIF, COUNT etc.
Google Sheets is very flexible such that it allows you to add a new row or column to a specific location. All you need to do is to select any cell contained within that location and click the Insert tab from the toolbar. This will give you the option to either insert rows or columns above or below and to the right or left of the selected cell.