The Problem & The Solution
You Learned Excel. Then You Forgot It. Here's Why — And The Fix.
By Akash Verma • June 2026 • 6 min read
The Problem: Learning Without Practice
You watched YouTube videos. You took a paid course. You even passed an Excel test once. But when your manager asked you to write a VLOOKUP at work — your mind went blank.
You're not alone. This happens to 90% of Excel learners in India. Here's why:
- Video tutorials don't make you type. You watch someone do VLOOKUP and think "I got it." But watching is not doing. Your fingers never learned the formula.
- Courses teach theory, not muscle memory. You learn the syntax of SUMIFS but never practice it 20 times with different conditions. So when a new condition appears at work — you're stuck.
- No real data to practice on. Textbook examples use 5 rows. Real work has 5,000 rows with messy data, duplicates, blank cells, and mixed formats. The gap is massive.
- No way to check your answers. You write a formula but don't know if it's correct. There's no teacher, no answer key, no instant feedback. You might be practicing mistakes.
- You learn 10 formulas at once, remember none. Cramming doesn't work. You need spaced, focused practice — one formula at a time, with enough repetitions to lock it in.
- You forget within 2 weeks. Without consistent practice, your brain discards what it considers unused knowledge. This is called the "forgetting curve" — and Excel formulas are its biggest victim.
The Solution: Practice Like Real Work
Verma Learning is an Excel workbook (.xlsm) that gives you 7,000+ practice questions across 90 formulas — with real Indian datasets and instant answer checking. You type the formula. It tells you if you're right. Immediately.
- You type every formula yourself. No watching. No copy-pasting. Your hands learn the syntax through repetition.
- Real datasets from Indian companies. Employee records, sales data, inventory logs — the kind of data you'll actually see at work.
- Instant answer checking. Type your formula → cell turns green (correct) or red (wrong). No waiting, no guessing, no answer key to flip to.
- 90 formulas covered systematically. From SUM to LAMBDA. Organized by difficulty level. You know exactly what to learn next.
- Works offline in Excel. No internet needed. No login. No subscription. Download once, practice forever.
- Free. Completely free. No hidden charges, no "premium" lock, no trial period. Every question is accessible from day one.
How Verma Learning Works
Open the file in Excel. Pick a formula. Read the question. Type your answer. Get instant feedback.
1
Download the File
One .xlsm file. 8 MB. Works in Excel 2016, 2019, 2021, and 365.
2
Pick a Formula
Choose from 90 formulas organized by category — Lookup, Math, Text, Date, Logical, Arrays.
3
Read the Question
Each question tells you exactly what to find — using real data already in the sheet.
4
Type Your Formula
Write the formula in the answer cell. No hints, no auto-complete — just you and Excel.
5
Get Instant Feedback
Cell turns green = correct. Red = wrong. Fix it and try again until it clicks.
6
Track Your Progress
See how many questions you've solved per formula. Know your weak areas.
What It Looks Like Inside
This is exactly how the practice sheet looks. Real data. Real questions. Real-time checking.
Verma-Learning.xlsm — VLOOKUP Practice
File
Home
Insert
Page Layout
Formulas
Data
Review
View
| 1 |
Emp ID |
Name |
Department |
Question |
Your Answer |
Status |
| 2 | DATA TABLE (Employees) |
| 3 |
E001 |
Rahul Kumar |
Sales |
Find department of E003 |
=VLOOKUP("E003",$A:$C,3,0) |
Correct |
| 4 |
E002 |
Priya Singh |
MIS |
Find name of E005 |
=VLOOKUP("E005",$A:$C,2,0) |
Correct |
| 5 |
E003 |
Amit Patel |
Finance |
Find department of E001 |
=VLOOKUP("E001",$A:$C,2,0) |
Wrong |
| 6 |
E004 |
Neha Sharma |
HR |
Find name of E002 |
Type your formula... |
— |
| 7 |
E005 |
Vikram Joshi |
IT |
Find department of E004 |
Type your formula... |
— |
| 8 |
E006 |
Ritu Verma |
Operations |
Count employees in Sales |
=COUNTIF(C:C,"Sales") |
Correct |
Green = your formula is correct |
Red = wrong, try again |
Yellow = not attempted yet
Another Example: SUMIFS Practice
Verma-Learning.xlsm — SUMIFS Practice
File
Home
Insert
Page Layout
Formulas
Data
| 1 |
Order ID |
Region |
Category |
Revenue |
Question |
Your Answer |
Status |
| 2 |
1001 |
North |
Electronics |
45,000 |
Total revenue from South region |
=SUMIF(B:B,"South",D:D) |
Correct |
| 3 |
1002 |
South |
Clothing |
12,500 |
Revenue: North + Electronics |
=SUMIFS(D:D,B:B,"North",C:C,"Electronics") |
Correct |
| 4 |
1003 |
North |
Clothing |
8,200 |
Revenue: orders above 20,000 |
=SUMIFS(D:D,D:D,">"&20000) |
Wrong |
| 5 |
1004 |
West |
Electronics |
67,800 |
Count orders from West |
Type your formula... |
— |
| 6 |
1005 |
South |
Grocery |
3,400 |
Avg revenue from North |
Type your formula... |
— |
Before vs After Verma Learning
Before
- Watch 3-hour YouTube video on VLOOKUP
- Feel confident for 2 days
- Forget the syntax by day 5
- Google "VLOOKUP syntax" every time at work
- Panic during Excel test in interview
- Blame yourself: "I'm not good at Excel"
After
- Practice 20 VLOOKUP questions in 30 minutes
- Instant feedback on every answer
- Syntax becomes muscle memory by day 3
- Write VLOOKUP without thinking at work
- Clear Excel test in first attempt
- Know exactly which formulas to learn next
What's Inside
7,000+
Practice Questions
90
Excel Formulas
5
Difficulty Levels
100%
Free Forever
Who Is This For?
- Students preparing for campus placements and Excel tests
- Job seekers preparing for MIS Executive, Data Analyst, or Accountant interviews
- Working professionals who use Excel daily but still Google formulas
- Career switchers moving into data roles and need Excel from scratch
- Freelancers who want to offer Excel/data services on Upwork or Fiverr
- Anyone who watched an Excel course but can't remember the formulas
Stop Watching. Start Practicing.
Download Verma Learning. Pick a formula. Type 20 answers. You'll remember it forever.
Download Free — vermalearning.com
No login. No email. No payment. Just download and start.