Bank Reconciliation in Excel with XLOOKUP and FILTER
Match your books with the bank statement: build a matching key, find entries missing on either side with XLOOKUP, handle duplicates with COUNTIFS and…
Read article →Excel for India
📊
← Excel
Excel for India
Practical, tested tutorials on Excel for India.
📄 7 articles🕒 Updated 13 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →Clean a Tally Export in Excel (Dr/Cr, Blank Rows, Ledger Names)
Clean a Tally Export in Excel (Dr/Cr, Blank Rows, Ledger Names)
Turn a Tally day book or ledger export into a clean table: remove header clutter, split Dr and Cr amounts, fill ledger names down…
Read article →TDS on Salary in Excel: New vs Old Regime Calculator
TDS on Salary in Excel: New vs Old Regime Calculator
Estimate annual tax and monthly TDS for tax year 2026-27 with one SUMPRODUCT formula per regime, including standard deduction, rebate, marginal relief and 4%…
Read article →Salary Slip in Excel with PF, ESI and Professional Tax
Salary Slip in Excel with PF, ESI and Professional Tax
Build a monthly salary slip template: earnings, PF on capped wages, ESI eligibility, professional tax, LOP days and net pay, with formulas you can…
Read article →GST Invoice Register in Excel and a GSTR-1 Summary
GST Invoice Register in Excel and a GSTR-1 Summary
Build a sales register that splits CGST, SGST and IGST automatically from the GSTIN state code, then summarise B2B and B2C sales by rate…
Read article →Financial Year in Excel: FY, Quarters and Months (April to March)
Financial Year in Excel: FY, Quarters and Months (April to March)
Formulas for the Indian financial year: FY label from a date, fiscal quarter, fiscal month number, FY start and end dates, and a pivot-ready…
Read article →Indian Number Format in Excel: Lakhs and Crores
Indian Number Format in Excel: Lakhs and Crores
Show ₹12,34,567 instead of 1,234,567 with a custom number format, display amounts in lakhs or crores, and write numbers in words for cheques and…
Read article →