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...).

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.

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.

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