What is a spreadsheet and how does it work

Content:

Now that we've set the stage, let's start with the foundation: understanding what a spreadsheet actually is and why it exists. This might feel like starting a cooking class by discussing the history of fire. But here's the thing — if you understand why spreadsheets were invented and what problem they solve, every button, formula, and feature you learn later will make immediate sense. You won't just be memorizing steps. You'll be thinking like a spreadsheet.

It Started on Paper

Long before computers, businesses had a problem. They needed to track numbers — income, expenses, wages, inventory — and those numbers had relationships to each other. Your total revenue minus your total expenses equals your profit. Easy enough to say. Much harder to manage when you've got 200 employees, 15 product lines, and numbers that change every week. The solution accountants landed on was the paper ledger: a large, ruled sheet of paper divided into rows and columns. Each row represented something (a transaction, an employee, a product). Each column represented a property of that thing (the date, the amount, the category). The grid layout wasn't arbitrary — it was the most efficient way humans had found to organize related information so you could scan across a row to see everything about one thing, or scan down a column to compare the same property across many things.

Then computers happened. And in 1979, a Harvard Business School student named Dan Bricklin had an idea: what if you could build a digital version of that paper ledger, but with one crucial difference? What if you could write formulas that said "this cell equals that cell multiplied by this other cell," and then when you changed a number, every formula that depended on it would recalculate automatically?

He built it with Bob Frankston, and they called it VisiCalc — short for "visible calculator." It sounds modest. It wasn't. Before VisiCalc, if you changed one number in a financial model, you had to manually recalculate everything else that depended on it. Hours of work. Days of work, sometimes. VisiCalc eliminated that entirely. Change one cell and watch every dependent calculation update instantly.

That was revolutionary, and it's still the core of every spreadsheet today: cells can contain formulas that reference other cells, so when data changes, calculations update automatically.

VisiCalc's success helped turn the Apple II into a serious business machine — people were buying computers just to run VisiCalc. That's how significant this was.

Then came Lotus 1-2-3 in 1983, which dominated the DOS era with more features and better performance. Microsoft Excel was first released in 1985 for the Macintosh, and later in 1987 for Windows. And in 2006, Google launched what would eventually become Google Sheets — a spreadsheet that lives entirely in your browser, saves automatically to the cloud, and lets multiple people work on it at the same time.

graph LR
    A[Paper Ledgers<br/>Pre-1979] --> B[VisiCalc<br/>1979]
    B --> C[Lotus 1-2-3<br/>1983]
    C --> D[Microsoft Excel<br/>1985]
    D --> E[Google Sheets<br/>2006]
    style A fill:#d4c5a9
    style B fill:#a8c5da
    style C fill:#a8c5da
    style D fill:#a8c5da
    style E fill:#90c97a

Why Google Sheets Is the Perfect Starting Point

You might be wondering: if Excel is the industry standard, why start with Google Sheets?

A few very good reasons:

It's free. Excel requires a Microsoft 365 subscription. Google Sheets costs exactly nothing, and you only need a Google account (which you probably already have).

It's everywhere. Because it lives in your browser, your spreadsheet is accessible from any device. No installation, no version conflicts, no "I left the file at home."

Collaboration is built in. Share a link and multiple people can edit simultaneously — something Excel added much later and still handles more awkwardly.

It auto-saves. Every change is saved to Google Drive instantly. You literally cannot lose your work by forgetting to press Ctrl+S, which is a genuinely underrated feature when you're still learning.

The concepts transfer perfectly. Everything you learn in Google Sheets — formulas, functions, data types, cell references — applies directly to Excel. The interfaces are slightly different, but the underlying logic is identical. Master one and you've got an 80% head start on the other.

Remember: This course teaches you how spreadsheets think, not just where the buttons are. That means everything you learn here works whether you end up using Google Sheets, Excel, or whatever comes next.

Three Things Every Spreadsheet Is Fundamentally Good At

Strip away all the features and fancy functions, and every spreadsheet is really doing three things:

1. Storing data in an organized way

A spreadsheet is, at its core, a structured place to put information. Not just numbers — names, dates, categories, notes, anything. The grid gives that information a consistent shape. Every row is one "thing" (a person, a transaction, a task). Every column is one "property" of that thing (a name, an amount, a status). This consistent structure is what makes data useful rather than just a scattered list of stuff.

2. Calculating relationships between data

This is where the magic happens. Once your data is in the grid, you can write formulas that express relationships: this cell equals that cell plus that other cell. Or this cell equals the average of all the cells in this column. Change any input and every formula that depends on it updates instantly. This is what replaced 20 hours of manual recalculation with a few keystrokes.

3. Revealing patterns

Raw numbers are hard to read. But sorted, filtered, summarized, and visualized data tells stories. Which month had the highest sales? Which expense category is growing fastest? A spreadsheet lets you slice your data different ways until the answer becomes obvious — sometimes surprising you in the process.

Tip: When you're unsure whether a spreadsheet is the right tool for a problem, ask yourself: "Do I have a bunch of similar things I want to compare, calculate, or track over time?" If yes, a spreadsheet will probably help.

Spreadsheets Are Not Just for Accountants

Here's something the word "spreadsheet" makes people forget: you don't have to deal with money or math to find them useful. While spreadsheets were first developed for accounting, they're now used wherever tabular lists need to be built, sorted, and shared. And honestly, that's almost everywhere once you start looking.

Some genuinely common uses that have nothing to do with accounting:

• Personal budgets — yes, this involves numbers, but anyone can do it
• Project tracking — who's doing what, by when, and what's the status
• Reading lists, movie lists, recipe collections — literally just organized lists
• Research notes — comparing options when making a big purchase
• Event planning — guest lists, RSVPs, seating charts
• Habit tracking — a simple grid with dates in one direction and habits in the other
• Job application tracking — company, role, date applied, current status
• Student grade tracking — for teachers, tutors, or even students themselves

The common thread? You have a bunch of similar things, and you want to keep them organized, compare them, or update them over time. That's it. That's all a spreadsheet requires.

One Important Distinction: Application vs. File

Before we move on, let's clarify something that trips people up early: the difference between the application and the file.

Google Sheets (the application) is the software — the tool you open in your browser. Think of it like Microsoft Word, but for spreadsheets. It's what lets you create, edit, and work with spreadsheet files.

A spreadsheet file (called a "workbook" in the software) is the actual document you create and save. One workbook can contain multiple individual sheets (sometimes called worksheets or tabs). So when you open Google Sheets and create a new document, you're creating a workbook that starts with one sheet — but you can add more sheets to that same file as needed.

A workbook is physically represented by a single file. When you download it or see it in Google Drive, that's one workbook sitting there, potentially containing multiple sheets inside it.

The practical takeaway: when someone says "open the spreadsheet," they usually mean the file. When someone says "I use Google Sheets for everything," they mean the application. Context makes it obvious, but knowing the distinction will save you a moment of confusion later.

Warning: People use "spreadsheet" to mean both the software and the file, often in the same sentence. Don't worry about this — just know that both usages exist, and you can usually tell which one from context.

What You're Really Learning Here

This course is going to teach you Google Sheets. But more fundamentally, it's going to teach you a way of thinking about information — how to structure it, how to make it do work for you, and how to read what it's telling you.

Spreadsheets are everywhere. Job postings list them as a skill. Teams share them for everything from meeting agendas to complex financial models. Once you know how they think, you'll find yourself reaching for them to solve problems you'd previously have struggled with — and you'll understand what you're looking at when someone sends you a spreadsheet full of formulas.

The accountants who invented paper ledgers weren't trying to build a mathematical tool. They were solving a human problem: keeping track of things that matter and understanding how they relate to each other. That's still exactly what spreadsheets do. We've just gotten much, much better at it.

In the next section, we'll open the hood and look at the actual anatomy of a spreadsheet — what rows, columns, cells, and sheets are, and how they work together to create that organized structure we've been talking about.