Excel for India Course: GST, TDS, Salary & Tally (Free)

📊
← All courses

Excel for India Course: GST, TDS, Salary & Tally (Free)

📘 7 / 7 lessons⬇️ 0 practice files🌱 Beginner💸 Free

Excel tutorials are usually written for US offices. This free course is for Indian work: lakhs and crores, April-to-March years, GST, PF and ESI, TDS on salary, Tally exports and bank reconciliation. Every lesson has formulas you can copy.

What you will be able to do

  • Show numbers as ₹12,34,567 and convert to lakhs and crores
  • Get FY, quarter and month-of-year from any date
  • Build a GST invoice register that splits CGST/SGST/IGST and summarises for GSTR-1
  • Make a salary slip with PF, ESI and professional tax
  • Estimate monthly TDS under the new and old regimes
  • Clean a Tally export and reconcile it with the bank statement

Lessons

  1. 1Indian Number Format in Excel: Lakhs and CroresShow ₹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…
  2. 2Financial 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…
  3. 3GST Invoice Register in Excel and a GSTR-1 SummaryBuild a sales register that splits CGST, SGST and IGST automatically from the GSTIN state code, then summarise B2B and B2C sales…
  4. 4Salary Slip in Excel with PF, ESI and Professional TaxBuild a monthly salary slip template: earnings, PF on capped wages, ESI eligibility, professional tax, LOP days and net pay, with formulas…
  5. 5TDS on Salary in Excel: New vs Old Regime CalculatorEstimate annual tax and monthly TDS for tax year 2026-27 with one SUMPRODUCT formula per regime, including standard deduction, rebate, marginal relief…
  6. 6Clean 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…
  7. 7Bank Reconciliation in Excel with XLOOKUP and FILTERMatch your books with the bank statement: build a matching key, find entries missing on either side with XLOOKUP, handle duplicates with…
Advertisement