Getting Started with Google Sheets
You already know how to solve more problems than you think. You've made mental lists, compared options, tracked expenses in your head, and figured out how many slices of pizza each person gets before the box even hits the table. Spreadsheets are just a way of doing all of that on screen — with a little help from software that never forgets, never miscounts, and never runs out of paper. The trouble is that most people who haven't used spreadsheets much feel vaguely intimidated by them, like they're looking at a cockpit full of buttons and no one ever handed them a manual. That's exactly what this course is here to fix.
Here's the core idea we'll keep coming back to: spreadsheets are not just for accountants. They're not a specialized tool that requires a finance degree or a natural gift for numbers. They are, at their heart, a universal language for organizing information, spotting patterns, and communicating what data actually means. But before we open any software, it's worth understanding what a spreadsheet actually is — where the idea came from, how it evolved, and why the underlying logic is so useful for so many different problems. That understanding will make everything else in this course click faster.
Before the Computer: The Paper Ledger
The word "spreadsheet" is older than any computer. It comes from the world of paper accounting, where bookkeepers and clerks worked with large sheets of paper ruled into rows and columns — literally, sheets that spread across a desk. A typical ledger page might have rows for each day of the month and columns for income, expenses, rent, supplies, wages, and a running total. Every number had a designated address: this row, that column, right here.
This grid layout wasn't arbitrary. It was invented to solve a specific human problem: when you're tracking many things at once, your brain can't hold all the relationships in memory at the same time. Writing them down in an organized grid gives you a physical representation of information you can scan, check, and update without losing your place. The paper spreadsheet was, essentially, external memory with structure.
The downside? Paper doesn't calculate. If you changed one number — say, you discovered a rent payment was recorded wrong — you had to erase and manually recalculate every related total on the page. A single correction could cascade into an hour of careful arithmetic. Bookkeepers were meticulous people not because they enjoyed tedium, but because a single mistake was so expensive to fix.
That pain point is exactly what software was born to solve.
The Digital Leap: VisiCalc, Lotus 1-2-3, and Excel
The story of the electronic spreadsheet begins in 1978, when a Harvard Business School student named Dan Bricklin was watching a professor fill a chalkboard with rows and columns of numbers. When a figure changed, everything downstream had to be recalculated by hand. Bricklin thought: what if a computer could do that automatically?
Together with programmer Bob Frankston, Bricklin built VisiCalc — the first electronic spreadsheet application, released in 1979 for the Apple II. The concept was almost shockingly simple: you type a number in one cell, type a formula in another cell that refers to the first one, and when the first number changes, the second updates instantly. No erasing, no recalculating, no cascading corrections. The spreadsheet became dynamic.
VisiCalc was so useful that people bought Apple II computers specifically to run it — making it one of the first examples in history of software driving hardware sales. The spreadsheet didn't just improve bookkeeping; it changed who could do financial analysis at all. You no longer needed a team of clerks. You needed a computer and a good spreadsheet.
In 1983, Lotus 1-2-3 arrived for the IBM PC and dominated the business world through the 1980s, adding features like basic charting and database-style queries to the original formula-based model. Then, in 1985, Microsoft released Excel — first for the Mac, then for Windows — and gradually overtook Lotus over the following decade. Excel brought a more visual, polished interface, more powerful functions, and deeper integration with the rest of the Microsoft Office suite.
For roughly thirty years, Excel was the spreadsheet. If you used a spreadsheet at work, you used Excel. Its dominance was so complete that "Excel" and "spreadsheet" became nearly synonymous in everyday conversation — like how some people still say "Xerox" when they mean "photocopy."
The Cloud Arrives: Why Google Sheets Is the Best Place to Start
In 2006, Google released what would eventually become Google Sheets — a spreadsheet application that lived entirely in a web browser, required no installation, and allowed multiple people to edit the same file at the same time from anywhere in the world. That last part was genuinely new. Excel was a single-player experience saved to a single hard drive. Google Sheets was multiplayer, always-online, and free.
For a beginner in the present day, Google Sheets is the ideal starting point for a few specific reasons:
Nothing to install. You need a Google account (free) and a web browser. That's it. No software purchase, no download, no version conflicts.
Automatic saving. Google Sheets saves every change you make as you make it, to the cloud. You cannot accidentally lose your work by forgetting to hit Save, because there is no Save button to forget.
Easy sharing. You can share a spreadsheet with someone else in seconds, let them view or edit it, and watch their changes appear in real time. Collaborating on an Excel file traditionally involved emailing attachments back and forth and hoping nobody edited the wrong version.
Compatible with Excel. Almost everything you learn in Google Sheets transfers directly to Excel. The functions, the formulas, the logic — it's all the same. If you ever need to work in Excel for a job, the skills you build here will carry over with minimal adjustment.
Free. This one speaks for itself.
The concepts this course teaches you are universal. We're using Google Sheets as the vehicle, but what you're really learning is how spreadsheets think — and that thinking is the same whether you're in Google Sheets, Excel, Apple Numbers, or any other spreadsheet application.
What Is a Spreadsheet Fundamentally Good At?
Strip away all the specific features, all the menus and functions and chart types, and every spreadsheet in the world does essentially three things:
1. Storing data. A spreadsheet holds information in an organized, consistent structure. Names, dates, amounts, categories — anything that can be expressed as text or numbers can be stored in a grid where every piece of information has a specific, findable location. This makes a spreadsheet a far more powerful organizational tool than a note, a document, or a sticky note.
2. Calculating relationships. A spreadsheet can contain formulas that express the relationship between pieces of data. Total sales equals the sum of all individual sales. Tax equals price multiplied by the tax rate. Net income equals total revenue minus total expenses. Once you've expressed those relationships as formulas, the spreadsheet maintains them automatically — if a number changes, everything connected to it updates immediately. This is the feature that made accountants fall in love with spreadsheets in 1979, and it's still the core superpower.
3. Revealing patterns. A spreadsheet can sort, filter, summarize, and visualize data in ways that make patterns visible. Which product category is growing fastest? Which month had the highest expenses? Which team members are consistently missing their targets? These questions are hard to answer from raw rows of numbers, but a well-built spreadsheet can surface the answers almost instantly. Charts, sorted tables, and summary formulas are all tools for turning data into insight.
These three things — storing, calculating, revealing — are what spreadsheets are for. Every feature you'll learn in this course is in service of at least one of them.
Not Just for Accountants
Because spreadsheets grew up in the world of finance, there's a persistent myth that they're primarily a tool for people who work with money professionally. That myth is worth dismantling right now.
Here are some of the ways people use spreadsheets that have nothing to do with accounting:
- Project tracking: a list of tasks, assigned owners, due dates, and completion status
- Research and comparison: a table comparing the features, prices, and ratings of products you're considering buying
- Fitness and health logging: tracking workouts, meals, sleep, or medication schedules over time
- Event planning: guest lists, RSVPs, meal preferences, table assignments
- Content calendars: planning blog posts, social media updates, or video releases by date
- Inventory management: for a small business, a home pantry, or a book collection
- Contact management: a simple database of names, emails, phone numbers, and notes
The common thread in all of these is information that has structure — information that can be broken down into rows and columns, where patterns and relationships matter. If your problem involves any of that, a spreadsheet is probably a useful tool for it.
The Difference Between the App and the File
Here's a small but important distinction that trips up a lot of new users: the spreadsheet application and the spreadsheet file are two different things.
Think of it like this. Microsoft Word is a word processing application — it's the software. The document you write in Word is a file — it's the thing you create and save. You can have thousands of Word documents, but only one copy of the Word application.
Spreadsheets work exactly the same way.
Google Sheets (the application) is the software — the program that lives at sheets.google.com and provides all the tools for building, editing, and calculating. It's the equivalent of Word or Excel as a piece of software.
A spreadsheet (the file) is the specific document you create inside that application — your budget, your project tracker, your guest list. Each one is a separate file, stored in your Google Drive, that you can open, edit, share, or delete independently.
When someone says "I built a spreadsheet," they mean they created a file. When someone says "I'm going to open Google Sheets," they mean they're launching the application. This distinction matters because the application is always there, ready to use, while your files are things you manage and organize yourself.
Inside a single spreadsheet file, you can have multiple sheets (also called tabs or worksheets) — think of them like separate pages inside the same notebook. The whole notebook is the file; each page is a sheet. We'll explore this structure in much more detail in the next section.
A Foundation Worth Having
You now know more about what a spreadsheet is than most people who have been using them for years. You know where the idea came from (paper ledgers designed to solve the problem of organizing complex information), how it evolved (from VisiCalc to Lotus to Excel to the cloud), why Google Sheets is a smart starting point, what the three fundamental jobs of any spreadsheet are, and the difference between the application you work in and the files you create.
This conceptual foundation might seem abstract right now, but it will pay off quickly. When you understand why a spreadsheet works the way it does, every new feature you encounter will slot into a framework that already makes sense. You won't be memorizing steps — you'll be reasoning from principles.
Ready to look inside? In the next section, we'll explore the actual structure of a spreadsheet — the rows, columns, cells, and sheets that make up the grid — and you'll pick up the vocabulary that will make everything else in this course easy to follow.
Only visible to you
Sign in to take notes.