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 →Atul Vij
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 →Context Windows Explained: How Much Can an AI Read at Once?
Context Windows Explained: How Much Can an AI Read at Once?
What an AI model's context window is, why long chats get worse, what happens when you hit the limit, and practical ways to work…
Read article →MaxL Basics: Automate Essbase Data Loads and Calculations
MaxL Basics: Automate Essbase Data Loads and Calculations
Use MaxL scripts to automate Essbase: log in, clear and load data with a rules file, run a calculation and log errors — with…
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 →Smart View Lesson 1: What Essbase and Smart View Are
Smart View Lesson 1: What Essbase and Smart View Are
Understand Essbase cubes, dimensions, members and hierarchies, how Smart View connects Excel to them, and where it fits with Planning and EPM Cloud.
Read article →Ship It Safely: Secrets, Data and Maintenance
Ship It Safely: Secrets, Data and Maintenance
Share your AI-built tool responsibly: keep API keys out of code, protect personal data, write a README, version it with Git and plan for…
Read article →Check AI Code: Tests, Reviews and Red Flags
Check AI Code: Tests, Reviews and Red Flags
How non-developers can verify AI-written code: expected-output tests, a 10-point review checklist, asking a second AI to review, and red flags that mean stop.
Read article →