Podcast
Questions and Answers
Collaborate in real-time from ______
Collaborate in real-time from ______
Sheets
Share using ______ for the web or a shared workbook
Share using ______ for the web or a shared workbook
Excel
Save automatically using ______ or OneDrive
Save automatically using ______ or OneDrive
SharePoint
Add formulas and use ______ AutoComplete for suggestions
Add formulas and use ______ AutoComplete for suggestions
Signup and view all the answers
Record macros or use ______ Apps Script
Record macros or use ______ Apps Script
Signup and view all the answers
Create filters and ______ views
Create filters and ______ views
Signup and view all the answers
Set notifications in ______
Set notifications in ______
Signup and view all the answers
In Chrome Browser, in the top-right corner next to the address bar, click your ______ image
In Chrome Browser, in the top-right corner next to the address bar, click your ______ image
Signup and view all the answers
With Google ______, you can create and edit spreadsheets directly in your web browser—no special software is required.
With Google ______, you can create and edit spreadsheets directly in your web browser—no special software is required.
Signup and view all the answers
Create and name your ______, Sheets, Slides, or Forms.
Create and name your ______, Sheets, Slides, or Forms.
Signup and view all the answers
You can import and convert an existing spreadsheet to ______, Sheets, or Slides.
You can import and convert an existing spreadsheet to ______, Sheets, or Slides.
Signup and view all the answers
In the Upload complete window, click Show file location and then right-click the file and select Open with Google ______/Sheets/Slides.
In the Upload complete window, click Show file location and then right-click the file and select Open with Google ______/Sheets/Slides.
Signup and view all the answers
Learn the differences between Microsoft Excel and Google ______, and get best practices for collaboration at work or school.
Learn the differences between Microsoft Excel and Google ______, and get best practices for collaboration at work or school.
Signup and view all the answers
You can ______ spreadsheets from Google Sheets.
You can ______ spreadsheets from Google Sheets.
Signup and view all the answers
You can get ______ productivity tips for Google Sheets.
You can get ______ productivity tips for Google Sheets.
Signup and view all the answers
Microsoft Excel and Google ______ have many similar features and important differences.
Microsoft Excel and Google ______ have many similar features and important differences.
Signup and view all the answers
Study Notes
Google Sheets Basics
- Google Sheets allows users to create and edit spreadsheets directly in their web browser, without requiring special software.
- Multiple people can work on a spreadsheet simultaneously, and all changes are saved automatically.
Creating a New Spreadsheet
- To create a new spreadsheet, open a Google Docs, Sheets, Slides, or Forms home screen and click "Create".
- You can also create a document from a template or import an existing spreadsheet from another program.
Importing and Converting Existing Spreadsheets
- To import an existing spreadsheet, go to Google Drive, click "New File Upload", and choose the file to upload.
- Once uploaded, right-click the file and select "Open with Google Sheets" to edit it in your browser.
Switching from Excel to Sheets
- Google Sheets and Microsoft Excel have similar features, but also important differences.
- Switching to Sheets enables real-time collaboration and automatic saving to Drive.
Key Differences between Excel and Sheets
- Collaboration: Sheets allows real-time collaboration, while Excel requires a shared workbook or SharePoint/OneDrive.
- Saving: Sheets saves automatically to Drive, while Excel requires manual saving to SharePoint or OneDrive.
- Formulas: Sheets provides formula suggestions as you type, while Excel has Formula AutoComplete.
- Macros: Sheets uses Google Apps Script, while Excel uses VBE.
- Filters: Sheets creates filters and filter views, while Excel creates filters.
- Pivot tables: Sheets creates pivot tables manually or automatically with Explore, while Excel requires manual creation.
- Charts: Sheets creates charts manually or automatically with Explore, while Excel creates charts manually.
- Notifications: Sheets set notifications, while Excel sets notifications in OneDrive.
Accessing Google Sheets
- Google Sheets can be accessed through a web browser at sheets.google.com, Google Drive, or most Google pages.
- The Sheets app is available for Android and iOS devices, and can be added as a browser bookmark or desktop shortcut (Windows only).
- Offline work is possible with Chrome only.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Learn how to create and edit spreadsheets online with Google Sheets, a web-based application that allows real-time collaboration and automatic saving.