-->

10/3/20

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.

Advertiser

all right reserved @technicalkeeda.in. Powered by Blogger.