Most Excel interviews in Pakistan do not test whether you have “heard of” a feature. They hand you a messy sheet and ask you to clean it, look up values from another table, summarise it with a PivotTable and explain what the numbers mean, often in a short timed window. If you can do those four things calmly and accurately, you will be well prepared for most Excel interview skills tests for office, accounts, sales and data roles in Faisalabad.
This guide lists the skills employers actually check, how the tests are usually set up, and a practice plan you can follow at home. If you want structured, hands-on practice with an instructor, our Advanced Excel course in Faisalabad covers each of these areas with real workplace files.
How Excel interview tests are usually set up
Employers use a few common formats. In every one, the hidden test is accuracy: a fast answer with one wrong total loses to a correct, clearly labelled one.
- Practical file test: You get a workbook (sales, stock, attendance or payroll data) and a list of tasks. This is a common format for accounts assistants, MIS officers, admin staff and merchandisers in textile and export companies.
- Screen-share or live task: The interviewer watches while you work. They are checking speed, shortcuts and whether you panic when a formula returns an error.
- Verbal questions: “What is the difference between VLOOKUP and XLOOKUP?” or “How would you remove duplicates?” These are easier to answer if you have actually done the task many times.
- Take-home assignment: Usually for analyst roles. You build a small report or dashboard and explain your choices.
The core Excel skills employers test
1. Data cleaning
Real company data is messy: extra spaces, names in different cases, dates stored as text, duplicate rows and merged cells. Expect tasks like:
- Removing duplicates and blank rows
- Using
TRIM,PROPER,UPPERandCLEAN - Splitting full names or codes with Text to Columns, Flash Fill or
TEXTSPLIT - Converting text dates and numbers into real dates and numbers
2. Lookup formulas
This is one of the most tested areas. You will very likely be asked to pull a price, a department or a customer name from a second table.
VLOOKUPwith exact match (and knowing why approximate match gives wrong results)XLOOKUP, which is simpler and can look leftINDEX+MATCH, still common in older company files- Handling missing values with
IFERRORor the “if not found” argument in XLOOKUP
Be ready to explain the difference between them in one or two sentences. Many companies in Pakistan still use older Excel versions, so do not rely only on XLOOKUP.
3. Logical and conditional formulas
IF, nestedIFandIFS(for example, grading or commission slabs)AND/ORinside IFSUMIFS,COUNTIFSandAVERAGEIFSwith more than one condition
A typical question: “Total sales for the Lahore region in March for product category A.” That is one SUMIFS formula, and interviewers watch whether you lock references correctly with $.
4. PivotTables
If lookups are the key formula skill, PivotTables are the key summary skill. You should be able to:
- Create a PivotTable from a clean range or Table
- Summarise by month, region, product or salesperson
- Change Sum to Count or Average, and show values as a percentage of total
- Group dates by month or quarter
- Add a slicer and refresh the pivot after the data changes
5. Formatting, tables and charts
Employers want reports a manager can read in ten seconds. That means converting ranges to Tables, using consistent number formats, conditional formatting to highlight late payments or low stock, and one clear chart instead of five decorative ones.
6. Data validation and protection
For admin and accounts roles you may be asked to create a drop-down list, restrict a column to dates only, or protect formula cells so other staff cannot overwrite them.
7. Speed and shortcuts
Nobody expects you to know every shortcut, but using Ctrl + Arrow keys, Ctrl + Shift + L for filters, Ctrl + T for tables and F4 to lock references shows you use Excel daily, not just occasionally.
Which skills matter for which job
The level expected depends on the role. Use this table to decide where to focus.
| Role | Must be comfortable with | Good to add |
|---|---|---|
| Admin / front office | Formatting, sorting, filtering, basic SUM/IF, data validation | Simple PivotTables |
| Accounts assistant | SUMIFS, lookups, date functions, PivotTables, number formats | Reconciliation with lookups, protection |
| Sales / merchandising (textile, export) | Lookups, PivotTables, conditional formatting, charts | Dashboards with slicers |
| MIS / data analyst | All of the above, data cleaning, dynamic arrays | Power Query, Power Pivot, basic macros |
If you are applying for entry-level office jobs, our guide on typing speed and data entry skills for Faisalabad office jobs covers the basics that sit underneath Excel work. If you are aiming at analyst roles, read Excel vs Power BI vs Python for data analytics careers to see where Excel fits.
Common interview tasks and how to approach them
- “Clean this list and remove duplicates.” Make a copy of the sheet first. Trim spaces, fix case, then remove duplicates on the right columns, not the whole row blindly.
- “Bring the price from the Products sheet into the Orders sheet.” Use XLOOKUP or INDEX/MATCH with exact match, wrap it in IFERROR, then spot-check three rows manually.
- “Show total sales by region and month.” Convert data to a Table, insert a PivotTable, group dates by month, and format values with thousand separators.
- “Highlight customers with outstanding balance above a limit.” Conditional formatting with a formula rule, linked to a cell holding the limit so it is easy to change.
- “Calculate commission based on slabs.” Use IFS or a lookup table with approximate match, and explain why a lookup table is easier to update than nested IFs.
When you finish, tell the interviewer what you checked. “I compared the pivot total with a simple SUM of the original column and they match” is exactly the kind of habit employers want.
Excel interview preparation checklist
- Practise on at least three different messy datasets (sales, stock, attendance)
- Write VLOOKUP, XLOOKUP and INDEX/MATCH from memory without help
- Build a PivotTable with date grouping and a slicer in under five minutes
- Use SUMIFS and COUNTIFS with two or more conditions
- Know how to fix
#N/A,#VALUE!and#REF!errors - Create a drop-down list with data validation
- Make one clean chart and one simple one-page report
- Prepare a one-minute explanation of a sheet you have built
- Check which Excel version the company uses, if you can
A simple two-week practice plan
Days 1–3: Data cleaning and formatting. Take any downloaded sample dataset and make it tidy.
Days 4–6: Lookups. Build two linked sheets and pull values in both directions.
Days 7–9: SUMIFS, COUNTIFS and IF logic using commission or grading examples.
Days 10–12: PivotTables, charts and slicers. Build a one-page summary.
Days 13–14: Timed mock tests. Give yourself 30 minutes and five tasks, then review mistakes.
How CYBEX can help
CYBEX School of IT Professionals has been teaching in Faisalabad since 2017. We are PSDA-registered and NAVTTC-accredited, and our classes are held at P23 Chanab Market, Susan Road. Our Advanced Excel course is practical: you work on the same kinds of files employers use in interview tests, including cleaning, lookups, PivotTables, dashboards and reporting, with an instructor to review your work and help you fix mistakes.
It suits university students from Government College University Faisalabad (GCUF), Government College Women University Faisalabad (GCWUF), The University of Faisalabad (TUF), National Textile University (NTU) and University of Agriculture Faisalabad (UAF), as well as job seekers and people already working in offices who want to be faster and more confident. A course builds skill; getting the job still depends on your practice, your CV and how you perform on the day.
Common questions
Is VLOOKUP still asked in interviews if XLOOKUP exists?
Yes. Many company files and older Excel versions still rely on VLOOKUP, so interviewers often ask about it. Learn both, plus INDEX/MATCH.
Do I need macros or VBA for an Excel interview?
For most admin, accounts and sales roles, no. Macros are more relevant for MIS and analyst jobs. Get lookups and PivotTables solid first.
How long does it take to become interview-ready in Excel?
It depends on your starting level and how much you practise. Someone comfortable with basic Excel can usually become confident in the core skills above with a few weeks of regular, focused practice.
Should I put “Advanced Excel” on my CV?
Only if you can actually do the tasks in this guide under time pressure. Interviewers often test exactly what you claim, so list specific skills such as PivotTables, XLOOKUP and SUMIFS instead.
What is the fee for the Advanced Excel course?
Message us on WhatsApp for the current fee.
Get ready for your next Excel test
If you have an interview coming up or want to stop guessing in Excel, start with the checklist above and practise on real data. For guided, hands-on training, see our Advanced Excel course in Faisalabad or message us on WhatsApp at 0302 7833985 to ask about the course and the current fee.