The Google Sheets Getting Started Guide

Introduction

A cloud-based program me called Google Sheets offers robust and quick online spreadsheets. Your team may use charts and filters to evaluate data, browse task lists, and build project plans from any online device thanks to the application’s collaboration and convenience features. I can. Every modification is automatically saved in one location. You can create, edit, and collaborate with Google Sheets from any location.

Exercise Type

In this lab you will use Google Sheets to:

Make, customize, and update spreadsheets
analysis of data
Give a spreadsheet away
From Sheets, use other applications

Arrangements and conditions

Earlier than pressing the Start Lab button.

Please read the following instructions. Time in the lab is recorded and cannot be stopped. When you click Start Lab, a timer that counts down from that point shows when Google Cloud services are accessible.

Instead of using a simulation or demo environment, this Qwiklabs hands-on lab enables you to carry out the lab tasks on your own using a genuine cloud environment. As a result, you will be given fresh temporary login information to use while completing the lab.

Things Essential

You’ll need the following to finish this lab:

conventional Internet browser (Chrome is recommended)
sufficient time to finish the lab.

Note: Despite the fact that you may already have a personal Google Cloud account and projects, kindly refrain from using them in the lab.

Note: To run this experiment on a Chrome OS device, launch an incognito window.

Start a lab

Click Start Lab in the top left panel when you are ready.

Verify the lab user’s email and password.

To access the tools and consoles used in the lab, verify your user email and password in the left panel. The login information for Google Drive is as follows.

This panel will show any additional resource ID or connection-related information that the lab requires.

Register with Google Sheets

Click Google Sheets to open it.

Tip: Keep all open tabs side by side in separate windows.

Enter your password and user email.
As directed, accept all terms and conditions.

I went into my student Google account and a Google Spreadsheet launched.

Task 1.Open the illustration spreadsheet

Follow these steps to open the sample spreadsheet:

A example spreadsheet can be opened by clicking Explore this data.
Create a copy. Choose File > Make a Copy.
Click Make a copy after leaving the Name and Folder fields’ default values alone.

Make sure you’re on track with your objectives by monitoring your progress.

Data exploration with spreadsheets

The procedures below will allow you to use Google Sheets to examine your data:

To access the Data Exploration panel, click Data Exploration in the lower right corner of the spreadsheet.
Enter the following inquiries in the Ask questions about this data field of the Answers section.

department with the greatest actual sum
How many distinct departments

Let’s pose some original queries to explore what data Google Sheets can offer.

Exporting data

For use in the lab later, export the spreadsheet data to your local device.

Choose File > Download > Comma Separated Values (.csv) from the menu.
To close this spreadsheet, close the browser tab.
If the original spreadsheet titled “Explore this data (budget request by department)” is still open, close it as well.

In the remaining tabs or windows, only the Google Sheets and the lab instructions should be open.

Locate and rename the.csv file you downloaded to your local computer to “exported-data.”

Task 2. Bring the spreadsheet in

Simple conversion to Google Sheets after data import from another spreadsheet.

In order to build a new spreadsheet, you must import the data you exported in the previous step exported-data.csv into Drive and open the file in Google Sheets.

Open Google Drive in a new tab on your browser.
The top left menu will change to New > File Upload.
Choose exported-data.csv to upload to the drive on your local computer.

You can also drag the csv file from your local computer to the drive as an alternative.

exported-data.csv To convert to Google Sheets, follow these steps:

Right-click on the drive and choose exported-data.csv.
Select Google Sheets under Open with.

A copy of the original spreadsheet in Google Sheets format is made when importing or converting a spreadsheet. In your browser, you can modify this new file just like any other Google Sheet.

If you have other kinds of spreadsheets, you might try importing them into Drive and converting them to Google Sheets.

You can amend a spreadsheet that was originally published to Drive as Microsoft® Excel® without switching to Google Sheets.

Make sure you’re on track with your objectives by monitoring your success.

Task 3. Create a spreadsheet of your own

This section includes:

data entry and editing
Make your spreadsheet unique.
Utilize rows, columns, and cells.
Take care of several sheets

You can make your own spreadsheet.

Set up a fresh spreadsheet.

Go back to the My Drive tab in the browser.
Select Google Sheets by clicking the Google app icon.
To build a new template, click the plus sign in the Create a new spreadsheet area.

Modify and enter data

Change the spreadsheet’s name: Enter the important-data name and then select Untitled Spreadsheet.
Data and header row entered: Click outside the cell after entering content into a cell by clicking there first.

Example of a spreadsheet

The figures in column C of the spreadsheet sample above have a currency format applied, as you can see. Follow these steps to accomplish this:

Choose column C.
From the menu bar, select Format > Number > Currency.

Add other items: To add graphs, photos, drawings, functions, notes, and more, click Insert.
(Optional) In order to evaluate your spreadsheet, use data exploration.

Use the findings of the analysis.
Incorporate a pie chart into your spreadsheet if you can.

Create a customised spreadsheet.

Let’s utilise the spreadsheet we made in the section before. In your spreadsheet, choose a cell and format it using the choices on the toolbar.

Utilise rows, columns, and cells.

Add columns, rows, or cells by choosing a single cell or a group of cells. Choose where to add rows, columns, and cells by clicking the Insert button on the menu bar.
Eliminate or conceal columns and rows: Click the row or column letter with the right mouse button, then click Delete or Hide.
Remove one cell or a group of cells: Choose the cells that you want to remove. Select Edit. Use Edit > Delete Cell and Move Existing Cell Left to delete a cell and move an existing one up.
Move columns and rows by clicking a row number or a column letter. Drag columns or rows into new positions.
Keep certain data in the same location while scrolling through the rest of your spreadsheet by freezing the header rows and columns. Select an option by clicking View > Freeze in the menu bar.

Take care of several sheets

Double-click Sheet1 at the bottom of your spreadsheet.
Once Overview is highlighted, give it a new name of ” “.

Adding sheets:

To add a new sheet, click Add Sheet (+) at the bottom of the spreadsheet.
The sheet is titled “Detail.”

To duplicate a sheet:

Click the down arrow for at the bottom of the spreadsheet’s detail row.
Select Create a copy.

To eliminate a sheet:

Click the down arrow for at the bottom of the spreadsheet’s Detail section. Choose Delete.
To confirm, click OK.

Check your progress to make sure you’re moving toward your targets.

Task 4. Exchange and Cooperate

Spreadsheets can be shared with team members or anyone outside of your organisation. Multiple users can edit documents simultaneously and see each other’s changes as they happen thanks to collaborative editing.

This paragraph includes:

Sharing your spreadsheet
Quit distributing your spreadsheet.
Add responses and comments
Interact with users directly

Send your spreadsheet.

To assign particular users access to a file or folder:

Only files that you own or have access to change can be shared.

important-data Select Share in the top right corner of the same file in Google Sheets.
Under Share with People and Groups, enter the email addresses of the people or groups you want to share the file with.
The email addresses of the individuals or groups you wish to share the material with should be entered under Share with People and Groups.

Contributors have the ability to add, modify, and add comments to content.
Viewer (may offer feedback) (only for files): Participants may leave comments but cannot change the text.
Viewer: Viewing only; no editing or adding of comments.

Click “Submit.”

An email containing a link to the file or folder will be sent to each person you share with.

(Optional) To add a note to your email, enter a note. If you don’t want to send an email, clear the Notification checkbox.

To send a file or folder link:

Anyone who receives a link to a file or folder that you have shared with other users will be able to open that file or folder. Keep in mind that you will be listed as the owner of a link when you share it.

Only files that you own or have access to change can be shared.

Select Share in the top right corner of your spreadsheet.
Select Qwiklabs from Restricted by clicking it.
On the right side of Qwiklabs, select Viewer, then choose an access level.

Contributors have the ability to add, modify, and add comments to content.
Viewer (may offer feedback) (only for files): Participants may leave comments but cannot change the text.
Viewer: Viewing only; no editing or adding of comments.

4. Then select Copy link.

5. Select “Done.”

6. The URL may now be pasted into an email or another shared destination.