The hard part of hiring a single Data Analyst intern is not finding applicants. It is writing a brief specific enough that the right applicants recognise themselves in it.
An Excel brief is usually an automation brief in disguise. The valuable intern here is the one who replaces the workbook, not the one who maintains it faster.
Worth separating from Data Analyst Trainee: same skills, different commitment. Excel Data Analyst Intern is a hire you scope around one deliverable, whereas data analyst trainee is a longer training commitment with a confirmation point. Pick the framing that matches what you can actually offer, because candidates read the difference.
Below: the skills worth testing, the work a student can genuinely finish in a term, 2026 stipend bands, and questions that have a wrong answer. Posting is free and takes about two minutes.
What a single Data Analyst intern actually does in the first 90 days
Write one of these into the listing. A named deliverable is the single biggest predictor of application quality we see on Data Analyst roles — it tells a good candidate the work is real.
- Rebuild the monthly workbook so refresh is one button rather than two hours
- Answer one real business question end to end and present it on one page
- Automate a report that is currently rebuilt by hand each week
- Audit one dataset for duplicates and nulls and document the fixes
Data Analyst skills worth screening for
These are the skills that appear in the actual work above. Anything that does not map to a deliverable does not belong in the job description either.
- 1Power Query instinct rather than more formulas
- 2SQL: joins, aggregation, window functions
- 3Excel to a genuine working level, including lookups and pivots
- 4Cleaning and validating a messy dataset
- 5Descriptive statistics and when an average lies
- 6Cohort and funnel analysis
- 7Communicating a finding in three sentences
- 8Chart choice
Ask for evidence rather than a claim: a repository, a dashboard, a report, a runbook. For Data Analyst especially, one thing they built and can explain beats a page of listed technologies.
Screening questions for excel data analyst intern
Every question here has a wrong answer, which is what makes it a screen rather than a conversation. Twenty minutes on these tells you more than an hour of "tell me about yourself".
Tell me about a time the data said something the stakeholder did not want to hear.
What a good answer shows: Backbone, which matters more than tooling
How do you check a number before you send it to a director?
What a good answer shows: Verification habits — reconcile against a known total
Give me a case where the average is misleading.
What a good answer shows: Statistical instinct
If a question stops discriminating between candidates, replace it — one everybody answers well is not screening anything.
Where the Data Analyst candidates come from
MyInternships.in carries a verified, India-wide pool of students and fresh graduates — from IITs, NITs, BITS, IIMs and Symbiosis through to strong regional engineering and commerce colleges. Profiles carry skill tags, so you can filter on SQL and Excel or Google Sheets rather than reading résumés.
- Skill tags — filter directly on SQL, Excel or Google Sheets, Power BI or Tableau and the rest of the Data Analyst stack
- Portfolio and project evidence attached to the profile, rather than a résumé alone
- Institute tier, if a specific campus cohort matters for this role
- City and willingness to relocate, or remote-only if the role is remote
- Prior data analyst exposure — coursework, personal projects or a previous internship
Our AI candidate finder takes a plain-English brief — "Data Analyst intern in Pune, SQL, available from June" — and ranks the pool against it instead of making you filter by hand.
What to pay a single Data Analyst intern in 2026
The working band is ₹12,000–₹30,000 a month. Paying under it does not save money — it costs you the candidates who had a second option.
Add the reviewer’s hours, tooling access and a laptop if the role needs one. That is the true cost — and it is still far below a lateral hire.
Late stipends are the most common complaint from interns in India and they travel fast through campus groups. It costs you next year’s pool as well as this one.
It filters for who can afford to work free, not who is good. It also roughly halves your applications, and removes most of the candidates who had a second option.
Bengaluru, Hyderabad, Pune, Mumbai, Gurugram and Noida sit at the top of the band. Tier-2 cities typically run 25–40% lower for the same skills and the same output.
Getting one Data Analyst intern to actually produce something
The difference between an intern who ships and one who does not is almost never talent. It is whether the work was ready on their first day and whether someone read it on their second week.
Laptop, accounts, repository or dataset access, and a task small enough to finish in two days. Interns who spend week one waiting for access rarely recover the momentum.
Read their work in the first week, not the fourth. Early correction on a small piece of Data Analyst work is cheap; late correction on a term’s work is not.
Someone who wants the output and will complain if it is wrong. Work with no audience is the fastest route to a disengaged intern.
Write down what a successful term would produce. Otherwise the end-of-term assessment becomes a memory of impressions, and that helps nobody.
How to post excel data analyst intern on MyInternships.in
You do not need a prepared job description. Answer a few questions in the chat and the assistant drafts the listing, title and skill tags for you.
Say what you need — "Excel Data Analyst Intern for a three-month project, SQL and Excel or Google Sheets" — and answer a few short questions. No forms.
Title, description, responsibilities and Data Analyst skill tags are drafted for you, then shown as a preview of the published page before anything goes live.
Verification happens before publication and usually takes under two working days on the free plan, or instantly on a paid plan.
Usually within a couple of hours. Shortlist using the screening questions above, or let the AI matcher rank the pool against your brief.
Free plan: one listing, live after verification. Starter ₹499: five listings a month, published instantly, full applicant contact and résumé access. Growth ₹999: fifteen listings with AI candidate matching.
Mistakes that cost you the good Data Analyst candidates
Four failures we see repeatedly on this kind of role, in rough order of what they cost.
A Data Analyst listing with fourteen required tools reads as a company that does not know what it needs. Strong candidates self-select out; the ones who apply anyway have inflated their CVs to match.
Analyst framing draws people who want to answer questions rather than run pipelines. Make sure there is a real question waiting, and a person who cares about the answer.
If nobody can name the problem this intern solves, the term will be filled with whatever is urgent that week, and the assessment at the end will be about attitude rather than output.
"Assist the team" tells a candidate nothing and tells you nothing at review time. Name the work, in the listing, from the deliverables above.
Excel Data Analyst Intern — frequently asked questions
Which Data Analyst skills are non-negotiable for excel data analyst intern?+
Insist on power Query instinct rather than more formulas, and on enough sQL: joins, aggregation, window functions to work unsupervised on small tasks. Excel to a genuine working level, including lookups and pivots is the third thing worth testing in the interview. Tool familiarity — SQL, Excel or Google Sheets, Power BI or Tableau — is a bonus rather than a filter: most of it is a week of learning for someone with the underlying skill.
What should we set as the goal for the term?+
One finished thing. Rebuild the monthly workbook so refresh is one button rather than two hours is the right size: real work someone on the team would otherwise do, small enough to finish, visible enough to assess. If they move quickly, answer one real business question end to end and present it on one page is the natural second piece. A term with three half-finished projects assesses nothing and teaches less.
What stipend should we pay excel data analyst intern in India?+
₹12,000 to ₹30,000 a month covers most of the market for this role. Metro product companies pay at the top of the band; tier-2 cities and services firms 25–40% lower. An unpaid listing filters for who can afford to work free rather than who is good, and roughly halves the applications you receive.
What is the fastest way to tell a strong Data Analyst candidate from a weak one?+
Ask about something that went wrong. "Tell me about a time the data said something the stakeholder did not want to hear." gets you backbone, which matters more than tooling, and two follow-up questions on their own example will tell you the depth. Candidates who have only studied the topic run out of specifics almost immediately.
What does it cost us in time to supervise one Data Analyst intern?+
Realistically two to four hours a week of a competent person: a longer session early on, then short daily availability and a weekly review. Below that, the intern stalls and produces nothing you can use. Above it, you are doing the work yourself. That time is the true cost of the hire, and it is what the stipend line in your budget does not show.
Does the "Excel" in Excel Data Analyst Intern change who we should hire?+
An Excel brief is usually an automation brief in disguise. The valuable intern here is the one who replaces the workbook, not the one who maintains it faster. In screening terms, that means adding one specific check: power Query instinct rather than more formulas.
How do we stop unqualified applications for excel data analyst intern?+
Specificity does most of the work. A listing that names the project, the tools and the deliverable filters itself, because candidates can tell whether they fit. Adding one screening question to the application — from the set above — removes most of the rest without adding a review round.
How quickly do applications arrive?+
First applications typically arrive within about two hours of the listing going live, and most employers hiring a Data Analyst intern have a workable shortlist inside a week. Speed depends more on how specific the brief is than on the stipend — a listing with a named project and named tools consistently outperforms a generic one at the same money.
Related roles employers hire alongside excel data analyst intern
Tools and pages for your hiring
Hire excel data analyst intern — post in about two minutes
Answer a few questions and our AI writes the description, suggests the title and tags the Data Analyst skills. Your company is verified, the listing goes live, and applications start arriving.