💻 Getting Started with Google Sheets

Open Sheets for the first time, tour every part of the interface, understand how cell addresses work, format your data beautifully, and start using keyboard shortcuts like a pro.

⏰ ~30 minutes 🎓 Beginner 📋 No prior experience needed

📌 Before You Start

What you need

A free Google account (gmail.com) — create one here if you don't have one.
A web browser (Chrome, Firefox, Edge, or Safari).
That's it. No downloads, no installations, no software to buy.

To open Google Sheets, go to sheets.google.com and sign in. You'll land on the Sheets home page where you can create a new spreadsheet or open an existing one.

💡 The Concept

What is a Spreadsheet?

A spreadsheet is a grid of cells organized into rows (horizontal, numbered 1, 2, 3…) and columns (vertical, labeled A, B, C…). Every cell has an address — the column letter followed by the row number.

Address	Meaning
`A1`	Column A, Row 1 (top-left)
`B3`	Column B, Row 3
`C10`	Column C, Row 10
`Z100`	Column Z, Row 100

You can put three types of content in a cell:

Text — names, labels, categories (e.g., "Electronics")
Numbers — values to calculate (e.g., 1250.50)
Formulas — calculations that start with = (e.g., =A1+B1)

Google Sheets can have up to 10 million cells per spreadsheet — far more than you'll ever need for most projects.

🚀 Interface Tour

The Google Sheets Interface — What Everything Does

When you open a blank spreadsheet, here is what you see from top to bottom:

▲ Menu bar: File Edit View Insert Format Data Tools Extensions Help ▲ Formula bar: [ A1 ▼ ] fx (cell address on left, formula content on right) ▲ Column headers: A B C D E F G ... ▲ Row numbers + cells: 1 | [cell A1] [cell B1] [cell C1] ... ▲ 2 | [cell A2] [cell B2] [cell C2] ...

Key interface elements explained:

Element	What it does
Name Box	Shows the address of the currently selected cell (e.g., A1). Click it and type any address to jump there instantly.
Formula Bar	Shows the exact content of the selected cell. If it's a formula, you see the formula here — not just the result.
Column Headers	Letters A, B, C… up to Z, then AA, AB… Click to select an entire column.
Row Numbers	Numbers 1, 2, 3… Click to select an entire row.
Select All button	The gray rectangle at the top-left corner (where row numbers and column headers meet). Click to select every cell.
Sheet Tabs	Each tab is a separate grid. Right-click a tab to rename, duplicate, or delete it.
Toolbar	Quick-access buttons for the most common formatting: font, size, bold, italic, fill color, borders, alignment.

🔧 Step-by-Step

Basic Formatting: Make Your Data Look Good

Good formatting makes spreadsheets easier to read. Here are the most useful formatting tools:

Bold: Select a cell or range, then press Ctrl+B (Windows) or Cmd+B (Mac). Use bold for headers — it visually separates labels from data.
Fill Color: Select cells, then click the paint bucket icon (▦) in the toolbar. Choose a background color. Use a consistent color for your header row.
Text Color: Select cells, click the A with a color bar beneath it. White text on a dark background looks great for headers.
Column Width: Hover over the right edge of a column header until your cursor becomes a double arrow (↔). Drag to resize. Or double-click to auto-fit to the widest content.
Borders: Select a range, click the borders icon (▤) in the toolbar. Choose "All Borders" to add lines around every cell in your selection.
Merge Cells: Select cells you want to merge (e.g., A1:D1 for a title), then go to Format → Merge cells → Merge all. Great for centered titles spanning multiple columns.
Number Formatting: Select number cells, go to Format → Number. Choose Currency ($ signs), Percentage, Date, or set decimal places.

📋 Sample Data

A Simple Student Grade Table

Here is a sample table to type into your spreadsheet. Start at cell A1. Each row below represents one student.

A — Name	B — Score	C — Grade
Alice Johnson	92	A
Bob Martinez	85	B
Chloe Kim	78	C
David Okafor	95	A
Emma Patel	67	D

Row 1 should be your header row (Name, Score, Grade). Rows 2–6 are the student data. The column letters A, B, C are just Sheets' column labels — they aren't in your spreadsheet.

☁️ Keyboard Shortcuts

Essential Shortcuts — Save Hours of Clicking

Learning even a handful of shortcuts will make you dramatically faster. Here are the most important ones:

Action	Windows / Chrome OS	Mac
Copy	Ctrl+C	Cmd+C
Paste	Ctrl+V	Cmd+V
Cut	Ctrl+X	Cmd+X
Undo	Ctrl+Z	Cmd+Z
Redo	Ctrl+Y	Cmd+Y
Bold	Ctrl+B	Cmd+B
Find & Replace	Ctrl+H	Cmd+H
Toggle Filter	Ctrl+Shift+L	Cmd+Shift+L
Select all	Ctrl+A	Cmd+A
Go to cell	Ctrl+G	Cmd+G
Insert row above	Ctrl+Alt+=	Cmd+Alt+=
Jump to edge of data	Ctrl+Arrow	Cmd+Arrow

Tip: Press Ctrl+/ inside Google Sheets to see a full list of all shortcuts.

🖐 Your Turn

Exercise: Build and Format a Student Table

Instructions:

Open sheets.google.com and create a blank new spreadsheet. Name it "Module 01 Practice" (click on "Untitled spreadsheet" at the top to rename).
In row 1, type these headers: Name in A1, Score in B1, Grade in C1.
Enter data for 5 students of your choice (rows 2–6). Use real-looking names, scores between 60–100, and grades A/B/C/D.
Select the header row (cells A1:C1). Make the text bold using Ctrl+B.
Fill the header row with a dark green background (use the paint bucket icon). Change the text color to white.
Auto-fit all column widths by selecting all columns (click the A header, shift-click C header), then double-click any column border.
Add "All Borders" to your data range (A1:C6).

Hint: If you can't find a toolbar button, try the Format menu at the top — every formatting option lives there too.

Excel note: In Excel, the toolbar layout is slightly different, but all these formatting options exist in the Home tab of the ribbon. The keyboard shortcuts are identical.

🧠 Brain Break

Interesting Fact: The History of Spreadsheets

The very first electronic spreadsheet, VisiCalc, was released in 1979 for the Apple II computer. It was so useful that it's often credited with making personal computers a business essential — people bought Apple IIs just to run VisiCalc. Lotus 1-2-3 followed in 1983, then Microsoft Excel arrived in 1985. Google Sheets launched in 2006 and made spreadsheets collaborative and free for the first time.

Today, hundreds of millions of people use spreadsheets every day — from scientists tracking experiments to small business owners managing inventory. Knowing how to use them is one of the most versatile skills you can have.

✅ Wrap Up

Module 01 Key Takeaways

Google Sheets is free at sheets.google.com — no downloads needed.
Spreadsheets are grids of cells identified by their address: column letter + row number (e.g., B3).
Cells hold text, numbers, or formulas (formulas always start with =).
The formula bar shows exactly what's in the active cell — including the formula, not just the result.
Use the toolbar for quick formatting: bold, fill color, borders, text color.
Keyboard shortcuts like Ctrl+Z (undo) and Ctrl+B (bold) work the same in Excel and Sheets.
Good formatting — bold headers, consistent colors, appropriate column widths — makes your spreadsheet far easier to use.

Next: Module 02 — Formulas & Functions →