Why an Excel test for a job interview is now standard in Kerala
An Excel test for a job interview has become the first filter for accounts, MIS and analyst roles across Kerala, from chartered accountant firms in Thrissur to hospitals in Kochi and IT companies at Infopark and Technopark in Trivandrum. Employers learned that a degree certificate says very little about whether a candidate can summarise a sales sheet or match two lists of invoices, so they hand you a laptop and a dataset and watch what happens.
The good news is that these tests are predictable. The same dozen skills appear again and again, the format rarely changes, and a focused two-week plan is enough for most people. This guide walks through what is tested, which jobs use it, how MIS and accounts tests differ, and how to prepare without wasting time on features nobody asks about.
Thinking of starting? See the Advanced Excel course page.
What an Excel interview test looks like
Quick answer: A typical Excel interview test is one workbook with a raw dataset and five to ten tasks, completed in 20 to 45 minutes on a laptop at the office or through a shared file online. You are scored on whether the answers are right, whether your formulas are reusable, and how long you took.
The dataset is usually something close to the actual job: a month of sales transactions for a retail role, a vendor ledger for an accounts role, patient visit records for a hospital MIS role, or a shipment log for a logistics company. Tasks move from easy to hard. The first two or three check basics such as sorting, filtering and totals. The middle tasks check formulas and lookups. The last one or two ask for a pivot summary, a chart or a short dashboard.
Some employers add a few multiple-choice questions about Excel functions, and a few ask you to explain your approach out loud after the test. In both cases they are checking the same thing: do you understand what you did, or did you memorise a sequence of clicks?
Online tests through a shared workbook or a testing platform follow the same pattern, but the time limit is enforced automatically, so pacing matters even more.
The 12 skills most often tested
Quick answer: Excel skills for jobs fall into three levels. Basic tests check sorting, filtering, SUM, AVERAGE and formatting. Intermediate tests add IF, SUMIFS, COUNTIFS, VLOOKUP or XLOOKUP, pivot tables and charts. Advanced tests add Power Query, dynamic arrays, dashboards and basic macros.
| Level | Skills |
|---|
| Basic | Sorting, filtering, SUM, AVERAGE, cell formatting |
| Intermediate | IF, SUMIFS, COUNTIFS, VLOOKUP or XLOOKUP, pivot tables, charts |
| Advanced | Power Query, dynamic arrays, dashboards, basic macros |
The intermediate row is where most candidates win or lose. Almost every test includes at least one lookup between two sheets and at least one conditional sum. If you can write SUMIFS with three criteria and an XLOOKUP that returns a value from a second table without looking anything up, you are ahead of most applicants.
The advanced row only appears for MIS, analyst and senior accounts roles, but it is the row that separates a shortlisted candidate from the one who gets the offer. A clean one-page dashboard built from a pivot table and two charts shows an employer that you can report, not just calculate.
Which jobs in Kerala use Excel tests
Quick answer: Excel tests appear most often for accounts executive and GST roles, MIS executive roles, data analyst and business analyst roles, and back-office roles at trading companies. In Kerala that means firms in Kochi and Thrissur, hospitals and retail chains across the state, and IT companies at Infopark.
- Accounts executive and GST staff at Kochi and Thrissur firms, where the test often uses a ledger or a GST return working file.
- MIS executive at hospitals, retail chains and logistics companies, where the test is a daily or monthly report built from raw data.
- Data analyst and business analyst roles at Infopark, where Excel is the first round before SQL or Power BI questions.
- Back-office roles at Gulf-facing trading companies, where the test covers order sheets, price lists and currency conversions.
The common thread is that the job involves receiving data from someone else and turning it into something a manager can act on. If that describes the role you are applying for, expect a test even if the job advertisement does not mention one.
MIS executive Excel test: what is different
Quick answer: An MIS executive Excel test goes beyond formulas. You are usually given raw transaction data and asked to produce a summary report, a one-page dashboard and sometimes a Power Query step that cleans the data before reporting. Speed and layout both count.
MIS stands for management information systems, and in most Kerala companies the MIS executive is the person who turns daily operations data into the morning report. That means the interview test mirrors the job. A hospital might give you a week of outpatient records and ask for a department-wise summary with a trend chart. A retail chain might give you store-level sales and ask for a top-ten list, a region comparison and a variance against target.
Three things make MIS tests harder than accounts tests:
- Messy inputs: dates stored as text, blank rows, merged cells and inconsistent spellings that you have to clean first, usually with Power Query or a few TRIM, CLEAN and DATEVALUE formulas.
- Multiple outputs: a pivot table, a chart and a short written note about what the numbers show, all within the time limit.
- Layout judgement: the report has to be readable on one screen, with sensible number formats and no raw data showing.
Candidates who practise building the same dashboard from three or four different datasets tend to finish these tests with time to spare.
Advanced Excel for accounts jobs: what GST and accounts firms check
Quick answer: Accounts firms in Kochi and Thrissur check whether you can summarise a ledger with SUMIFS and COUNTIFS, match invoices between two lists with a lookup, build a GST or vendor summary with a pivot table, and present a clean statement. Advanced Excel for accounts jobs is less about fancy features and more about accuracy under time pressure.
A typical accounts test gives you a sales register and a purchase register and asks for things such as total taxable value by GST rate, a list of invoices that appear in one register but not the other, outstanding amounts by customer with ageing buckets, and a monthly summary ready to paste into a return working. Every one of these comes down to the intermediate skills in the table above, applied carefully.
Where accounts candidates lose marks is on detail: a lookup that returns the wrong column because the table was not locked with absolute references, a SUMIFS where the criteria range and sum range are different sizes, or a total that includes a header row. Practise on a real-looking ledger until these errors stop happening.
If you are also considering MIS or analyst roles, the same preparation carries over. You can see how Excel fits alongside SQL, Power BI and Python in the programmes at Cokonet Academy, and compare the options across all courses.
A two-week prep plan for the Excel test
Quick answer: Spend the first four days on formulas, the next four on pivot tables and charts, three days on Power Query and a dashboard, and the last three days on timed 30-minute mock tests. Practise every day on a real dataset, not on a blank sheet.
- Days 1-4: Formulas. IF, SUMIFS, COUNTIFS and XLOOKUP, with VLOOKUP as a fallback. Learn absolute and relative references properly, and practise nesting an IF inside a SUMIFS criteria or returning a lookup result into a calculation.
- Days 5-8: Pivot tables and charts on a real sales dataset. Build summaries by month, product and region, add calculated fields, group dates, and turn each summary into a clean bar or line chart. Learn to refresh a pivot when the source data changes.
- Days 9-11: Power Query cleaning and a one-page dashboard. Import a messy CSV, fix data types, split and merge columns, remove duplicates, then load the clean table and build a dashboard with two or three pivots, slicers and charts on a single sheet.
- Days 12-14: Timed mock tests of 30 minutes each. Download or build a dataset, write yourself eight tasks that climb from basic to advanced, set a timer and work through them. Review every mistake before the next attempt.
If you can finish a mock test in 25 minutes with no formula errors, you are ready for almost any accounts, MIS or back-office Excel test in Kerala. Analyst roles at Infopark may still add a SQL or Power BI round, but the Excel round will no longer be the thing that worries you.
Not sure which route fits you? Talk to a counsellor on the contact page or call +91 8075 400 500.
Common mistakes in timed Excel tests and how to avoid them
Most candidates who fail an Excel test know the functions. They lose because of habits that cost time or accuracy under pressure. Watch for these:
- Typing values instead of formulas. If the interviewer changes one input and your total does not update, the task is marked wrong even if the number was right.
- Not locking references. Copying a lookup down a column without an absolute reference on the table is the single most common error in accounts tests.
- Starting the hardest task first. Do the basic tasks quickly, bank those marks, then move to the pivot and dashboard tasks.
- Ignoring data types. Numbers stored as text and dates stored as text break SUMIFS and pivot grouping. Check and convert them before you start.
- Leaving the sheet messy. Unlabelled columns, raw data on the report sheet and default formatting make a correct answer look careless.
- Skipping the read-through. Spend the first two minutes reading every task so you can plan which helper columns to build once and reuse.
A simple routine fixes most of these: read all tasks, clean the data, build helper columns, answer basic tasks, then build the pivot and chart, and finally tidy the layout. Repeat that routine in every mock test until it is automatic.
Why Cokonet Academy
Cokonet Academy runs Advanced Excel, data analytics and business skills programmes at its campuses in Trivandrum and Kochi and through live online batches across Kerala. Visit us on Google: Cokonet Academy, Trivandrum and Cokonet Academy, Kochi.
- NSDC partner
- 11,200+ successful placements
- 50+ corporate hiring partners
- Expert trainers in SAP (FICO, MM, ABAP), AWS, Python with AI, Data Analytics, Power BI
- Hands-on practice on real datasets with timed mock tests and interview preparation
Advanced Excel course details
The Advanced Excel course at Cokonet Academy is built around the skills employers actually test, practised on the kinds of datasets you will meet at work.
- What it covers: Formulas and lookups (IF, SUMIFS, COUNTIFS, VLOOKUP, XLOOKUP), pivot tables and charts, data cleaning, Power Query, dynamic arrays, dashboards and basic macros
- Best for: Commerce and arts graduates, accounts and GST staff, MIS executives, and anyone preparing for analyst or back-office interviews
- Formats: Weekday batches, weekend batches and live online classes
- Locations: Classroom in Trivandrum and Kochi, with district-focused batches for Thrissur and Kochi, or online from anywhere in Kerala
- Includes: Timed practice tests, project files, mock interviews and placement support
See the full syllabus and the next batch dates on the Advanced Excel course page.
Visit our training centres
Walk in for a free career consultation and try a sample Excel test with a trainer. We are open Monday to Saturday, 9:30am to 10:00pm.
Enrol now
Walk into your next interview ready for the Excel round. Join the Advanced Excel course, explore Cokonet Academy, or call and WhatsApp +91 8075 400 500 today.
