Google Sheet Basics

Objective of the Video:

The video aims to provide a comprehensive understanding of the basic settings in Google Sheets, covering various aspects such as creating a sheet, navigating the interface, naming/renaming sheets, sharing, storage, importing from MS Excel, and spreadsheet settings.

Key Learnings from the Video:

1. How to Create Google Sheets?

• Open your Gmail account on your laptop or computer.
• In the “My Drive” section, click on the “9 dots” at the top right corner, then select “Sheets.” Alternatively, click on “New” in “My Drive,” then select “Google Sheets.”
• After selecting Google Sheets, click “Blank Spreadsheet” to create an “Untitled Spreadsheet.”

2. Google Sheets Interface

• Google Sheets, an online document resembling Microsoft Excel, is accessible via URL on any device.
• Tabs include File, Edit, View, Insert, Format, Data, Tools, Add-ons, and Help.

3. How to Name/Rename a Google Sheet?

• To name a newly created sheet, click on “Untitled Spreadsheet” and insert the desired name.
• Rename by clicking on the sheet name, deleting the previous name, and entering the new one.

4. How to Share a Google Sheet?

• Google Sheets has a “Share” button to share files with others.
• Save the sheet before sharing.

5. Storage

• Google Sheets automatically saves content; manual saving is unnecessary.
• Created sheets are saved in “My Drive” by default, visible on the homepage.

6. How to Import from MS Excel?

• Select “Import” under the “File” menu in Google Sheets.
• Click “Upload” or “drag and drop” to import an Excel file. Choose to create a new spreadsheet or replace an existing one.
• Click “Import Data.” Imported content, including colors, formulas, and formats, matches accurately.

7. Spreadsheet Settings

• Click on the “File” menu, then select “Spreadsheet Settings.”
• Under “General,” choose the country and time zone. The default is the United States; choose India and its time zone as needed.

Key Outcomes of the Video:

• Use the Google Sheets URL to open it on any device.
• Easily rename a Google Sheet.
• Seamlessly import data from MS Excel to Google Sheets.