Guide

What is Verma Learning?

By Akash Verma • June 2026 • 5 min read

The Problem

You know Excel formulas from textbooks. You've watched YouTube tutorials. But when you sit in a job interview and they give you a real dataset and say "write a VLOOKUP to find this" — your mind goes blank.

That's because knowing a formula and using it on real data are two different skills. Most people learn the syntax but never practice on actual datasets. Verma Learning fixes this.

What is Verma Learning?

Verma Learning is a free downloadable Excel workbook (.xlsm file) that gives you real, dataset-based formula practice questions — right inside Microsoft Excel.

No website. No app. No subscription. You download one file, open it in Excel, and start practicing. The workbook connects to our server to load fresh questions every time.

How Does It Work?

Download and open — Get the .xlsm file from vermalearning.com. Open it in Microsoft Excel. Create a free account.

Click NEXT — A new question loads with a real dataset (names, cities, amounts, dates). The question tells you exactly what to find using a specific formula.

Write your formula — Type the formula in the answer cell, just like you would in a real job. No multiple choice. No hints. Real practice.

Click SUBMIT — The workbook checks your answer instantly. Right or wrong — you know immediately.

Track your progress — Your dashboard shows how many questions you've solved, your accuracy, and which formulas you're strong or weak in.

Features

7,000+ Questions

Fresh questions generated from real-world data patterns. You'll never run out of practice.

90 Excel Formulas

From basic SUM and IF to advanced XLOOKUP, INDEX+MATCH, SUMIFS, and more.

Real Datasets

Every question comes with a realistic dataset — invoices, employee records, sales data, dates.

Instant Answer Check

Click SUBMIT and know immediately if your formula is correct. No waiting.

Progress Dashboard

Track your daily practice, accuracy rate, and formula-wise performance over time.

Filter by Formula

Choose which formula to practice. Focus on your weak areas or explore new ones.

3 Difficulty Levels

Basic, Mid, and Advanced questions. Start easy, level up as you improve.

Works Offline

Once a question loads, you can solve it without internet. Only loading new questions needs a connection.

100% Free

No hidden charges. No premium tier. No ads. Just download and practice.

All 90 Formulas Available

Here is every Excel formula you can practice inside Verma Learning:

Lookup & Reference
VLOOKUP144 Qs
HLOOKUP72 Qs
XLOOKUP144 Qs
LOOKUP144 Qs
INDEX72 Qs
MATCH72 Qs
INDEX+MATCH144 Qs
XMATCH72 Qs
CHOOSE72 Qs
Math & Arithmetic
SUM72 Qs
SUMIF144 Qs
SUMIFS72 Qs
SUMPRODUCT72 Qs
PRODUCT72 Qs
ABS72 Qs
INT72 Qs
MOD72 Qs
POWER72 Qs
SQRT72 Qs
ROUND72 Qs
ROUNDUP72 Qs
ROUNDDOWN72 Qs
CEILING72 Qs
FLOOR72 Qs
SUBTOTAL72 Qs
AGGREGATE72 Qs
Statistics
AVERAGE72 Qs
AVERAGEIF72 Qs
AVERAGEIFS72 Qs
COUNT72 Qs
COUNTA72 Qs
COUNTBLANK72 Qs
COUNTIF144 Qs
COUNTIFS72 Qs
MAX72 Qs
MIN72 Qs
MEDIAN72 Qs
MODE72 Qs
LARGE72 Qs
SMALL72 Qs
RANK72 Qs
PERCENTILE72 Qs
QUARTILE72 Qs
STDEV72 Qs
VAR72 Qs
Text Functions
LEFT72 Qs
RIGHT72 Qs
MID72 Qs
LEN72 Qs
FIND72 Qs
SEARCH72 Qs
REPLACE72 Qs
SUBSTITUTE72 Qs
CONCAT72 Qs
CONCATENATE144 Qs
TEXTJOIN72 Qs
TEXT72 Qs
UPPER144 Qs
LOWER72 Qs
PROPER72 Qs
TRIM72 Qs
EXACT72 Qs
REPT72 Qs
VALUE72 Qs
CHAR72 Qs
CODE72 Qs
Date & Time
DATE72 Qs
DAY72 Qs
MONTH72 Qs
YEAR72 Qs
HOUR72 Qs
MINUTE72 Qs
SECOND72 Qs
DATEDIF72 Qs
EDATE72 Qs
EOMONTH72 Qs
NETWORKDAYS72 Qs
WORKDAY72 Qs
WEEKDAY72 Qs
WEEKNUM72 Qs
YEARFRAC72 Qs
Logical
IF72 Qs
IFS72 Qs
IFERROR72 Qs
IFNA72 Qs
AND72 Qs
OR72 Qs
NOT72 Qs
XOR72 Qs
SWITCH72 Qs

Ready to practice?

Download Verma Learning for free. 7,000+ questions. 90 formulas. Real datasets.

Download Free — vermalearning.com

Who Is This For?

Frequently Asked Questions

Is it really free?

Yes. No hidden charges, no premium version, no ads. Download and use it.

Does it work on Mac?

It works best on Windows with Microsoft Excel. Mac support for macros is limited. We recommend Windows Excel for the full experience.

Do I need internet?

You need internet to load new questions and submit answers. Once a question is loaded, you can solve it offline.

Is my data safe?

We only store your User ID, name, and practice scores. No personal data, no payment info, no tracking. The code connects only to vermalearning.com — nothing else.

How often are new questions added?

We regularly add new formulas and question patterns. The server sends fresh questions each time you click NEXT.

Start Practicing Now

Stop watching tutorials. Start solving real questions.

Download Verma Learning — It's Free