Google Sheets - Tables & Data Basics

Google Sheets

Tables & Data Basics

Let's go!

Welcome to our first session on Google Sheets!

Today we’ll explore how to build clean, structured tables that make reviewing and reporting data easier and more accurate.

Continue

Structured data saves time, reduces errors, and supports accurate reporting.

Continue

Sheet Structure

• Each Google Sheet can have multiple tabs, and each tab contains rows and columns.
• Rows hold records (like student names).
• Columns hold data categories (like program, site, or due date).
• Rename your tab to reflect its purpose — for example, “McAuliffe IEP Tracker.”

Continue

Use View → Freeze to lock your header rows or columns so you can scroll without losing column titles.

Use Format → Text wrapping → Wrap to make all information visible without expanding columns endlessly.

Wrapping

Freezing

Continue

Formatting Tools

Apply clear formatting:

• Bold your header row.
• Center or left-align text consistently.
• Add borders around your table.
• Format your dates as mm/dd/yyyy for consistency.
• A clean visual structure makes your sheet more readable

Continue

Let’s build a practice table together.

Option

Option

Enter mock data for 5 students.

Continue

Table Functionality

Here you can include a relevant piece of information to highlight

Continue

Common Mistakes to Avoid

Be consistent with spelling: “Lum” vs “Sing Lum” creates two different sites.

Avoid blank rows between data.

Avoid merged cells (they break formulas).

Continue

Thank you!

Next session topic:Data Validation & Conditional Formatting

Questions?