Lesson Objective:

To introduce learners to Google Sheets, show how to use it for data entry, formatting, calculations, and collaboration.

What is Google Sheets?

Google Sheets is a free, web-based spreadsheet tool that allows users to create and manage data in table form. It is useful for working with numbers, making lists, and performing calculations. Like Google Docs, it supports real-time collaboration and automatic saving.

How to Access Google Sheets

• Go to https://sheets.google.com or open from Google Drive

• Log in with your Google Account

• Click on the “+ Blank” button to start a new spreadsheet

• Alternatively, use a template such as a budget or to-do list

Basic Features and How to Use Them

1. Navigating the Interface

• Rows are numbered horizontally; columns are labeled alphabetically

• Each cell is the intersection of a row and a column (e.g., A1, B2)

• Use the formula bar at the top to enter data or formulas

2. Entering and Formatting Data

• Click any cell to start typing (text, numbers, dates)

• Use the toolbar to format: bold, italics, font size, color, alignment

• Use “Merge cells” to combine multiple cells

• Apply borders and background colors for better readability

3. Working with Formulas and Functions

• Start formulas with an equals sign (=)

• Use basic functions like:

  • =SUM(A1:A5) to add numbers

  • =AVERAGE(B1:B5) to calculate the mean

  • =IF(C1>50, "Pass", "Fail") for logical decisions

• Auto-fill by dragging the bottom-right corner of a cell

4. Sorting and Filtering Data

• Select the data range and click Data > Sort Range to sort by columns

• Use Filter to display only specific data (e.g., by name, score, date)

5. Creating Charts and Visuals

• Select data, then click Insert > Chart

• Choose chart types: column, line, pie, etc.

• Customize charts with labels, colors, and titles

6. Sharing and Collaborating

• Click Share and enter email addresses

• Set permissions: Viewer, Commenter, or Editor

• Use the Comment feature to leave feedback without changing data

• Changes are saved in real time and tracked under File > Version History

Tips for Beginners

• Always name your spreadsheet (top-left corner)

• Use tabs (sheets) at the bottom for organizing different sets of data

• Explore the Explore button (bottom-right) for quick insights and chart suggestions

• Learn shortcuts (e.g., Ctrl + / to view available shortcuts)