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:

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.

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
E4
fx =VLOOKUP(D4, $A$2:$C$20, 3, FALSE)
A B C D E F
1 Emp ID Name Department Question Your Answer Status
2DATA 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
G3
fx =SUMIFS(D:D, B:B, "North", C:C, "Electronics")
A B C D F G H
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?

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.