Excel 101SUMIFS
Foundations
Kisi bhi messy sheet ko clean karke usse formulas se sawaal pooch sakte ho.
- 7
- Modules
- 31
- Lessons
- 5–6
- Hours
New Year’s Resolution : Master your data अपनी भाषा में, अपनी रफ़्तार से
From your first formula to XLOOKUP, Power Query and VBA. Bite-sized tutorials, structured tracks, ready-to-use templates, and an AI tutor that explains in English and हिन्दी.
| A · Customer | B · City | C · Sales | |
|---|---|---|---|
| 2 | Sharma Traders | Jaipur | ₹ 4,82,000 |
| 3 | Mehta Textiles | Surat | ₹ 12,40,500 |
| 4 | Rao Electronics | Pune | ₹ 1,18,000 |
Walaa AI Tutor
English
Finds the customer in A2:A100 and returns their sales from column C. No sorting needed, and a missing name shows "Not Found" instead of #N/A.
हिन्दी में
यह फ़ॉर्मूला कॉलम A में ग्राहक का नाम ढूंढकर कॉलम C से उसकी बिक्री लाता है। नाम न मिले तो #N/A की जगह "Not Found" दिखता है।
Why ExcelWalaa
Built for real office work, not just theory
MIS reports, GST workings, dashboards and automation, taught the way you use them at work.
Structured Tracks
English + हिन्दीStep-by-step curricula from your first SUM to dashboards and automation, with quizzes and practice files.
8 learning tracks
Ask AI Tutor
Formula debuggerStuck on a #VALUE! error or a nested IF? Describe the problem and get a corrected formula with a plain explanation.
Answers in seconds
Ready-to-Use Sheets
.xlsx & Google SheetsDownload plug-and-play trackers, MIS dashboards and calculators you can adapt to your own data.
4 templates
Community Q&A
Peer problem solvingAsk about formulas, VBA, Power Query or charts and get help from people who solve the same problems at work.
8 discussions
Curated curriculum
All tracks Choose your learning track
Each track comes with lessons, quizzes and downloadable practice sheets.
Beginner
=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
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
Ask AI Tutor
Formula debugging, explained in your language
Describe what you want or paste the formula that is failing. The tutor explains the fix step by step, in English or हिन्दी.
- Fixes #N/A, #VALUE! and #REF! errors with reasons
- Ready-to-copy formulas for Excel and Google Sheets
- Hinglish-friendly explanations
Templates
View all templates Ready-made sheets (.xlsx)
Clean layouts and pre-built formulas you can adapt in minutes.
Community
Join the community Latest discussions
- dataTRIM ke baad bhi extra spaces hain — lookup match kyun nahi ho raha?by Neha Singh (Demo)
- dataWhy does my PivotTable show Count instead of Sum?by Ananya Das (Demo)
- chartsWhich chart would you choose for monthly actual vs target sales?by Kabir Rao (Demo)
- vbaVBA: find the last used row without hard-coding row numbersby Aarav Sharma (Demo)
- vbaCan one VBA button refresh all PivotTables in a workbook?by Rohan Patel (Demo)
Community spotlight
Share your favourite Excel tip and get highlighted in the next roundup.
Write for ExcelWalaaReady to become an Excel pro?
आज ही सीखना शुरू करें
Create an account to track your progress through the learning tracks.