Course Guide

What Excel Should You Learn?

Pick your job profile below. We'll show you exactly which formulas to learn, in what order, and what to practice first.

MIS Executive

Excel for MIS Executive

Build reports, summarize data, create dashboards — the daily life of an MIS role runs on these formulas.

35Formulas to Master

8 WeeksEstimated Time

₹15K–40KSalary Range

Phase 1 — Learn First (Week 1-2)

Daily Report Essentials

These formulas are used in every MIS report. Master them before anything else.

Must Learn First

VLOOKUP— pull data from master tables SUMIFS— sum by region, product, date COUNTIFS— count entries by criteria IF— categorize and flag data SUM— totals row in every report AVERAGE— averages in summary reports COUNT / COUNTA— row counts IFERROR— hide #N/A in VLOOKUP

Phase 2 — Core Skills (Week 3-4)

Report Building & Formatting

Create polished reports that managers actually want to read.

TEXT— format dates as "Jun-2026" CONCATENATE / &— build report headers LEFT / RIGHT / MID— extract codes from IDs TRIM— clean imported data UPPER / LOWER / PROPER— standardize names MAX / MIN— highest/lowest in reports LARGE / SMALL— Top 5 / Bottom 5 RANK— rank branches / salespeople

Phase 3 — Advanced MIS (Week 5-6)

Dynamic Dashboards & Cross-Sheet Work

Build dashboards that auto-update when data changes.

INDEX-MATCH— flexible lookups INDIRECT— dynamic sheet references OFFSET— dynamic chart ranges SUMPRODUCT— multi-condition calcs SUBTOTAL— filter-aware sums NETWORKDAYS— working days for attendance DATEDIF— tenure calculations EOMONTH— month-end reporting dates

Phase 4 — Senior MIS (Week 7-8)

Automation & Pivot Mastery

AGGREGATE— SUM ignoring errors CHOOSE— dynamic chart switching IFS / SWITCH— clean conditional logic XLOOKUP— modern VLOOKUP replacement

Beyond Formulas — Also Learn:

Pivot Tables — every MIS interview asks about this
Conditional Formatting — color-code reports for managers
Data Validation — dropdown lists in templates
Keyboard Shortcuts — Ctrl+Shift+L (filter), Alt+= (sum), F4 (lock ref)
Charts — column, line, combo charts for dashboards

Data Analyst

Excel for Data Analyst

Clean data, find patterns, build insights. Excel is your foundation before SQL, Python, and Tableau.

45Formulas to Master

12 WeeksEstimated Time

₹2.5–15 LPASalary Range

Phase 1 — Data Cleaning (Week 1-3)

Clean Messy Data Like a Pro

80% of analyst work is cleaning data. These formulas handle that.

Learn First

TRIM— remove extra spaces CLEAN— remove non-printable chars SUBSTITUTE— fix inconsistent data VALUE / NUMBERVALUE— text to number UPPER / LOWER / PROPER— standardize text LEFT / RIGHT / MID— extract from strings LEN— validate data length FIND / SEARCH— locate characters

Basic Aggregation

SUM / AVERAGE / COUNT COUNTA / COUNTBLANK MAX / MIN IF / AND / OR / NOT IFERROR / IFNA

Phase 2 — Core Analysis (Week 4-7)

Lookups & Multi-Condition Analysis

The #1 interview topic. Master these and you pass 80% of Excel tests.

Critical — Interview Questions

VLOOKUP— learn first, understand limits INDEX-MATCH— use as primary tool SUMIFS— multi-condition sums COUNTIFS— multi-condition counts AVERAGEIFS— conditional averages SUMPRODUCT— complex array calculations XLOOKUP— modern replacement (365)

Date Intelligence

YEAR / MONTH / DAY DATEDIF— duration calculations NETWORKDAYS— working days EOMONTH— end of month TEXT— format for reports

Phase 3 — Advanced (Week 8-10)

Statistics & Dynamic Arrays

LARGE / SMALL / RANK— Top N analysis MEDIAN / MODE / STDEV— statistical analysis UNIQUE— extract unique values SORT / SORTBY— dynamic sorted lists FILTER— formula-based filtering SEQUENCE— generate series LET— named intermediate calcs

Phase 4 — Pro Level (Week 11-12)

Power Query & Dashboards

AGGREGATE— error-safe aggregation INDIRECT— dynamic references OFFSET— dynamic ranges IFS / SWITCH— clean logic

Beyond Formulas — Also Learn:

Pivot Tables + Slicers — interactive summary and dashboards
Power Query — import, clean, transform, merge data
Charts — column, waterfall, combo, sparklines
Conditional Formatting — data bars, color scales, icon sets
After Excel: SQL → Tableau/Power BI → Python (Pandas)

Accountant / Finance

Excel for Accountant & Finance

Ledgers, reconciliation, tax calculations, audit trails — accuracy and speed are everything.

30Formulas to Master

8 WeeksEstimated Time

₹15K–50KSalary Range

Phase 1 — Accounting Basics (Week 1-2)

Ledger & Calculation Essentials

Learn First

SUM— totals for every ledger SUMIF / SUMIFS— sum by account, party, date IF— debit/credit classification ROUND— round to 2 decimals (critical!) ABS— absolute value for variances MAX / MIN— highest/lowest transactions COUNT / COUNTA— entry counts IFERROR— clean error handling

Phase 2 — Reconciliation (Week 3-4)

Match, Verify, Reconcile

VLOOKUP— match entries across books COUNTIF— find duplicates INDEX-MATCH— flexible matching EXACT— case-sensitive comparison TRIM— clean imported bank data VALUE— text numbers to actual numbers SUBSTITUTE— remove commas from amounts

Phase 3 — Tax & Date Calculations (Week 5-6)

GST, TDS, Due Dates

ROUNDUP / ROUNDDOWN— tax rounding rules MOD— check even/odd, installments INT— truncate to whole number DATE / YEAR / MONTH— extract date parts DATEDIF— days overdue / aging EDATE / EOMONTH— due date calculations NETWORKDAYS— working days for SLAs TEXT— format amounts and dates

Phase 4 — Advanced (Week 7-8)

Aging Reports & Financial Formulas

SUMPRODUCT— weighted averages, aging SUBTOTAL— sums in filtered views CONCATENATE— build narration strings IFS— aging bucket classification

Beyond Formulas — Also Learn:

Pivot Tables — summarize trial balance, party-wise reports
Data Validation — dropdown for account heads, party names
Protect Sheet / Cells — lock formula cells in shared templates
Custom Number Formats — Indian numbering (lakhs/crores)
Ctrl+1 (Format Cells) — the single most useful shortcut for accounting

HR Executive

Excel for HR & Admin

Attendance tracking, payroll calculation, leave management, employee reports.

25Formulas to Master

6 WeeksEstimated Time

₹15K–35KSalary Range

Phase 1 — Attendance & Leave (Week 1-2)

Track Who Was Present, Who Was Not

COUNTIF / COUNTIFS— count present/absent days NETWORKDAYS— working days in a month IF— mark present/absent/leave WEEKDAY— identify weekends TODAY— auto-update current date DATEDIF— employee tenure YEAR / MONTH / DAY— extract from dates

Phase 2 — Payroll & Lookup (Week 3-4)

Calculate Salary, Pull Employee Data

VLOOKUP— pull name/dept from master SUMIFS— total OT hours by department ROUND— round salary to nearest rupee SUM— total salary, deductions IFERROR— handle missing employee IDs CONCATENATE— build full name from parts PROPER— fix name capitalization

Phase 3 — Reports & Dashboards (Week 5-6)

HR Reports for Management

INDEX-MATCH— flexible lookups TEXT— format dates in reports EDATE— probation end date calc LARGE / RANK— top performers AVERAGEIFS— avg salary by dept SUBTOTAL— filtered report totals

Beyond Formulas — Also Learn:

Data Validation — dropdowns for department, designation, leave type
Conditional Formatting — highlight late arrivals, leave overuse
Pivot Tables — department-wise headcount and salary summary
Protect Sheet — lock payroll formulas, allow data entry only

Sales / Marketing

Excel for Sales & Marketing

Track targets, calculate commissions, analyze pipeline, and report on campaign performance.

25Formulas to Master

6 WeeksEstimated Time

₹15K–50KSalary Range

Phase 1 — Targets & Tracking (Week 1-2)

Daily Sales, Target vs Achievement

SUM / SUMIFS— total sales by person, region IF— target met / not met flag VLOOKUP— pull target from master COUNTIFS— count deals by stage AVERAGE— avg deal size MAX / MIN— best/worst day RANK— rank salespeople

Phase 2 — Commission & % Calc (Week 3-4)

Commission Slabs, Growth %, Variance

Nested IF / IFS— commission slab logic ROUND— round commission amounts SUMPRODUCT— weighted pipeline value TEXT— format % and currency LARGE— top 5 deals CONCATENATE— build client name + deal string

Phase 3 — Analysis & Reports (Week 5-6)

Pipeline Analysis & MoM Reports

INDEX-MATCH— flexible data pull DATEDIF— deal aging / cycle time NETWORKDAYS— working days in pipeline IFERROR— clean report output SUBTOTAL— filtered pipeline value

Beyond Formulas — Also Learn:

Pivot Tables — region-wise, product-wise sales summaries
Charts — target vs actual bar charts, trend lines
Conditional Formatting — red/yellow/green for target achievement
Slicers — interactive dashboards for sales managers

Operations / Logistics

Excel for Operations & Logistics

Inventory management, dispatch tracking, vendor reconciliation, stock reports.

25Formulas to Master

6 WeeksEstimated Time

₹15K–40KSalary Range

Phase 1 — Inventory Basics (Week 1-2)

Stock In, Stock Out, Balance

SUMIFS— stock in/out by product, date VLOOKUP— pull product details from master IF— reorder alert (stock < min) SUM— total stock value COUNTIF— count items below reorder level MAX / MIN— highest/lowest stock AVERAGE— average daily consumption

Phase 2 — Tracking & Matching (Week 3-4)

Dispatch Tracking, Vendor Matching

INDEX-MATCH— match across vendor/PO tables COUNTIFS— count dispatches by status DATEDIF— days since order placed NETWORKDAYS— delivery working days WORKDAY— expected delivery date IFERROR— handle missing entries TRIM / SUBSTITUTE— clean imported data

Phase 3 — Reports (Week 5-6)

Stock Reports & Aging Analysis

SUMPRODUCT— weighted stock value IFS— aging bucket (0-30, 30-60, 60+) TEXT— date formatting in reports SUBTOTAL— filtered totals RANK— rank products by movement LARGE— top-moving items

Beyond Formulas — Also Learn:

Pivot Tables — product-wise, vendor-wise stock summaries
Data Validation — dropdown for product codes, warehouse locations
Conditional Formatting — highlight low stock in red
Charts — stock trend lines, dispatch performance

Student / Fresher

Excel for Students & Freshers

Your first job will test your Excel. Start with the basics, build up to interview-level formulas.

20Formulas to Start

6 WeeksEstimated Time

₹10K–20KFirst Job Range

Phase 1 — Absolute Basics (Week 1-2)

Learn These Before Anything Else

If you're opening Excel for the first time, start here. These 8 formulas handle 60% of all Excel work.

SUM— add numbers AVERAGE— find the mean COUNT— count numbers IF— if this, then that MAX / MIN— highest / lowest LEN— count characters LEFT / RIGHT— extract text TRIM— clean spaces

Phase 2 — Conditional Formulas (Week 3-4)

Add Conditions to Your Calculations

SUMIF / SUMIFS— add with conditions COUNTIF / COUNTIFS— count with conditions AVERAGEIF— average with condition Nested IF— multiple conditions AND / OR— combine conditions CONCATENATE / &— join text

Phase 3 — Interview Ready (Week 5-6)

The Formulas Every Interview Tests

If you can do these without looking up syntax, you'll pass most entry-level Excel tests.

VLOOKUP— #1 interview formula IFERROR— wrap VLOOKUP for clean output INDEX-MATCH— bonus points in interviews TEXT— format dates/numbers UPPER / LOWER / PROPER— text formatting TODAY / NOW— date functions

Beyond Formulas — Also Learn:

Pivot Tables — asked in almost every interview
Sort & Filter — basic data management
Charts — at least column and line charts
Keyboard Shortcuts — Ctrl+C/V, Ctrl+Z, Ctrl+Home, F4
Tip: Practice 30 min/day for 6 weeks > watching 50 hours of tutorials

Freelancer

Excel for Freelancers

Client reports, invoice tracking, project billing, data entry gigs — Excel skills get you better-paying gigs.

25Formulas to Master

6 WeeksEstimated Time

₹300–2K/hrFreelance Rate

Phase 1 — Client Work Essentials (Week 1-2)

What Clients Ask For Most

VLOOKUP— 90% of data matching gigs SUMIFS— conditional totals IF / IFS— categorization tasks TRIM / CLEAN— data cleaning gigs SUBSTITUTE— find-replace at scale LEFT / RIGHT / MID— extract from messy data CONCATENATE / TEXTJOIN— merge fields COUNTIF— duplicate detection

Phase 2 — Advanced Gig Skills (Week 3-4)

Higher-Paying Work

INDEX-MATCH— complex matching jobs SUMPRODUCT— multi-condition analysis UNIQUE / FILTER / SORT— dynamic reports (365) IFERROR— clean deliverables TEXT— format output professionally ROUND— financial data

Phase 3 — Dashboard & Reporting (Week 5-6)

Premium Deliverables = Premium Rates

INDIRECT— dynamic dashboards OFFSET— auto-expanding charts SUBTOTAL— filtered reports LARGE / RANK— top N reports XLOOKUP— modern lookups (365)

Freelancer Tips:

Pivot Tables — clients love interactive summaries
Power Query — automate repetitive data cleaning = recurring clients
Protect Sheet — lock your formulas before delivering
Professional formatting — clean fonts, consistent colors, aligned numbers
Speed matters — faster delivery = more gigs = higher rates

Start Practicing Right Now

Pick your profile above, follow the learning path, and practice every formula in Verma Learning. 7,000+ questions. 90 formulas. Real datasets. Free.

Download Free — vermalearning.com