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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Power Query Intermediate Lesson 1: Parameters – One Folder Path for Every Query
Power Query Intermediate Lesson 1: Parameters – One Folder Path for Every Query
Stop editing ten queries when the file moves: read the folder path from a named cell or a parameter, and filter with typed dates.
Read article →DCOUNTA Function in Excel: Count Non-Empty Records Matching Criteria
DCOUNTA Function in Excel: Count Non-Empty Records Matching Criteria
DCOUNTA counts non-blank entries in a field for records that meet the criteria; unlike DCOUNT it also counts text. Like all D-functions it uses…
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 →Split Full Names Into First, Middle and Last Name in Excel
Split Full Names Into First, Middle and Last Name in Excel
Separate "Asha Kumari Sharma" into first, middle and last names with TEXTBEFORE/TEXTAFTER/TEXTSPLIT, older LEFT/FIND/MID formulas, Flash Fill and Text to Columns — and handle…
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 →EUROCONVERT Function in Excel: Convert Between Euro and Old Euro-Zone Currencies
EUROCONVERT Function in Excel: Convert Between Euro and Old Euro-Zone Currencies
EUROCONVERT converts between the euro and former national currencies (DEM, FRF, ITL …) at the fixed 1999-2002 rates. It needs the Euro Currency Tools…
Read article →DVARP Function in Excel: Population Variance of Matching Records
DVARP Function in Excel: Population Variance of Matching Records
DVARP returns the population variance for matching records. Like all D-functions it uses a database range and a criteria range you can edit on…
Read article →VBA Project: Generate PDF Invoices From Excel and Email Them Automatically
VBA Project: Generate PDF Invoices From Excel and Email Them Automatically
A complete VBA project: fill an invoice template from a data sheet, export each invoice to PDF with a proper file name, and email…
Read article →