Basic Excel Skills for Office Jobs (With Practice Tasks)
Basic Excel opens many office jobs. These are the skills employers check most often, the formulas to learn first, and short tasks to practise at home.
By Raaz sharma. Published 2 Nov 2026. 3 min read.
The short answer: for most office, data entry and back office jobs, employers expect you to enter and format data, sort and filter, use SUM, AVERAGE, COUNT and IF, and look up values with VLOOKUP or XLOOKUP. You can learn these in two to three weeks with daily practice.
Skills employers check most
| Skill | Used for |
|---|---|
| Data entry and formatting | Clean, readable sheets |
| Sort and filter | Finding records quickly |
| SUM, AVERAGE, COUNT | Totals and simple reports |
| IF | Marking pass/fail, target met or not |
| VLOOKUP / XLOOKUP | Bringing data from one sheet into another |
| Remove duplicates | Cleaning customer or product lists |
| Pivot table (basic) | Summaries by city, product or month |
Formulas to learn first
=SUM(B2:B20)— adds a column=AVERAGE(B2:B20)— average value=COUNTA(A2:A200)— counts filled cells=IF(C2>=50,"Pass","Fail")— simple condition=COUNTIF(D2:D200,"Jaipur")— counts matching entries=VLOOKUP(A2,Prices!A:B,2,FALSE)— finds a value from another sheet=TRIM(A2)— removes extra spaces
Practice tasks
- Sales sheet: make columns Date, Product, Quantity, Price, Amount. Use a formula for Amount (Quantity × Price) and SUM for the total.
- Marks sheet: enter marks for 10 students and use IF to show Pass or Fail, then sort from highest to lowest.
- City count: list 30 customers with cities and use COUNTIF to count each city.
- Price lookup: make a price list on one sheet and use VLOOKUP to bring prices into an order sheet.
- Clean a list: paste a list with duplicates and extra spaces, then use Remove Duplicates and TRIM.
- Pivot: create a pivot table showing total sales by product.
Keyboard shortcuts that save time
- Ctrl + C / Ctrl + V — copy and paste
- Ctrl + Z — undo
- Ctrl + Arrow key — jump to the end of data
- Ctrl + Shift + L — turn filters on or off
- Ctrl + ; — insert today's date
How to show Excel on your resume
Write specific skills, not just "MS Excel": for example "MS Excel — VLOOKUP, IF, COUNTIF, pivot tables". Be ready for a short Excel test in the interview.
Free tools: Google Sheets works the same way for these basics and is free on any phone or computer.
Use your skills: data entry and back office jobs and accounts jobs on JobZeno. See also data entry job explained.
Frequently asked questions
What Excel skills are required for an office job?
Data entry and formatting, sort and filter, SUM, AVERAGE, COUNT, IF, VLOOKUP and basic pivot tables cover most office job requirements.
How long does it take to learn basic Excel?
About two to three weeks with 30 to 60 minutes of daily practice for the basics.
Is Google Sheets the same as Excel?
For basic formulas, sorting, filtering and lookups, Google Sheets works almost the same and is free.
Do I need a certificate to show Excel skills?
Not always. Employers usually give a short practical test. A course certificate helps, but practical skill matters more.
Related articles
Career growth
What Is a Notice Period? Duration, Buyout and Rules Explained
Resigning? Your notice period decides when you can leave. Here is how notice periods work in India, how to shorten one, and how to leave on good terms.
2 Nov 2026 · 3 min read
Career growth
Documents Required for Joining a New Company: Full Checklist
Joining a new job? Keep these documents ready so your joining, salary account and PF are set up without delay. Includes a checklist for freshers and experienced hires.
2 Nov 2026 · 3 min read
Career growth
First Job Tips for Freshers: How to Do Well in Your First 90 Days
Got your first job? The first three months shape how your manager sees you. Here is a simple plan to settle in, learn fast and pass your probation.
2 Nov 2026 · 3 min read