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

codeforces rating system | Codeforces rating Newbie to Legendary Grandmaster

 Codeforces rating system | Codeforces rating Newbie to Legendary Grandmaster- Codeforces is one of the most popular platforms for competitive programmers and  codeforces rating matters a lot  .  Competitive Programming  teaches you to find the easiest solution in the quickest possible way. CP enhances your problem-solving and debugging skills giving you real-time fun. It's brain-sport. As you start solving harder and harder problems in live-contests your analytical and rational thinking intensifies. To have a good codeforces profile makes a good impression on the interviewer. If you have a good  codeforces profile so it is very easy to get a referral for product base company like amazon, google , facebook etc.So in this blog I have explained everything about codeforces rating system. What are different titles on codeforces- based on rating codeforces divide rating into 10 part. Newbie Pupil Specialist Expert Candidate Codemaster Master International Master Grandmaster Internat

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

Apple Division CSES Problem Set Solution | CSES Problem Set Solution Apple division with code

 Apple Division CSES Problem Set Solution | CSES Problem Set Solution Apple division with code - Apple Division CSES Problem Solution Easy Explanation. Apple division is problem is taken form cses introductory problem set.Let's Read Problem statement first. Problem Statement- Time limit:  1.00 s   Memory limit:  512 MB There are  n n  apples with known weights. Your task is to divide the apples into two groups so that the difference between the weights of the groups is minimal. Input The first input line has an integer  n n : the number of apples. The next line has  n n  integers  p 1 , p 2 , … , p n p 1 , p 2 , … , p n : the weight of each apple. Output Print one integer: the minimum difference between the weights of the groups. Constraints 1 ≤ n ≤ 20 1 ≤ n ≤ 20 1 ≤ p i ≤ 10 9 1 ≤ p i ≤ 10 9 Example Input: 5 3 2 7 4 1 Output: 1 Explanation: Group 1 has weights 2, 3 and 4 (total weight 9), and group 2 has weights 1 and 7 (total weight 8). Join Telegram channel for code discussi