Learn Excel
to Excel.
Practical Excel training built for Indian finance and commerce professionals — real ₹ examples, corporate scenarios, and formulas you'll actually use in MIS reports, job interviews, and everyday spreadsheets.
| A | B | |
|---|---|---|
| 1 | Month | Sales (₹) |
| 2 | April | 45,000 |
| 3 | May | 62,500 |
| 4 | June | 58,200 |
| 5 | July | 71,000 |
| 6 | August | 38,900 |
| 7 | Total | 2,75,600 |
Three formulas. One learning path.
Every conditional summing function builds on the same idea as SUM. Work through the series in order and each part compounds on the last — no gaps, no guesswork.
SUM — the foundation
Add numbers, cell references, or entire ranges. Handles up to 255 arguments and ignores empty or text cells automatically.
=SUM(number1, [number2], …)SUMIF — add with one condition
Sum only the rows that match a single criterion — region, category, or status. The most-used formula in sales and accounts reporting.
=SUMIF(range, criteria, sum_range)SUMIFS — add with multiple conditions
Layer several criteria at once — region AND product AND month. The power formula behind every real MIS dashboard.
=SUMIFS(sum_range, range1, criteria1, …)Excel in 60 minutes — what you must know
Every shortcut, formula, and technique from the 1-hour MS Excel Job Readiness Workshop, timed to the minute.
Shortcuts & Navigation
12 keyboard shortcuts that save hours every week.
Core Formulas
IF, IFS, SUMIF, COUNTIF, TEXT and DATE functions.
Lookup Functions
VLOOKUP, XLOOKUP and INDEX+MATCH, side by side.
Pivot Tables
Summarise 10,000 rows in 30 seconds, no formulas.
Formatting & Validation
Conditional formatting and drop-down data entry.
Charts
The right chart for the right data, every time.
Bonus Tricks
Flash Fill, Remove Duplicates, Freeze Panes.
Full reference sheet
Every formula and shortcut, in one printable table.
Built for how Indian finance teams actually work
Every example uses Indian Rupee figures — GST, payroll, and sales in context you recognise.
Bonus eligibility, invoice ageing, employee tenure — scenarios pulled from real MIS work.
Each function series builds on the last — SUM before SUMIF, SUMIF before SUMIFS.
Templates and workbooks you keep — P&L trackers, dashboards, valuation models.
Dr. Abhijeet Chatterjee
Finance education, built spreadsheet by spreadsheet.
Dr. Abhijeet Chatterjee teaches Excel the way finance and commerce professionals actually need it — grounded in Indian Rupee figures, real corporate scenarios, and the formulas that show up in job interviews and MIS reports alike.
Through tubeshaala, that training takes shape as a structured Excel Functions Series, downloadable workbooks, and the 1-hour Job Readiness Workshop delivered to commerce and finance audiences across India.