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.

The Excel skills most office jobs expect

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

Level 2: everyday power tools

Level 3: summarising and presenting

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.

More in Digital & tech skills

Keep learning