Microsoft Excel for Office Jobs: 15 Essential Skills With Examples

By
Microsoft Excel for office jobs: 15 essential skills with examples

"Proficiency in Microsoft Excel" appears in job adverts for accountants, administrators, sales officers, teachers, data clerks and project assistants all over the world. Yet many candidates write "good in Excel" on their CV and then struggle when an interviewer asks them to total a column or look up a value.

This guide covers the 15 Excel skills most useful in everyday office work, with a practical example for each. Work through it with Excel open, using the small sample table below, and you'll be able to describe your Excel skills honestly and confidently.

Quick summary

  • Foundations: data entry, formatting, sorting, filtering, freezing panes.
  • Core formulas: SUM, AVERAGE, COUNT, IF, SUMIF and COUNTIF.
  • Lookups: VLOOKUP, and XLOOKUP in newer versions.
  • Analysis and presentation: PivotTables, charts and conditional formatting.
  • Practise with real tasks, then describe specific skills on your CV.

The Practice Table

Type this small table into a new sheet, starting in cell A1. The examples below refer to it. (The data is fictional.)

ABCD
1Staff IDNameDepartmentMonthly Sales
2S01AshaNorth1200
3S02BrianSouth950
4S03CarolNorth1500
5S04DavidEast700
6S05EstherSouth1100

Part 1: Foundations

1. Entering and Formatting Data

Keep one type of information per column, with a clear header in row 1. Format numbers consistently (Home tab, Number group), for example with thousand separators or currency. Clean, consistent data makes every other skill easier.

2. Sorting

Click any cell in your table, go to Data > Sort, and choose a column, for example Monthly Sales from largest to smallest. Always select the whole table (or a single cell inside it), not just one column, so rows stay together.

3. Filtering

Select the header row and choose Data > Filter. Use the arrows to show only certain rows, for example only the North department. Filters hide rows without deleting them.

4. Freezing Panes

For long lists, go to View > Freeze Panes > Freeze Top Row so the headers stay visible as you scroll.

5. Using Tables

Select your data and press Ctrl + T (Windows) to turn it into an Excel Table. Tables add filters automatically, apply banded formatting and expand as you add rows.

Part 2: Essential Formulas

Every formula starts with an equals sign (=). Type formulas in an empty cell, for example F2.

SkillFormula (using the practice table)ResultUse it for
6. SUM=SUM(D2:D6)5450Totals: sales, expenses, payroll
7. AVERAGE=AVERAGE(D2:D6)1090Average sales, marks, costs
8. COUNT / COUNTA=COUNTA(B2:B6)5Counting entries (COUNT counts numbers only)
9. MIN / MAX=MAX(D2:D6)1500Highest or lowest value
10. IF=IF(D2>=1000,"Target met","Below target")Target met (for Asha)Simple decisions and labels
11. SUMIF=SUMIF(C2:C6,"North",D2:D6)2700Totals by category
12. COUNTIF=COUNTIF(C2:C6,"South")2Counting by category

Relative and Absolute References

When you copy a formula down a column, Excel adjusts cell references automatically (D2 becomes D3, and so on). To keep a reference fixed, such as a tax rate in cell H1, add dollar signs: $H$1. Understanding this prevents many common errors.

Part 3: Looking Up Information

13. VLOOKUP and XLOOKUP

Lookups find a value in one column and return related information from another, for example finding a staff member's sales from their ID.

VLOOKUP (available in all common versions):

=VLOOKUP("S03",A2:D6,4,FALSE) returns 1500: it looks for S03 in the first column of A2:D6 and returns the value from the 4th column. FALSE means "exact match", which you'll want in most office tasks.

XLOOKUP is newer and more flexible:

=XLOOKUP("S03",A2:A6,D2:D6,"Not found") also returns 1500. You choose the lookup column and the return column separately, and can set a message for missing values.

According to Microsoft Support, XLOOKUP is available in Excel for Microsoft 365, Excel 2024 and Excel 2021, but not in Excel 2016 or 2019. If your workplace uses an older version, learn VLOOKUP as well.

Part 4: Analysing and Presenting Data

14. PivotTables

PivotTables summarise large amounts of data in seconds. Click inside your table, choose Insert > PivotTable, then drag Department to Rows and Monthly Sales to Values. You'll instantly see total sales by department: North 2700, South 2050, East 700. Employers often treat PivotTables as the line between "basic" and "intermediate" Excel.

15. Charts and Conditional Formatting

Charts: select the names and sales (B1:B6 and D1:D6), then Insert > Recommended Charts and choose a column chart. Give it a clear title.

Conditional formatting: select D2:D6, then Home > Conditional Formatting > Highlight Cells Rules > Greater Than and enter 1000. Values above the target are highlighted automatically, which is useful for reports and dashboards.

Useful Keyboard Shortcuts (Windows)

ShortcutAction
Ctrl + C / Ctrl + VCopy / paste
Ctrl + ZUndo
Ctrl + TCreate a table
Ctrl + Arrow keyJump to the edge of data
Ctrl + Shift + LTurn filters on or off
F2Edit the active cell
Alt + =Insert AutoSum

Mac users generally replace Ctrl with Cmd for copy, paste and undo; some other shortcuts differ.

Common Errors and What They Mean

ErrorUsual cause
#N/AA lookup couldn't find the value (check spelling and spaces)
#DIV/0!Dividing by zero or an empty cell
#VALUE!Text where a number was expected
#REF!A formula refers to a deleted cell
#NAME?A misspelled function name, or a function your version doesn't have
######The column is too narrow; widen it

How to Describe Excel Skills on Your CV

Instead of "good in Excel", list specific skills you can demonstrate:

  • Basic: "Microsoft Excel: data entry, formatting, sorting, filtering, SUM and AVERAGE."
  • Intermediate: "Microsoft Excel: IF, SUMIF, COUNTIF, VLOOKUP/XLOOKUP, PivotTables and charts."

Better still, add a bullet showing how you used it, for example "Built a spreadsheet to track monthly club expenses with automatic totals by category." Be ready to demonstrate any skill you list; some employers give a practical Excel test. For more CV advice, see our complete CV guide.

A 2-Week Practice Plan

  • Days 1-3: data entry, formatting, sorting, filtering, freeze panes and tables.
  • Days 4-7: SUM, AVERAGE, COUNT, MIN/MAX, IF, SUMIF, COUNTIF; absolute references.
  • Days 8-10: VLOOKUP and XLOOKUP with a list of at least 30 rows.
  • Days 11-14: PivotTables, charts and conditional formatting; build a one-page report from your own data, such as a personal budget.

Conclusion

You don't need to master every Excel feature to be valuable in an office. The 15 skills here (clean data, sorting and filtering, core formulas, lookups, PivotTables and clear charts) cover most everyday tasks. Practise them on real data, describe them specifically on your CV, and you'll stand out from candidates who simply write "computer literate."

Your next step: type the practice table into Excel today and try every formula in Part 2. Then try tracking your own monthly spending, which our first-salary budgeting guide explains.

Frequently Asked Questions

What Excel skills do employers want most?

Commonly requested skills include data entry and formatting, sorting and filtering, SUM and other basic formulas, IF statements, lookup functions such as VLOOKUP, PivotTables and charts.

What is the difference between VLOOKUP and XLOOKUP?

Both find a value and return related information. XLOOKUP is newer and more flexible, letting you choose lookup and return columns separately, but it's only available in newer versions such as Microsoft 365, Excel 2021 and Excel 2024.

How long does it take to learn Excel for an office job?

Many people learn the essential skills in this guide with a couple of weeks of regular practice. Becoming fast and confident takes ongoing use with real data.

Can I learn Excel without a computer?

The Excel mobile app lets you practise many basics on a phone or tablet, but a computer is much better for larger sheets and PivotTables.

How should I list Excel on my CV?

List specific functions and features you can use, such as SUMIF, VLOOKUP and PivotTables, and add an example of how you've used them.

Sources

Menu names refer to recent Windows versions of Excel; other versions may differ slightly. Practice data is fictional. Last reviewed: November 2026.

✅ How to apply safely
  • Apply only through the official channel stated in this advert (Ajira Portal, the employer's website or email).
  • Never pay money to get a job. Genuine employers do not ask for payment.
  • Check the deadline and the required qualifications before you apply.
  • Seen a fake advert or a broken link? Let us know here.

Comments

Comments

Post a Comment