20 Excel Project Ideas to Master Analytics Tools in India (2026)

Most people learn Excel backwards. They watch a tutorial on VLOOKUP, then one on pivot tables, then one on Power Query, collecting individual tricks with nothing real to apply them to. Then an interviewer asks them to walk through something they actually built, and there is nothing to walk through, only a list of functions they can recite. The better way to learn Excel, and the tools built around it, is to pick a real problem and build the whole thing, formulas, structure, chart, and the recommendation at the end, the way you would if a manager actually asked for it. This guide gives you 20 project ideas that do exactly that, organised from basic to advanced, each with the skills it teaches, the tools involved, and where to find real data rather than invented numbers.

Dreaming of a Career in Data and Analytics? Start with the Data and Business Analytics Program with Jobaaj Learnings.

Why a Project Beats a Tutorial

A tutorial teaches you a function. A project teaches you when to use it, which is the actual skill.

A finished project produces four things a list of functions cannot. A file you can show in an interview and open live. A specific number you found and can explain. A decision you made about how to present it. And a mistake you caught along the way, which is often the most convincing part of the whole conversation.

The mistake most learners make is building the same three projects everyone else builds: a sales dashboard with no real data behind it, a to-do list tracker, and a budget template copied from a video. Interviewers have seen all three many times. The projects below are chosen to be genuinely useful practice and to produce something worth discussing, not to be original for its own sake.

Where to Get Real Data

Every project below is stronger with real numbers behind it. These sources are free and widely used.

Kaggle carries thousands of public datasets across sales, HR, finance, health and sport, most downloadable as a clean CSV ready for Excel.

data.gov.in publishes genuine Indian government data on agriculture, transport, health and the economy, and using it signals you can work with real, sometimes messy, public data.

Your own life is a legitimate data source. Bank statements with personal details removed, a family business's sales records, your own fitness tracker export, or a college club's event data all make for a project with a story behind it that a downloaded dataset does not have.

Company annual reports and investor presentations, particularly for listed Indian companies, contain years of genuine financial data that most learners never think to use.

Level 1: Foundational Excel Projects

Start here if you are building genuine comfort with formulas and structure before adding complexity.

1. Personal or Household Budget Tracker

Build a monthly budget with income, fixed expenses, variable expenses and savings, using formulas rather than typing totals by hand.

Skills: SUM, SUMIF, basic conditional formatting
Tools: Excel or Google Sheets
Difficulty: Beginner

2. Student Grade and Attendance Tracker

Track marks and attendance across subjects for a class, calculating averages, pass or fail status, and attendance percentage automatically.

Skills: AVERAGE, IF, COUNTIF, conditional formatting for at-risk students
Tools: Excel
Difficulty: Beginner

3. Inventory Tracker for a Small Business

Track stock levels, reorder points and stock value for a small shop or a family business, with a formula that flags items needing reorder.

Skills: IF statements, SUMPRODUCT for stock value, data validation for entry
Tools: Excel
Difficulty: Beginner to intermediate

4. Multi-Sheet Sales Summary Using VLOOKUP and INDEX MATCH

Take sales data split across several sheets, by region or by month, and build a summary sheet that pulls and consolidates it using lookups rather than copy-paste.

Skills: VLOOKUP, INDEX MATCH, cross-sheet referencing
Tools: Excel
Difficulty: Beginner to intermediate

Why this one matters more than it looks: VLOOKUP and INDEX MATCH remain the single most commonly tested Excel skill in interviews, and building a real multi-sheet file is what actually cements the difference between the two, rather than memorising when each is supposedly better.

Level 2: Intermediate Projects, Pivot Tables and Dashboards

5. Sales Performance Dashboard Using Pivot Tables

Take a year of transaction-level sales data and build a dashboard summarising revenue by product, region and month, with pivot charts and slicers for interactivity.

Skills: Pivot tables, pivot charts, slicers
Tools: Excel
Difficulty: Intermediate

6. HR Attrition and Headcount Dashboard

Using a public HR dataset, build a dashboard showing headcount by department, attrition rate by tenure band, and a breakdown of who is leaving and when.

Skills: Pivot tables, calculated fields, conditional formatting
Tools: Excel
Difficulty: Intermediate

For the questions this kind of project prepares you for, see our guide to HR projects for students.

7. Customer Segmentation Using RFM Analysis

Segment customers by recency, frequency and monetary value of purchases, a genuine technique used in retail and marketing analytics, and identify your highest-value and most at-risk customer groups.

Skills: Nested formulas, ranking functions, conditional logic
Tools: Excel
Difficulty: Intermediate

8. Break-Even and Profitability Analysis for a Small Business

Model fixed costs, variable costs and pricing for a hypothetical or real small business, and calculate the break-even point and profit at different sales volumes.

Skills: Goal Seek, data tables for sensitivity analysis, charting
Tools: Excel
Difficulty: Intermediate

9. Loan and EMI Calculator With Amortisation Schedule

Build a working EMI calculator for a home or car loan, showing the full month-by-month breakdown of principal and interest paid over the loan term.

Skills: PMT, IPMT, PPMT financial functions, amortisation logic
Tools: Excel
Difficulty: Intermediate

10. Marketing Campaign ROI Tracker

Track spend, clicks, conversions and revenue across several marketing channels, calculating cost per acquisition and return on ad spend for each.

Skills: Calculated ratios, comparative charting, conditional formatting for underperforming channels
Tools: Excel
Difficulty: Intermediate

Level 3: Advanced Excel, Power Query and Automation

11. Clean and Consolidate a Messy Real-World Dataset

Take a genuinely messy dataset, inconsistent date formats, duplicate entries, mixed text case, missing values, and clean it entirely using Power Query rather than manual editing.

Skills: Power Query, data transformation, deduplication
Tools: Excel (Power Query)
Difficulty: Advanced

Why this is one of the most valuable projects on this list: cleaning messy data is most of what real analytics work actually is, and almost no learner practises it deliberately, because tutorial datasets are always clean.

12. Automate a Recurring Report With Power Query and Macros

Build a report that currently takes manual work, pulling from multiple files or sheets, and automate the refresh using Power Query, with a simple macro to run and format it in one click.

Skills: Power Query, basic VBA or macro recording
Tools: Excel
Difficulty: Advanced

How to talk about this one in an interview: state the actual time saved. "Reduced a weekly two-hour manual report to a five-minute refresh" is a far stronger resume line than "automated a report."

13. Dynamic Dashboard With Slicers, Timelines and Form Controls

Build an interactive dashboard where a user can filter by date range, region and product category using slicers and timelines, with charts updating live.

Skills: Advanced pivot tables, slicers, timelines, form controls
Tools: Excel
Difficulty: Advanced

14. Financial Statement Analysis Using a Real Company's Annual Report

Take three years of a listed Indian company's actual financial statements and build a model calculating key ratios: gross margin, current ratio, debt-to-equity and return on equity, with year-over-year trend charts.

Skills: Financial ratio formulas, INDEX MATCH across years, trend analysis
Tools: Excel
Difficulty: Advanced

15. Build a Simple CRM in Excel

Design a working customer relationship tracker: contact details, interaction history, deal stage and next follow-up date, with conditional formatting flagging overdue follow-ups.

Skills: Data validation, conditional formatting, drop-down lists, basic database structure
Tools: Excel
Difficulty: Advanced

Level 4: Beyond Excel, Into Power BI and SQL

Excel has a ceiling. These projects use the same analytical thinking but move into the tools that take over once a dataset gets too large or a dashboard needs to be shared live with a team.

16. Rebuild One of Your Excel Dashboards in Power BI

Take a dashboard you already built in Excel, the sales or HR dashboard from Level 2, and rebuild it in Power BI. This is the single best way to learn Power BI, because you already know what the answer should look like.

Skills: Power BI data modelling, DAX basics, visual design
Tools: Power BI Desktop (free)
Difficulty: Intermediate to advanced

17. Connect Excel to a SQL Database

Set up a small database in MySQL or SQLite, write queries to extract and aggregate data, then connect Excel to it using Power Query so your Excel report updates directly from the database rather than a static file.

Skills: Basic SQL, Power Query database connections
Tools: Excel, MySQL or SQLite
Difficulty: Advanced

18. Build a Google Sheets Version With Live Data Import

Recreate one of your Excel projects in Google Sheets using IMPORTRANGE and Google Apps Script, and compare what each tool does better, since many companies use Google Workspace rather than Microsoft Office.

Skills: Google Sheets functions, IMPORTRANGE, basic Apps Script
Tools: Google Sheets
Difficulty: Intermediate

19. A/B Test Analysis for a Marketing or Product Decision

Take a dataset comparing two versions of something, a website, an email subject line, a pricing test, and determine statistically whether the difference in results is meaningful or just noise.

Skills: Basic statistical functions, T-tests in Excel, interpreting significance
Tools: Excel, optionally Power BI for visualisation
Difficulty: Advanced

20. End-to-End Capstone: Excel to Power BI to a Written Recommendation

Choose a real business question, a genuine problem, not a topic, using a dataset from Kaggle or data.gov.in. Clean it in Power Query, build the analysis in Excel, visualise the result in Power BI, and write a one-page recommendation stating what you found and what you would do about it.

Skills: The full pipeline, cleaning, analysis, visualisation, communication
Tools: Excel, Power BI
Difficulty: Advanced

This is the project to lead with in an interview. It is the only one on this list that demonstrates the entire analytics workflow rather than one skill in isolation, and it is what a real analytics job actually looks like day to day.

How to Choose the Right Project for You

One strong project beats five weak ones. A single dashboard you can open live and explain in detail, including a mistake you caught while building it, is worth more in an interview than five half-finished templates.

How to Put These Projects on Your Resume

Compare these two lines.

Weak:

Built an Excel dashboard for sales data.

Strong:

Sales Performance Dashboard | Excel, Pivot Tables, Power Query

• Consolidated 14 months of transaction-level sales data across 3 regional sheets using Power Query
• Built an interactive pivot dashboard with slicers, identifying that one region accounted for 40% of revenue but only 22% of marketing spend
• Recommended reallocating budget toward the underserved high-performing region

Three things changed. The tools are named explicitly. The finding is specific and numeric. And there is a recommendation, which is what separates an analyst from someone who can only produce a chart.

Six Mistakes That Weaken Excel Projects

• Using invented or randomly generated numbers. A recruiter can usually tell, and it removes any real finding you could have discussed.
• Building a dashboard with no actual question behind it. A chart is not an analysis until it answers something specific.
• Stopping at the visual. The recommendation at the end is what separates a project from a picture.
• Skipping Power Query entirely. It is one of the most in-demand and least-practised Excel skills, precisely because tutorials rarely cover it properly.
• Never mentioning the tools by name in your project description. Recruiters search for Power Query, pivot tables and DAX by name.
• Doing five shallow projects instead of one you can defend for ten minutes. Depth is what actually gets discussed in an interview.

Final Thoughts

The learners who get hired are rarely the ones who know the most Excel functions. They are the ones who can open a file, point at a number, and explain exactly why it matters and what they would do about it.

So pick one project from this list that genuinely interests you, use real data rather than invented numbers, and take it all the way to a recommendation rather than stopping at a chart. Then be honest in the interview about the one thing you got wrong while building it. That single habit, choosing depth over a long list, is what turns a tutorial exercise into something worth talking about.