The Excel skills most office jobs expect
Written by LitCareer · 13 Oct 2026 · 2 min read
The functions and features employers actually use, in the order you should learn them.
Why Excel still matters
Almost every office role uses spreadsheets: accounts, HR, sales, operations, procurement and engineering. Being comfortable in Excel or Google Sheets makes you faster and more valuable from your first week.
Level 1: the basics
- Entering and formatting data: number formats, dates, borders and column widths.
- Basic formulas: SUM, AVERAGE, MIN, MAX and COUNT.
- Absolute and relative references (the $ sign), so formulas copy correctly.
- Sorting and filtering.
- Freezing panes so headers stay visible.
Level 2: everyday power tools
- IF, AND, OR for decisions: mark orders as "Late" if the delivery date is past the due date.
- SUMIFS and COUNTIFS to total or count by conditions, for example sales by region and month.
- XLOOKUP or VLOOKUP to bring data from another table, such as employee names from IDs.
- Text functions like TRIM, LEFT, RIGHT and TEXT to clean data.
- Conditional formatting to highlight overdue items or high values.
- Data validation to create drop-down lists and prevent wrong entries.
Level 3: summarising and presenting
- Pivot tables to summarise thousands of rows in seconds.
- Charts: line for trends, bar for comparisons.
- Tables (Ctrl+T) so ranges expand automatically.
How to practise
Download a sample dataset, such as sales or attendance data, and answer real questions: Which month had the highest sales? Which region grew fastest? Who has the most absences? Build a one-page summary with a pivot table and a chart.
Show it on your resume
Instead of writing "Excel", write what you did: "Built a pivot-table dashboard to track monthly vendor payments."
Your next steps
- Master SUMIFS, COUNTIFS and XLOOKUP
- Learn absolute references with the $ sign
- Build one pivot table and chart from real data
- Describe what you built with Excel on your resume
General guidance for learning, not professional, legal or financial advice. Want help for your own situation? Book 1:1 career help.


