Beginner Excel is not "I have opened Excel before." It is entering data without corrupting it, writing one formula that does not break when copied, and formatting a sheet a colleague can actually read. That is a real, useful, employable level — and it stops well before most job ads mean when they say "Excel required".
What "Beginner" Actually Covers
At beginner level you can enter and edit data cleanly: consistent formats in a column, no text hiding in a number field, no merged cells scattered through a table that will later refuse to sort. You can use SUM, AVERAGE, COUNT and the basic arithmetic operators, and you know the difference between typing a number and typing a formula that produces one.
You can sort a range and apply a simple filter, and you know enough to select the whole table first rather than one column, which is the single most common way a beginner accidentally shuffles someone's salary away from their name. You can apply basic formatting — bold, borders, number formats, column widths — well enough that the sheet is readable by someone who did not build it.
That is a real floor. It is also, on its own, indistinguishable from "opened it a few times", which is why the CV line matters as much as the skill: naming what you can actually do reads as more competent than a bare unqualified claim.
Where It Breaks
The first wall is the relative reference. Drag a formula like =B2*C2 down a column and Excel adjusts it automatically, which is usually what you want and occasionally is not — reference a tax rate sitting in one fixed cell and the reference shifts with every row, silently pulling in blank cells further down. The formula still runs. The output is wrong, and nothing in the interface tells you so.
- A total that does not update, because a new row was inserted below the SUM range instead of inside it
- A number that displays as a string of hash symbols, because the column is too narrow — cosmetic, but a beginner often assumes the value is wrong rather than just hidden
- A sort that separates one column from the rest, because only that column was selected before sorting
- A date that Excel silently reinterprets — day and month swapped, or a value that was never really a date at all
None of these require advanced knowledge to avoid. They require knowing that a formula and its result are two different things worth checking separately, which is the exact habit that beginner Excel has not yet built.
What to Put on a CV at This Level
"Basic Excel: data entry, SUM/AVERAGE, sorting, filtering, formatting" is accurate and it is enough for a large share of admin and entry-level roles that never ask for a formula more complex than a total. It also sets the right expectation, so nobody hands you a pivot table on day one assuming you have done this before.
What would be a lie at this level: "advanced Excel", "VLOOKUP", "pivot tables", or "macros". Those are not adjacent skills you can round up to — they are a different tier, and claiming them gets tested in the first working week, not in the interview.
The Next Rung
Two things separate beginner from intermediate, and both are small: absolute references, and one lookup function. Absolute references ($A$1 instead of A1) fix the exact failure mode above — the formula stops shifting when you drag it. A lookup function (VLOOKUP, INDEX/MATCH, or XLOOKUP on newer versions) is what turns "I can total a column" into "I can find one person's row in three thousand", which is most of what an intermediate Excel job actually asks for.
Neither takes long to learn properly, and both are the specific gap a hiring screen is built to find. The Excel Skills test scores formulas, lookup, data handling and presentation separately in six minutes, which is a faster way to find out which of the two you are missing than guessing.
For the wider computer-skills picture around Excel — file management, email, browser basics — the Computer Literacy test covers the rest of what an office role assumes, and it is worth checking alongside this one before either goes on a CV.
Why This Gap Shows Up So Fast at Work
A beginner-level sheet tends to survive exactly as long as it stays a solo project. The moment a second person opens it — a manager checking a total, a colleague adding rows — the gaps in formatting and formula hygiene stop being private habits and become someone else's problem, usually discovered at the worst possible moment: right before a total is due.
That is also why the beginner tier is worth taking seriously rather than rushing past. Someone who has genuinely mastered clean data entry, correct basic formulas and readable formatting has removed most of the errors that make spreadsheets untrustworthy in the first place. The next tier adds power; this one is where trust is built.