Spreadsheet Fundamentals

In 2012, JPMorgan Chase lost $6.2 billion because of a copy-paste error in an Excel spreadsheet

A team of risk analysts at JPMorgan's Chief Investment Office was using a Value at Risk (VaR) model built in Excel. When they updated the model, someone manually copied formulas from one spreadsheet to another — and accidentally divided by a sum instead of an average. The error made the portfolio's risk look half of what it actually was. Traders kept making bets that would have been flagged immediately with accurate numbers. By the time anyone noticed, the losses had ballooned to $6.2 billion.

The "London Whale" scandal, as it became known, was not caused by exotic financial instruments or rogue traders. It was caused by someone who did not understand how their spreadsheet worked.

This is why spreadsheet fundamentals matter. Not because cells and columns are exciting — but because getting them wrong can cost billions.

What is a spreadsheet, really?

Think of a spreadsheet as a giant grid of tiny boxes — like graph paper that can do math. Each box is called a cell. Each cell lives at the intersection of a column (vertical, labeled A, B, C...) and a row (horizontal, labeled 1, 2, 3...).

Spreadsheets are not new — accountants used paper spreadsheets for centuries. But the electronic version changed everything, and understanding this history explains why Excel works the way it does today:

Every cell has an address. Cell B3 means column B, row 3. That is it. If you can find a seat in a movie theater (row G, seat 12), you can find a cell in a spreadsheet.

Navigating without the mouse

Power users almost never touch the mouse for basic navigation. Here are the shortcuts that separate someone who uses Excel from someone who is fast in Excel:

There Are No Dumb Questions

"What is the difference between a cell's value and its formula?"

What you see in a cell is the value — the result. But behind that value, there might be a formula doing the calculation. Click on any cell and look at the formula bar at the top. If it shows =A1*0.08, that is the formula. The cell just displays the answer. This distinction matters because when you copy a cell, you are copying the formula, not the number you see.

"Do the column letters ever run out?"

They go from A to Z, then AA to AZ, then BA to BZ, all the way to XFD — that is 16,384 columns. Each sheet can also have 1,048,576 rows. That is over 17 billion cells per sheet. You will not run out.

Data entry done right

Most spreadsheet errors do not come from bad formulas — they come from messy data entry. Here are the rules that will save you hours of cleanup later:

One fact per cell. Do not put "John Smith" in one cell. Put "John" in column A and "Smith" in column B. You cannot sort by last name if first and last are combined.

Be consistent. If dates are in MM/DD/YYYY format, keep them all that way. One cell with March 15, 2024 in a column of 03/15/2024 will break sorting and formulas.

No merged cells. They look pretty and break everything. Sorting, filtering, formulas, pivot tables — all of them choke on merged cells.

No blank rows in the middle of data. Excel uses blank rows to detect the edges of a data range. A blank row in row 50 means everything below it becomes invisible to many features.

<classifychallenge xp="25" title="Which Data Entry Rule Is Broken?" items={["Column A has 'Sarah Johnson' in one cell instead of separate first/last columns","Column D mixes date formats: 01/15/2024, February 3 2024, 2024-03-01","Rows 1-3 are merged into one big cell that says Q1 Sales Report","Row 25 is completely blank with more data in rows 26-50","Column F has amounts like $1,234 stored as text instead of numbers","Column B header says Region but some cells contain full state names and others contain abbreviations"]} options={["One fact per cell","Be consistent","No merged cells","No blank rows"]} hint="Each entry violates exactly one of the four rules. Mixing formats and mixing abbreviation styles both violate consistency. Combined names violate one-fact-per-cell. Text-formatted numbers also violate consistency (format mismatch).">

The data quality pipeline

Before you write a single formula, the quality of your data determines whether that formula produces truth or garbage. Every spreadsheet project follows the same pipeline:

If data entry is messy, formatting is wrong, or validation is missing, every step downstream produces unreliable results. The London Whale loss happened because the first step (data entry via copy-paste) was wrong — and nobody caught it.

Think of it like cooking: if the ingredients are spoiled, no amount of technique will save the dish. Clean data entry is your fresh ingredients. In the Data Analysis module, you will learn data validation rules that catch errors at the source before they propagate.

Formatting: make it readable, not pretty

Formatting is not about making your spreadsheet look like a magazine layout. It is about making data scannable, sortable, and error-proof.

Excel vs Google Sheets

Most people will encounter both. Here is what actually matters:

There Are No Dumb Questions

"I only have Google Sheets. Can I still follow this course?"

Yes. About 90% of what you will learn — formulas, pivot tables, charts, data analysis — works identically in both. We will flag the few features that are Excel-only (VBA macros, Power Query) and show the Google Sheets equivalent when one exists.

"Should I learn keyboard shortcuts for both?"

Learn the shortcuts for whichever tool you use daily. The concepts are identical — only the key combinations differ slightly. Speed comes from muscle memory, and muscle memory comes from daily repetition in one tool.

Back to the London Whale

Remember JPMorgan's $6.2 billion loss? The analysts who built that spreadsheet were not amateurs — they were highly paid risk professionals. But they violated the fundamentals. They copy-pasted formulas without understanding cell references. They did not structure their data in a way that made errors visible. They did not use consistent formatting that would have flagged the division-by-sum mistake.

Every skill in this module — cell references, keyboard navigation, clean data entry, proper formatting — exists to prevent exactly that kind of catastrophe. The fundamentals are not the boring part you rush through to get to the exciting stuff. The fundamentals are the exciting stuff, because they are the difference between a spreadsheet you can trust and one that quietly lies to you.

If those analysts had followed the four data entry rules, used consistent formatting, and structured their data in a table instead of a loose range of copy-pasted cells, the error would have been visible immediately. Six billion dollars visible.

The good news: you now have those fundamentals. Every module from here builds on this foundation.

Next up: You know how to navigate and organize a spreadsheet. But a spreadsheet that just holds data is just a fancy table — a very expensive piece of graph paper. In the next module, you will learn the formulas that turn static data into a calculation engine — starting with SUM, IF, and VLOOKUP, the 15 functions that handle 90% of all business spreadsheet work.

Key takeaways

• Cell references (like B3) are the foundation — every formula, chart, and feature depends on them
• Keyboard shortcuts for navigation (Ctrl+Arrow, Ctrl+Shift+Arrow) save massive amounts of time over mouse scrolling
• Clean data entry prevents errors downstream — one fact per cell, consistent formats, no merged cells, no blank rows
• Number formatting (currency, percentage, date, text) changes how data displays without changing the underlying value
• Excel vs Google Sheets: Excel handles larger datasets and has more advanced features; Google Sheets excels at real-time collaboration — both work for most tasks
• The JPMorgan "London Whale" loss proves that spreadsheet fundamentals are not academic — they are the difference between accurate decisions and billion-dollar mistakes