Introduction to Google Sheets

Introduction to Google Sheets

What is a Spreadsheet? 

  • A spreadsheet is a digital tool used to organize, analyze, and manipulate data. 
  • It consists of rows and columns, intersecting at points called cells. 
  • Each cell can hold text, numbers, dates, or formulas. 

Parts of a Spreadsheet 

  • Worksheet: A single sheet within a spreadsheet. 
  • Workbook: A collection of worksheets. 
  • Cell Reference: The address of a cell, specified by its column letter and row number (e.g., A1). 
  • Cell Range: A group of cells, indicated by the starting and ending cell references (e.g., A1:B5). 

Basic Data Types 

  • Text: Any combination of letters, numbers, and symbols. 
  • Numbers: Numerical values used for calculations. 
  • Dates: Represent specific points in time. 
  • Formulas: Perform calculations or manipulate data. 

Entering Data 

  • Click on a cell to make it active. 
  • Type the desired data into the cell. 
  • Press Enter or Tab to move to the next cell. 

Formatting Cells 

  • Select the desired cells. 
  • Use the formatting toolbar to change font, size, color, alignment, and number format. 
  • Apply conditional formatting to highlight cells based on specific criteria. 

Autofill 

  • Enter data in a few cells. 
  • Select the range of cells. 
  • Drag the small square at the bottom right corner of the selection to autofill. 

Navigating the Spreadsheet 

  • Use the scroll bars to move vertically and horizontally. 
  • Click on sheet tabs to switch between worksheets. 
  • Use keyboard shortcuts (Ctrl+Tab, Ctrl+Shift+Tab) to navigate between sheets. 

Saving and Sharing 

  • Click “File” -> “Save” to save the spreadsheet. 
  • Use the “Share” button to grant access to others. 

Undo and Redo 

  • Use Ctrl+Z to undo the last action. 
  • Use Ctrl+Y or Ctrl+Shift+Z to redo the last undone action. 

Introduction to Google Sheets Video Example

Scroll to Top