Foundations

Beginner5–6 hrs

Kisi bhi messy sheet ko clean karke usse formulas se sawaal pooch sakte ho.

Progress: 0 / 31 lessons (0%)

M1 · Excel Setup & Interface

30 min

45 min

90 min

Formula anatomy + relative/absolute/mixed refs ($) — F4 ka jaaduSoon

SUM, AVERAGE, COUNT vs COUNTA vs COUNTBLANK, MIN, MAXSoon

IF — condition ki basic building blockSoon

Nested IF vs IFS — kab switch karna haiSoon

AND, OR, NOT — multiple conditionsSoon

SUMIFS, COUNTIFS, AVERAGEIFS — sabse zyada use hone wale functionsSoon

IFERROR, IFNA + common error codes (#N/A, #REF!, #VALUE!, #DIV/0!)Soon

60 min

VLOOKUP — syntax aur uski 4 limitationsSoon

INDEX + MATCH — left lookup aur flexible columnsSoon

XLOOKUP + XMATCH — modern replacementSoon

Approximate match: grade brackets, tax slabs, commission tiersSoon

45 min

LEFT, RIGHT, MID, LEN, TRIM, CLEAN, UPPER/LOWER/PROPERSoon

TEXTSPLIT, TEXTJOIN, CONCAT, & operatorSoon

Flash Fill — pattern se extraction bina formula keSoon

Dates: TODAY, NOW, DATEDIF, EOMONTH, WEEKDAY, NETWORKDAYSSoon

Date stored as text — sabse common data problem aur uska fixSoon

45 min

Remove Duplicates + duplicate detection with COUNTIFSoon

Text to Columns — delimited aur fixed widthSoon

Find & Replace with wildcards (*, ?, ~)Soon

Data Validation dropdowns + dependent dropdownsSoon

Sort, Filter, custom sort listsSoon

30 min

Capstone: clean a 2,000-row messy sales export + build a summary blockSoon