What even is Excel?

It's a giant grid of boxes.

That's really it at the core. Excel is a grid of cells, each one addressed by a column letter and a row number — like B4 or F12. Every single thing Excel does — every chart, every formula, every dashboard — happens inside these little boxes.

Every cell holds one of a few things.

Understanding what's in a cell matters more than people think — it's why formulas break in confusing ways.

That "dates are secretly numbers" line isn't a joke — Excel stores every date as a number counting from Jan 1, 1900. That's why you can subtract two dates and get a number of days back.

The = sign changes everything.

Type 55000 into a cell, and it's just a number sitting there. Type =55000*0.1, and Excel calculates it live. The equals sign is the switch that turns a cell from "static text" into "a living calculation."

Cell references: the real superpower.

Instead of writing =55000*0.1, you write =B2*0.1. Now if B2 changes, your formula updates automatically. This one habit — referencing cells instead of typing numbers — is what separates a spreadsheet from a calculator.

Relative vs. Absolute — where beginners get stuck.

Drag a formula with B2 down a column, and Excel shifts it to B3, B4... That's relative — usually what you want. Lock it with dollar signs — $B$2 — and it stays put no matter where you drag it. That's absolute.

A "function" is just a named shortcut.

=SUM(A1:A10) is shorthand for =A1+A2+A3+...+A10. Every function follows the same shape: a name, then parentheses holding the ingredients (called arguments) it needs to do its job.

There are hundreds of functions. They fall into a handful of families.

You don't need to memorize 500 formulas. You need to recognize which family solves your problem — the exact function is easy to look up once you know that.

Why this actually matters at work.

Nobody hires you to "know Excel." They hire you because Excel is how real decisions get made — the sales dashboard the VP checks every Monday, the payroll sheet that has to be exactly right, the model that decides whether a project gets funded. The formulas are just the language that work runs on.