Starvard University · Spreadsheets
The most underrated career skill in every office on earth. Spreadsheets run the world quietly, and fluency in them makes you indispensable.
The whole course in brief
The twelve lessons
Lesson 1
Behind every company, under the fancy software, there is a spreadsheet holding it together. Budgets, forecasts, inventory, schedules, analyses: the grid is where work actually happens. It is the most widely used data tool on earth, and most people use ten percent of it.
The reason is flexibility. A spreadsheet is a blank canvas that becomes whatever you need: a calculator, a database, a planner, a model. Specialized software does one thing well. A spreadsheet does a thousand things well enough, instantly, with no IT ticket.
This is why fluency pays. The person who can turn a messy question into a clean spreadsheet becomes the person every meeting turns to. That visibility compounds into promotions, because decision-makers remember who gave them the answer.
Lesson 2
Speed starts with movement. Learn to jump, not scroll: Ctrl plus arrows leaps to the edge of your data, Ctrl plus Home returns to the start. Selecting whole columns, rows, and the entire sheet with single shortcuts turns fumbling into flow.
Freeze panes so headers stay visible while you scroll through thousands of rows. Filter to show only what matches. Sort to rank and organize. These three, freeze, filter, sort, are the daily bread of data work, and many users never touch them.
Lesson 3
A formula is an instruction that starts with an equals sign. Type =A1+B1 and the cell shows the sum, updating automatically whenever A1 or B1 changes. That live updating is the whole revolution: change an input and watch every dependent answer recalculate instantly.
References are the key concept. A1 means "the value in cell A1." Dollar signs lock references: $A$1 stays put when you copy a formula down a column, A1 shifts along. This one distinction, relative versus absolute references, unlocks every serious formula you will ever write.
Build formulas incrementally. Get one cell right, then copy it across. When something breaks, the error messages actually tell you what is wrong: DIV/0 means division by zero, NAME means a typo in a function name. Read them instead of fearing them.
Lesson 4
Functions are pre-built formulas with names. SUM adds a range. AVERAGE averages it. COUNT counts numbers, COUNTA counts non-empty cells. These four alone handle a huge share of office math, and they all take a range like A1:A100.
IF brings logic: =IF(sales>1000,"Bonus","No bonus"). It asks a question and returns one of two answers. Nested with AND and OR, IF builds real decision rules. Most business logic in spreadsheets is IF statements wearing a suit.
Round out the dozen: MAX and MIN for extremes, SUMIF and COUNTIF for conditional totals ("sum sales where region is West"), ROUND for clean numbers, and TEXT for formatting dates and values. Twelve functions, ninety percent of office work.
Lesson 5
Lookups answer "find this thing and tell me something about it." Given a product code, return its price. Given a name, return the department. XLOOKUP does this in one readable formula, searching any column and returning any other column. It replaced the older, fussier VLOOKUP and you should learn it first.
The classic use: two tables that need joining. Orders have product codes, a price list has codes and prices. One XLOOKUP column pulls every price into the orders table. What took an afternoon of manual matching takes a minute.
Lesson 6
A pivot table summarizes thousands of rows by dragging fields into boxes: rows, columns, values. Sales by region by month? Drag region to rows, month to columns, sales to values. Done in seconds. Questions that took analysts hours now take anyone a minute.
The trick is clean source data: one header row, no blank rows, consistent values. Pivots are unforgiving of messy inputs and magical with clean ones, which is why lesson 8 on cleaning data matters so much.
Practice on real data: download any public dataset and ask it questions. Total by category, average by group, count by month. Each answer is a drag away. This is the skill that makes managers' eyes light up in meetings.
Lesson 7
A good chart makes your point before you speak. Pick the chart for the message: line charts for trends over time, bar charts for comparing categories, pie charts almost never (humans judge angles badly). The right chart type does half the persuasion.
Then remove everything that is not the message. Chart junk, 3D effects, excessive colors, and tiny labels all dilute. One clear title that states the takeaway, clean axes, and minimal decoration. The best charts look almost boring, and that is the point.
Always sanity-check the visual against the numbers. Truncated axes exaggerate tiny differences. Cherry-picked date ranges manufacture trends. Honest charts build your credibility. Manipulative ones destroy it the moment someone checks.
Lesson 8
Real-world data arrives filthy: extra spaces, inconsistent spelling, dates as text, duplicates, blank rows. Cleaning it is unglamorous and it is where most analysis time actually goes. The pros accept this. Amateurs fight it.
Lesson 9
The mouse is slow. Every common action has a keyboard shortcut, and learning the twenty you use daily transforms your pace. Ctrl+C, Ctrl+V, and Ctrl+Z are table stakes. Ctrl+Shift+L toggles filters. Alt+= auto-sums. F4 repeats your last action, which is pure magic for formatting.
Learn one new shortcut a week and actually use it until it is automatic. In three months you will operate at double speed without thinking about it. Speed compounds: faster work means more iterations, and more iterations mean better answers.
Watch an expert work for ten minutes and steal their shortcuts shamelessly. Every fast spreadsheet user has a personal set. Build yours deliberately.
Lesson 10
Google Sheets is spreadsheets with collaboration built in: multiple people editing live, comments on cells, version history for everything, all free. For team work it beats Excel, full stop. The functions you learned transfer almost entirely.
The superpowers are sharing and connecting. Share a link instead of emailing files, and version chaos disappears. Built-in functions can pull live data from the web, and add-ons extend it further. A shared sheet with live data is a lightweight app.
Know the tradeoff: Excel still wins for heavy-duty modeling, giant datasets, and power features. Use Sheets for collaboration, Excel for computation. Bilingual is best.
Lesson 11
A model is a spreadsheet that answers "what if." What if sales grow 10%? What if costs rise 5%? Build with inputs in one clearly marked area, formulas everywhere else, and outputs summarized up top. Change an input, watch the future change. That is financial modeling.
Keep assumptions visible and labeled, never buried inside formulas. Anyone should be able to audit your logic by reading the sheet. The best models are boring to look at and thrilling to use.
Lesson 12
Every team has one: the person everyone asks when numbers need answering. It is not a job title, it is a reputation, and it is earned by being fast, accurate, and helpful. Answer questions with clean sheets, explain your work plainly, and never make people feel dumb for asking.
Build a personal toolkit: templates for common analyses, a cheat sheet of your best formulas, sample models you can adapt. Each new question gets faster because you are rarely starting from zero.
This reputation is a career accelerant. Decision-makers promote the people who give them clarity. The spreadsheet person sits near the decisions, and proximity to decisions is proximity to advancement. All from a grid of cells.
Graduation
You can navigate at speed, write formulas, wield the essential functions, look up anything, pivot thousands of rows, chart persuasively, clean messy data, and model the future. That puts you ahead of most of the working world. Keep the shortcuts coming, stay bilingual in Excel and Sheets, and be the person with the answer.
Keep learning
This course is part of Starvard University, striving for greatness.
