← Blog
📚 FREE SERIES📊 ExcelUpdated August 2026
30 Days Excel Interview Series
150+ Excel interview questions with complete answers — from basics to Power Query and domain applications. Free for all aspiring data analysts in India.
30
Days
150+
Questions
10
Topics
Free
Forever
Start Day 1 →
No login required. Completely free.
Week 1 — Fundamentals & Core Formulas
D1Beginner
Excel Basics & Navigation
Fundamentals · 5 questions
D2Beginner
Data Entry & Formatting
Fundamentals · 5 questions
D3Beginner
Essential Formulas — Part 1
Formulas · 5 questions
D4Beginner
Essential Formulas — Part 2
Formulas · 5 questions
D5Beginner
VLOOKUP & HLOOKUP
Lookup Functions · 5 questions
D6Intermediate
INDEX & MATCH
Lookup Functions · 5 questions
D7Intermediate
XLOOKUP & Modern Lookup Functions
Lookup Functions · 5 questions
Week 2 — Pivot Tables & Power Query
D8Beginner
Pivot Tables — Fundamentals
Pivot Tables · 5 questions
D9Intermediate
Pivot Tables — Advanced
Pivot Tables · 5 questions
D10Beginner
Charts & Data Visualisation
Visualisation · 5 questions
D11Beginner
Conditional Formatting
Analysis Tools · 5 questions
D12Intermediate
Data Validation
Data Quality · 5 questions
D13Intermediate
Power Query — Basics
Power Query · 5 questions
D14Intermediate
Power Query — Advanced Transformations
Power Query · 5 questions
Week 3 — Advanced Analysis & Dashboards
D15Advanced
Array Formulas & Dynamic Arrays
Advanced Formulas · 5 questions
D16Intermediate
Date & Time Functions
Formulas · 5 questions
D17Intermediate
Text Functions & Data Cleaning
Data Cleaning · 5 questions
D18Intermediate
Statistical Functions for Analysis
Analysis · 5 questions
D19Intermediate
Excel Tables & Structured References
Data Management · 5 questions
D20Intermediate
Excel Dashboards
Dashboards · 5 questions
D21Advanced
Advanced Charts & Visualisation
Visualisation · 5 questions
Week 4 — Domain Applications & Automation
D22Intermediate
Scenario Analysis & What-If Tools
Analysis Tools · 5 questions
D23Advanced
Macros & VBA Basics
Automation · 5 questions
D24Beginner
Excel Shortcuts & Productivity
Productivity · 5 questions
D25Intermediate
Error Handling & Troubleshooting
Troubleshooting · 5 questions
D26Intermediate
Financial Analysis in Excel
Finance · 5 questions
D27Intermediate
HR & People Analytics in Excel
Domain Application · 5 questions
D28Intermediate
Sales & Marketing Analytics in Excel
Domain Application · 5 questions
Final 2 — Best Practices & Mock Interview
More Free Interview Series
Want live Excel training with real projects?
Join EVIKA Academy's Data Analyst course and master Excel, SQL, Power BI and Python with job placement support in Delhi NCR.
Book Free Demo →