Google Apps: Sheets
Docs
Slides
Sheets
Drive
Drawings
Forms
Sheets
Create a Spreadsheet in Google Sheets
From within the Google Sheets application click the + icon in the lower right to create a new document.
A new Google Sheet spreadsheet appears in your browser—now you're ready to create.
Search for previously created spreadsheets
You can search for a specific spreadsheet that you've created by typing into the search bar and hitting enter.
Google Sheets will search the titles and content of all of your spreadsheets for matching results.
Share and collaborate
Google Sheets lets you easily collaborate with others on spreadsheets in real time.
To get started, open the sheet you want to collaborate on and click Share. You will find the share button in the upper-right hand corner of the sheet.
Enter the email addresses of the people you want to share with. You can also search for contacts by entering them in the box.
Select Can edit.
Click Done. The individuals or groups will receive an email letting them know you’ve shared the file with them.
You can work at the same time, or individually, but all changes made to a Google Sheet are saved and displayed whenever you open your spreadsheet.
To track changes to a document choose File > See Revision History
For more on Sharing and Collaboration See Google Sheets Helps for Sharing and Collaboration.
Download Google Sheet spreadsheets as Microsoft Excel files or PDF documents
Open a document.
Choose File > Download as from the Google Sheets file menu.
Click on one of the file types available in the drop-down menu.
Choose the location on your computer to save the document.
Click Save.
Upload a Google Sheet as an Assignment Submission
Open an assignment page from your course home page.
Click Add Submission at the bottom of the assignment page.
Click the Add document button
Click on Google Drive (The login credentials to your LAPU Google email will be required)
Search and Select File
Click Select this file
Click Save Changes
Upload a Google Sheet as an Assignment Submission with a Mobile Device
Open an assignment page from your course home page.
Click Add Submission at the bottom of the assignment page.
Click the Add document button
Click on Google Drive (The login credentials to your LAPU Google email will be required)
Search for and select a file
Click Select this file
Click Save Changes
Other
Organize your Google Sheet files in Google Drive
The Google Sheets list can grow exponentially if you use it to create your spreadsheets for class. You can use Google Drive to organize and file all your various Google Documents, Sheets, Presentations, and Drawings.
Insert a Google Drawing into your Google Spreadsheet.
You can use Google Drawing to create graphics for your Google spreadsheet. While inside of a spreadsheet:
On the main menu choose Insert > Google Drawing.
Use the menu bar to upload an image or add text, lines, or shapes to create your drawing.
Once you have completed your "drawing," click Save and Close in the upper-right hand corner.
Your new Google Drawing has been added to your document.
Help with creating formulas in Google Sheets
Use the following resources to help you with creating formulas in Google Drive