=LET(x, FILTER(A:A, B:B>500),
SORTBY(x, C:C, -1))
>> 12 rows spilled
Analysis & Visualization
Raw data se pivot, model aur chart bana ke business question ka jawab de sakte ho.
- 8
- Modules
- 37
- Lessons
- 6–8
- Hours
fx Academy / Curriculum roadmap
Structured Learning Tracksसीखने के ट्रैक्स
A structured path from Basics → Advanced → Automation. Pick a track and work through it module by module, at your own pace.
- 8
- Learning tracks
- 49
- Modules
- 190
- Lessons
- 34
- Practice files
Recommended starting point
BeginnerEnglish + हिन्दी
Foundations
- Kisi bhi messy sheet ko clean karke usse formulas se sawaal pooch sakte ho.
- Modules & lessons
- 7 modules · 31 lessons
- Total duration
- 5–6 hrs, self-paced
Your progress0 of 31 lessons · 0%
Module roadmap7 modules
- 1Excel Setup & InterfaceExcel vs Google Sheets vs LibreOffice, Ribbon, Quick Access Toolbar, Name Box, Formula Bar, Workbook, Worksheet, Cell, Range5 lessons
- 2Data Entry & FormattingData types: text, number, date, boolean — Excel internally kaise store karta hai, Number formats + custom format codes (lakh/crore format), Conditional formatting: highlight rules, data bars, colour scales4 lessons
- 3Core FormulasFormula anatomy + relative/absolute/mixed refs ($) — the magic of F4, SUM, AVERAGE, COUNT vs COUNTA vs COUNTBLANK, MIN, MAX, IF — the basic building block of conditions7 lessons
- 4LookupsVLOOKUP — syntax and its 4 limitations, INDEX + MATCH — left lookup and flexible columns, XLOOKUP + XMATCH — the modern replacement4 lessons
- 5Text & Date FunctionsLEFT, RIGHT, MID, LEN, TRIM, CLEAN, UPPER/LOWER/PROPER, TEXTSPLIT, TEXTJOIN, CONCAT, & operator, Flash Fill — extraction by pattern, without formulas5 lessons
- 6Data CleaningRemove Duplicates + duplicate detection with COUNTIF, Text to Columns — delimited and fixed width, Find & Replace with wildcards (*, ?, ~)5 lessons
- 7CapstoneCapstone: clean a 2,000-row messy sales export + build a summary block1 lessons
All paths
Showing 8 tracksExplore specialized tracks
Go deeper into analysis, automation and dashboards once the foundations are in place.
Intermediate
75%Pivot KPI
Automation
Har mahine ka manual report kaam ek script me convert kar sakte ho.
- 7
- Modules
- 28
- Lessons
- 5–7
- Hours
Sub CleanReport()
ActiveSheet.UsedRange
End Sub
Excel 101SUMIFS
Career Boosters
Interview crack karne ke liye portfolio, resume aur answers ready.
- 4
- Modules
- 14
- Lessons
- 2–4
- Hours
=LET(x, FILTER(A:A, B:B>500),
SORTBY(x, C:C, -1))
>> 12 rows spilled
75%Pivot KPI
Python Data Analysis
Go beyond Excel limits — clean, analyse and automate data with pandas.
- 5
- Modules
- 20
- Lessons
- 18
- Hours
Sub CleanReport()
ActiveSheet.UsedRange
End Sub
Python Visualization
Turn data into clear charts and interactive dashboards with Python.
- 5
- Modules
- 18
- Lessons
- 14
- Hours
How it works
How ExcelWalaa tracks work
Every concept follows the same three-step loop, from theory to a working spreadsheet.
01Step 1 · Concept
Read & learn (पढ़ो और समझो)
Short lessons explain the logic behind every formula, with lesson pages in English and हिन्दी.
Bilingual lessons02Step 2 · Practice
Download & practice (अभ्यास करो)
Work on realistic practice files, answer the module quiz, and mark lessons complete as you go.
Practice workbooks03Step 3 · Mentorship
Verify with AI (AI से जांचो)
Stuck on a #N/A or #SPILL! error? Ask the AI tutor to debug your formula and explain the fix.
Ask AI tutor Peer & AI help
Stuck on a tricky formula or workbook?
Ask the AI tutor for an instant explanation, or post your question to the community.