Introduction to Google Sheets
1. Introduction to Google Sheets
Welcome to module 1, Introduction to Google Sheets. Google Sheets is an online spreadsheet program included as part of Google Workspace. In this module, you'll get an introduction to Google Sheets and learn how to open and create a new spreadsheet. We'll also look at how to import an existing spreadsheet into Google Sheets. Google Sheets is a powerful tool for storing, analyzing, and presenting data. You can share your spreadsheets with anyone and edit in real time with collaborators anywhere in the world. With Sheets, you can open, edit, and convert Microsoft Excel files, and your files can be exported into other formats, so you always have access to your information. There are several ways you can create a new spreadsheet in Google Sheets and work with existing spreadsheets. To create a new spreadsheet, navigate to sheets.google.com. This page displays your spreadsheets exclusive of other types of files. Click the plus icon and choose Create New Spreadsheet. If you're already working in a spreadsheet and need to create a new one, navigate to the file menu, hover over New, and choose Spreadsheet. However, the quickest way to create a new spreadsheet is to type sheets.new into your browser address bar. If you haven't already done so, Open Google Sheets by visiting sheets.google.com. Google Sheets spreadsheets are stored in Google Drive. Google Drive is cloud storage for your files. To create a new spreadsheet from Google Drive, select New and choose Google Sheets. A new blank spreadsheet will open in a new browser tab. Your spreadsheets are automatically saved in your My Drive. While you're in Google Drive, if you hover over the arrow next to Google Sheets in the menu, you can also choose to create a spreadsheet from a template. A template is a spreadsheet that's already been formatted for a purpose like an invoice, a timesheet, or expense report. The template gallery shows both general templates provided by Google and your organization's templates, which were submitted by your colleagues and may be more relevant to your workflow. A spreadsheet can be submitted to the template gallery for use by others in your organization. If you have spreadsheets that were created in Microsoft Excel, you can upload them to Google Drive for editing with Google Sheets. You can choose to keep a spreadsheet in the Microsoft Excel format or convert it to Google Sheets. Converting it enables the full capabilities of Google Sheets. Regardless of how you create your spreadsheet, as you edit it, your changes are automatically saved with the history of all the changes by you and any collaborators, so you never lose a keystroke. To name your spreadsheet, select Untitled Spreadsheet and type a name. While you're editing the name, the location of the spreadsheet in Google Drive will be visible next to it. Select it to move your spreadsheet to another location in Google Drive. For fast access to a particular spreadsheet, you can add it to your starred list in Google Drive. Select Star to add a spreadsheet to your starred list. Select See Document Status to check whether your changes have been saved and whether the file is available for offline access. If offline access is not enabled for your Google Drive, you can turn it on from the See Document Status dialog. Once offline access is enabled, you can select File and then Make Available Offline to make a specific file available for viewing and editing offline.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.