Skip to main content

how to use google spreadsheet | Learn google spreadsheet for free | google spreadsheet complete beginner guide

Google spreadsheetis a hugely powerful tool, for everything from digital marketing to finance modeling, from project management to statistical analysis, in fact, just about any activity involving the recording and analysis of data.

What is google spreadsheet? 

Google Sheets is a free, cloud-based spreadsheet application. That means you open it in your browser window like a regular webpage, but you have all the functionality of a full spreadsheet application for doing powerful data analysis. It really is the best of both worlds.
With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.
google spreadsheet complete beginner guide




is it different from Excel?

Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” Each cell contains one point of data or one piece of information.
Google spreadsheet is similar in many ways, but also distinctly different in other areas. It has (mostly) the same set of functions and tools for working with data. In fact, some people mistakenly call it “Google Excel” or “Google spreadsheets.”

  • Google Sheets is cloud-based whereas Excel is a desktop program.
  • Both have charting tools and Pivot Table tools for data analysis
  • Excel can handle much bigger datasets than Sheets, which has a limit of 2 million cells.

Why should we use Google spreadsheets ?

  • connecting to External Data Sources.
  • Working with Plugins.
  • Linking Between Sheets in Different Files.
  • Creating Charts and Linking to Google Slides.
  • Working at Scale.
  • Data safety.
  • Easy data transfer.

How to create first Google spreadsheet-

for creating your first Google spreadsheet go to official
l website of google follow link below -https://www.google.com/sheets/about/

Click on the Go To Google Sheets button in the middle of the screen. You’ll be prompted to login.
login from your google account.

how to create google spreadsheet

follow the steps mentioned in the image.

Google Sheet editing window-

google spreadsheet complete beginner guide


How to edit data in a  cell

  1. Open a spreadsheet in Google Sheets.
  2. Click a cell that’s empty, or double-click a cell that isn’t empty.
  3. Start typing.
  4. Optional: To add another line within a cell, press ⌘ + Enter on a Mac or Ctrl + Enter on Windows.
  5. When you’re done, press Enter.


How to Format one or more cells

  1. Open a spreadsheet in Google Sheets.
  2. Click a cell, then drag your mouse across nearby cells you want to select, or hold ⌘ on a Mac or Ctrl on Windows and click another cell.
  3. To format text or numbers in a cell, use the options in the toolbar at the top.

Here are some options for formatting your cells or text. You can find these options above the document.

  •  Undo
  •  Redo
  •  Bold
  •  Italic
  •  Strikethrough
  • Change font or font size
  •  Change text color
  •  Change cell fill color
  1. Single color
  2. Alternating colors
  •  Change cell borders
  1.  Change border color
  2.  Change border style
  •  Merge cells
  • Change horizontal text alignment
  • Change vertical text alignment
  • Rotate text in a cell
  •  Wrap text in a cell

To format part of the text or content in a cell, double-click the cell, select what you want to format, then select a formatting option.


How to add one row, column, or cell 

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row, column, or cell.
  3. Right-click the row, column, or cell.
  4. From the menu that appears, select Insert 1 left, right, above or below.

Add more than one row, column, or cell

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Highlight the number of rows, columns, or cells you want to add. To highlight multiple items:
    • Mac: ⌘ + click the rows or columns. 
    • Windows: Ctrl + click the rows or columns
  3. Right-click the rows, columns, or cells.
  4. From the menu that appears, select Insert [Number] or Insert cells. For example, highlight 5 rows, right-click the row header, and then select Insert rows.

To add 100+ rows to your spreadsheet:

  1. On your spreadsheet, scroll to the bottom.
  2. Next to "more rows at the bottom," enter the number of rows you’d like to add.
  3. Click Add.

Change Hieght and weight of column and row-

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row or column to resize. To highlight multiple rows or columns:
    • Mac: ⌘ + click the rows or columns
    • Windows: Ctrl + click the rows or columns
  3. Right-click the row number or column letter.
  4. Click Resize row or Resize column. Then, choose an option:
    • Enter a custom height or width
    • Fit to data
  5. Click OK.

You can also drag the edge of a row or column to resize it or double-click the row or column edge to fit to data.


How To delete row in google spreadsheet-

  1. From the menu that appears, choose Delete row, Delete column, or Delete cell.

How Freeze or merge rows & columns-

  1. Select a row or column you want to freeze or unfreeze.
  2. At the top, click View >Freeze.
  3. Select how many rows or columns to freeze.

To unfreeze, select a row or column. Then, at the top, click View  > Freeze  > No rows or No columns.


How to Protect, hide, and edit sheets-

If you don’t want people to change the content in a spreadsheet, you can protect it. This shouldn’t be used as a security measure. People can print, copy, paste, and import and export copies of a protected spreadsheet. Only share spreadsheets with people you trust.
google spreadsheet guide

How to Add an image to a spreadsheet-


  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the cell where you want to add an image.
  3. Click Insert > Image. 
  4. Select to place your image in the cell or over the the cells. Cells with an image cannot also have text.
  5. Choose an image or take a snapshot.
  6. Click Open or Select.

How to sort columns in google spreadsheet-

On your computer, open a spreadsheet in Google Sheets. At the top, right-click the letter of the column you want to sort by. Click Sort sheet by A to Z or Sort sheet Z to A.

Hopefully, I have cleared some basic concept of google spreadsheets and I think you learnt how to use google spreadsheets.Though there are many other features of google spreadsheet but these features are more than enough for the beginner you can work with these features. Once you start working on google spreadsheets you will explore more options of google spreadsheets.

Thanks stay connected with us.

Comments

Popular posts from this blog

Vaccine Distribution Codechef December Long challenge solution 2020

 Vaccine Distribution  Codechef December Long challenge solution 2020- This Problem vaccine distribution is taken from December long challenge 2020. lets read problem statement. Problem statement- Finally, a COVID vaccine is out on the market and the Chefland government has asked you to form a plan to distribute it to the public as soon as possible. There are a total of  N N  people with ages  a 1 , a 2 , … , a N a 1 , a 2 , … , a N . There is only one hospital where vaccination is done and it is only possible to vaccinate up to  D D  people per day. Anyone whose age is  ≥ 80 ≥ 80  or  ≤ 9 ≤ 9  is considered to be  at risk . On each day, you may not vaccinate both a person who is at risk and a person who is not at risk. Find the smallest number of days needed to vaccinate everyone. Input The first line of the input contains a single integer  T T  denoting the number of test cases. The description of  T T  test cases follows. The first line of each test case contains two space-separ

Codechef February long challenge solution 2021

   Codechef February  long challenge solution 2021- Hey guys Welcome Again, A small update CodeChef February  long challenge solution 2021 starting from 1st week of beb  2021 . Codechef long challenge is one of the popular contests of CodeChef you should participate in codechef Feb  long challenge.This is first contest of codechef in 2021 so good luck. And wish you happy new year. Contest link- https://www.codechef.com/FEB21/?itm_medium=navmenu&itm_campaign=FEB21 I will post the solution after Contest.Stay tuned. About CodeChef  February  long challenge solution 2021: CodeChef Long Challenge is a 10-day monthly coding contest where you can show off your computer programming skills. The significance being - it gives you enough time to think about a problem, try different ways of attacking the problem, read the concepts etc. If you’re usually slow at solving problems and have ample time at hand, this is ideal for you. We also put in a lot of efforts in getting quality problems, w

Merge Two sorted array Without Extra Space

Problem statement-  Given two sorted arrays arr1[] and arr2[] of sizes N and M in non-decreasing order. Merge them in sorted order without using any extra space. Modify arr1 so that it contains the first N elements and modify arr2 so that it contains the last M elements.    Example 1: Input:  N = 4, arr1[] = [1 3 5 7]  M = 5, arr2[] = [0 2 6 8 9] Output:  arr1[] = [0 1 2 3] arr2[] = [5 6 7 8 9] Explanation: After merging the two  non-decreasing arrays, we get,  0 1 2 3 5 6 7 8 9.   Example 2: Input:  N = 2, arr1[] = [10, 12]  M = 3, arr2[] = [5 18 20] Output:  arr1[] = [5 10] arr2[] = [12 18 20] Explanation: After merging two sorted arrays  we get 5 10 12 18 20. Your Task: You don't need to read input or print anything. You only need to complete the function merge() that takes arr1, arr2, N and M as input parameters and modifies them in-place so that they look like the sorted merged array when concatenated. Expected Time Complexity:  O((n+m) log(n+m)) Expected Auxilliary Space: O(1