Google Docs Spreadsheet Tutorial Pdf
Quick Guide for Google Docs Spreadsheets. If a member of your group does not already have a Google account, one person will need to create one. The account is free, and many school districts are encouraging the use of free online software to reduce costs. If your district or school uses other spreadsheet software, you. Apr 24, 2012 - basics that apply specifically to Google Docs spreadsheets. Create a spreadsheet. From Google Drive (or your Docs list if Drive is not yet enabled), click the Create button and select. Tip: Don't forget to rename your new spreadsheet. To do so, just click the name (which should be “Untitled.
Google Docs Tutorial. Excel spreadsheet or PDF. Either as is or in Google Docs format. Google Drive serves as a good file backup system.
Beginning in the 1980s, Microsoft held the business productivity software and tool market in the palm of its hand with the Microsoft Office suite. Along with the now-discontinued Lotus 1-2-3, Microsoft Excel defined and shaped the spreadsheet category as we know it today. In the 2000s, rapid business adoption of cloud technologies and services paved the way for Google Docs, a free alternative to Microsoft Office, which includes the Google Sheets spreadsheet application. While it’s easy to access from anywhere, it’s not always easy to use. This article will offer an in-depth tutorial on using Google Sheets with insight and advice from noted experts, along with visual guidance to help you understand key steps.
We’ll also help demystify some of the most common questions users have about Google Sheets. Let’s get started. Why Choose Google Sheets Over Excel? Given that Google sheets is a relative newcomer to the spreadsheet product category, it’s helpful to look at the reasons users initially try and eventually choose it over an established offering like Excel. First and foremost, it’s free: You will never need to purchase any software licenses, pay any subscription fees, or hire an IT consultant to configure, deploy, or maintain it. Note: Sheets is also included in Google’s G Suite, which is a subscription-based service for businesses. Easy collaboration: It’s easy to share files, and users can all work on the same spreadsheet simultaneously.
To contact a collaborator, either chat live within a spreadsheet, or leave a comment for review. It’s cloud-based: Because files can be edited, viewed, and shared by users anytime and from any device, Google Sheets provides a “single version of the truth” to help avoid communication or version-control issues among collaborators and teams.
Importing data is easy: Pull in information from other Google services, or directly from the web. Running scripts is simple: Use Java-based Google Apps Scripts and easily connect to APIs. Reference previous revisions with one click: Find out which users have edited a file, along with the edits each has made. It works with Excel: Google Sheets lets users open Excel files, and convert them to Google Sheets, and vice versa. Sharing and Collaborating with Folders 1. To share a Google Drive folder with a collaborator, right-click on the folder. Select Share from the dropdown menu.
The Share with others dialog box appears. Type the name(s) of people already in your Gmail address book or email address(es) of the person(s) you want to share the folder with. You can add a note in the field provided, as well. Click the blue Done button to share the folder.
To turn on Link Sharing and send links to documents and folders, click Get shareable link in the top right corner of the dialog box. Google Spreadsheets 101 Now let’s look at the basics of working with spreadsheets. We’ll examine the following core tasks:.
Google Docs Spreadsheet Tutorial
Inserting, deleting, and moving rows and columns. Editing and formatting cells.
Working with files. Using data with spreadsheets. Getting the most out of formulas and functions Inserting and Removing Columns and Rows Open a Google spreadsheet that you want to use. To insert a column or row: 1. Click to select the row or column, or click and hold to highlight multiple areas.
Right-click anywhere on the highlighted area to launch the menu. Click Insert. To remove a row or column: 1.
Click to select the row or column, or click and hold to highlight multiple areas. Right-click anywhere on the highlighted area to launch the menu. Select Delete column, or Delete row. How to Freeze and Unfreeze Columns and Rows Freezing panes, rows, or columns allows you to view those cells while you scroll and tab around within a worksheet.
To freeze a column or row: 1. Click the cells you want to freeze to highlight them. Click the View menu at the top of the sheet. Click Freeze. Click the menu option for the column(s) or row(s) you want to freeze. To unfreeze a column or row: 1. Click the cells you want to unfreeze to highlight them.
Click the View menu at the top of the sheet. Click Freeze. Choose No columns or No rows.
How to Edit and Format Cells in Google Sheets It’s easy to edit content in a Google Sheets cell and format the display to fit your needs. Once you have copy in a cell, you can edit format, font, size, highlights, and more by highlighting the copy and clicking the relevant option from the toolbar along the top of the Sheets page. To edit cells: 1.
To add content to an empty cell, click to select the cell and begin typing. To edit content already in a cell, double-click the cell to add, change, or remove information. The content in a selected cell also appears in the blank row between the toolbar and lettered rows, so you can also click into that field to edit content.
Sign In
To format cells: 1. Click to select the cell, or click and drag your cursor to select multiple cells. Click the Format menu and click the formatting option you want. You can also click a formatting option in the toolbar located at the top of the spreadsheet. Tip: Hover over each formatting option with your cursor to reveal its function. How to Use the Google Sheets Mobile App The Google Sheets mobile app makes it easy to access your spreadsheet files at any time, from any location, using your smartphone or tablet—even while offline.
Download the Google Sheets Mobile app from the (iOS) or (Android). Once the app is installed on your device and you’ve signed into your Google account, you can get started. How to Open and Use a Spreadsheet File in the Mobile App Note: These instructions are for iOS devices. Launch the Google Sheets app.
Tap a spreadsheet file to open it. Tap the line or cell to select and modify. Tips and Tricks from a Google Sheets Expert We asked Matthew Guay, co-author of, for some insider tips on using Google Sheets. His favorite little-known shortcut involves Google Forms, which was previously part of Google Sheets, but is now a standalone polling and data analysis app. “Using Google Forms, you can create a form and have it save responses automatically to Google Sheets,” says Guay. “Google Sheets on its own is pretty powerful, with logic jumps, a tool to make self-grading quizzes, and collaboration tools to let others help you make a form. But when linked to your Google Sheets spreadsheet, it can email you a summary of the results every day.” The Simplest Way to Learn from Data According to Guay, another great tip is using the new ‘Explore’ tab in Google Sheets.
Spreadsheets
“It's the simplest way to ‘learn’ from your data,” he says. “Fill your spreadsheet with data you want to analyze, and click the Explore button in the bottom right side of Sheets. It'll pull out quick facts from the data (largest and smallest values, etc.), make charts that seem to fit the data, and more. It's a super-cool new tool that's perhaps the best reason to use Sheets right now!” Offline Editing Another favorite of Guay’s is Offline Editing, which enables users to edit sheets when offline. “Just install the Sheets add-on in Google Chrome or use the mobile app, and set it to store your sheets offline, just like in Excel or other apps,” he says.
Language and Finance Functions. Easily Import a Google Sheet into Smartsheet and Do More Smartsheet is a work management and automation platform that enables enterprises and teams to work better. Easily import a Google spreadsheet into Smartsheet and do more with the data: add hierarchy rows, prioritize columns, and resize and move images in Smartsheet. Additionally, use Smartsheet to run reports, create Gantt charts, and view the data in multiple flexible, intuitive ways like Calendar, Card View, Sights, and standard grid.
Once data from Sheets is imported into Smartsheet, you can assign tasks to team members and set automatic alerts and reminders so no task gets overlooked. Try one of the many free Google Sheet templates we have available. See how well Google Sheets and Smartsheet work together, so you can work the way you want.