Beginner5–6 hrsEnglish + हिन्दी

Foundations

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

Modules: 7
Lessons: 31
Duration: 5–6 hrs

Your progress0 of 31 lessons · 0%

Module roadmap

1

Excel Setup & Interface

5 lessons · 30 min

Excel vs Google Sheets vs LibreOffice5 min Ribbon, Quick Access Toolbar, Name Box, Formula Bar8 min Workbook, Worksheet, Cell, Range5 min Navigation Shortcuts7 min File Formats: .xlsx, .xlsm, .csv, .xlsb5 min

2

Data Entry & Formatting

4 lessons · 45 min

Data types: text, number, date, boolean — Excel internally kaise store karta hai10 min Number formats + custom format codes (lakh/crore format)12 min Conditional formatting: highlight rules, data bars, colour scales10 min Excel Tables (Ctrl+T) — structured references aur auto-expand13 min

3

Core Formulas

7 lessons · 90 min

Formula anatomy + relative/absolute/mixed refs ($) — the magic of F412 min SUM, AVERAGE, COUNT vs COUNTA vs COUNTBLANK, MIN, MAX13 min IF — the basic building block of conditions13 min Nested IF vs IFS — when to switch13 min AND, OR, NOT — multiple conditions12 min SUMIFS, COUNTIFS, AVERAGEIFS — the most used functions15 min IFERROR, IFNA + common error codes (#N/A, #REF!, #VALUE!, #DIV/0!)12 min

4

Lookups

4 lessons · 60 min

VLOOKUP — syntax and its 4 limitations15 min INDEX + MATCH — left lookup and flexible columns15 min XLOOKUP + XMATCH — the modern replacement15 min Approximate match: grade brackets, tax slabs, commission tiers15 min

5

Text & Date Functions

5 lessons · 45 min

LEFT, RIGHT, MID, LEN, TRIM, CLEAN, UPPER/LOWER/PROPER9 min TEXTSPLIT, TEXTJOIN, CONCAT, & operator9 min Flash Fill — extraction by pattern, without formulas9 min Dates: TODAY, NOW, DATEDIF, EOMONTH, WEEKDAY, NETWORKDAYS9 min Date stored as text — the most common data problem and its fix9 min

6

Data Cleaning

5 lessons · 45 min

Remove Duplicates + duplicate detection with COUNTIF9 min Text to Columns — delimited and fixed width9 min Find & Replace with wildcards (*, ?, ~)9 min Data Validation dropdowns + dependent dropdowns9 min Sort, Filter, custom sort lists9 min

7

Capstone

1 lessons · 30 min

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

Foundations | ExcelWalaa