Google Sheets Beginner Learning
Module
Module Overview
This module introduces learners to Google Sheets, a free, cloud-based spreadsheet tool used for
organizing, analyzing, and visualizing data. It also allows users to create, edit, and collaborate on
data in real time. Learners will explore its interface, core functions, and collaborative features,
with guided exercises to build confidence and practical skills managed data efficiently without
installing software.
Learning Objectives
By the end of this module, learners will be able to:
Understand the basic structure and interface of Google Sheets
Create, format, and manage spreadsheets
Use basic formulas and functions
Sort and filter data
Share and collaborate with others
Recognize the key differences between Google Sheets and Microsoft Excel
Appreciate the advantages of using a cloud-based spreadsheet tool
Google Sheets vs Microsoft Excel
Feature Google Sheets Microsoft Excel
Accessibility Web-based, works on any device Desktop-based, requires installation
Collaboration Real-time editing and commenting Limited unless using OneDrive
Auto-Save Yes (cloud-based) Manual or auto-save depending on setup
Cost Free Paid (part of Microsoft Office)
Offline Use Limited (requires setup) Full offline functionality
Advantages of Google Sheets
🌐 Cloud-Based: Access your files from any device
👥 Real-Time Collaboration: Work with others simultaneously
🔄 Auto-Save & Version Control: Never lose your progress
🔌 Integrations: Seamlessly connects with other Google apps
💸 Free to Use: No software purchase required
Google Sheets Beginner Module
Lesson 1: Introduction to Google Sheets
🧠 What You’ll Learn:
What Google Sheets is
How it compares to Microsoft Excel
How to access and create a spreadsheet
✅ Steps:
1. Open a browser and go to [Link]
2. Sign in with your Google account
3. Click Blank to create a new spreadsheet
4. Click on “Untitled Spreadsheet” at the top and rename it to “My First Sheet”
5. In cell A1, type your name
6. In cell B1, type today’s date
📝 Activity:
Create a simple table with your name, date, and favorite color in three columns.
Lesson 2: Navigating the Interface
🧠 What You’ll Learn:
Rows, columns, and cells
How to move around the sheet
How to rename and manage sheet tabs
✅ Steps:
1. Observe the grid: columns (A, B, C…) and rows (1, 2, 3…)
2. Click on cell A2 and type “1”
3. Press Enter to move down, type “2”, and continue to “5”
4. In column B (B2 to B6), type five fruit names
5. At the bottom, click the tab labeled “Sheet1” and rename it to “Fruits”
📝 Activity:
Create a list of five items with corresponding numbers and rename the sheet tab.
Lesson 3: Formatting Cells
🧠 What You’ll Learn:
How to change font styles, colors, and alignment
How to format numbers as currency, date, or percent
✅ Steps:
1. Select cells B2 to B6 (fruit names)
2. Click the Bold (B) icon in the toolbar
3. Change the font color of “Mango” to green using the Text color tool
4. Select cells A2 to A6 and click Format > Number > Currency
📝 Activity:
Format a list of items with bold text, colored fonts, and currency values.
Lesson 4: Basic Formulas
🧠 What You’ll Learn:
How to use basic formulas like SUM and AVERAGE
How to perform simple calculations
✅ Steps:
1. In cell C2, type =A2+A3 and press Enter
2. In cell C3, type =SUM(A2:A6) to add all numbers
3. In cell C4, type =AVERAGE(A2:A6) to find the average
📝 Activity:
Create a column of numbers and use formulas to calculate total and average.
Lesson 5: Sorting and Filtering
🧠 What You’ll Learn:
How to sort data alphabetically or numerically
How to filter data based on conditions
✅ Steps:
1. Select the range A2:B6
2. Click Data > Sort range > Sort by Column B (A to Z)
3. Click Data > Create a filter
4. Click the filter icon in column B and choose “Banana” to filter
📝 Activity:
Sort a list of items and apply a filter to show only selected entries.
Lesson 6: Charts and Visuals
🧠 What You’ll Learn:
How to insert charts (bar, pie, line)
How to customize chart titles and colors
✅ Steps:
1. Select your data range (e.g., A2:B6)
2. Click Insert > Chart
3. In the Chart Editor, choose Chart type (e.g., Bar chart)
4. Click Customize > Chart & axis titles to add a title like “Fruit Inventory”
5. Use Customize > Series to change colors
📝 Activity:
Create a chart based on your data and customize its appearance.
Lesson 7: Freezing Rows or Columns
🧠 What You’ll Learn:
How to freeze row and column
✅ Steps:
1. Go to View then to Freeze
2. Choose to the top row or first column to keep headers visible while scrolling
📝 Activity:
Now do this on your practice sheet, and explore to familiarize.
Lesson 8: Collaboration and Sharing
🧠 What You’ll Learn:
How to share your sheet with others
How to comment and view version history
✅ Steps:
3. Click the Share button in the top-right corner
4. Enter an email address and choose permission (Viewer, Commenter, Editor)
5. Click Comment icon and leave a note on cell B2
6. Go to File > Version history > See version history
7. Click on a previous version to view or restore
📝 Activity:
Share your sheet with a classmate, leave a comment, and explore version history.