Why Is Indian Standard Time 5 Hours 30 Minutes Ahead?
IST is set by the 82.5° East meridian near Mirzapur — exactly 5½ hours from Greenwich. How India chose a half-hour time zone and the old Bombay and Calcutta times it replaced.
Read article →IST is set by the 82.5° East meridian near Mirzapur — exactly 5½ hours from Greenwich. How India chose a half-hour time zone and the old Bombay and Calcutta times it replaced.
Read article →Build pivot tables step by step: layout, value settings, Show Values As, grouping dates, slicers and timelines, calculated fields, distinct counts, GETPIVOTDATA, refresh tricks and common problems.
Read article →Final project: margins, current and quick ratio, debtor days, debt-to-equity, interest cover and growth for two years, with a one-page dashboard.
Read article →Build a rolling 13-week cash forecast: running balance with SCAN, the first week below the minimum buffer, how much funding is needed and the biggest outflow week.
Read article →Variance in rupees and %, Over/Under/OK status with tolerance bands, the biggest overspend and conditional formatting that makes problems obvious.
Read article →Set up end-to-end HTTPS for free with Cloudflare in front of an Nginx server: create an Origin Certificate, install it, choose Full (strict) mode, force HTTPS and add HSTS — with troubleshooting for 525/526 errors.
Read article →Calculate TDS on contractor, professional and rent payments with a rate table and XLOOKUP, apply single-payment limits and the higher rate when PAN is missing, and get the deposit due date.
Read article →What each big cloud really gives you for free — always-free vs 12-month trials, server sizes, limits and gotchas — and which to choose for a website, a learning lab or a database.
Read article →Match purchase invoices in your books with GSTR-2B by GSTIN and invoice number: find missing invoices, extra ones and value differences, and the ITC you can safely claim.
Read article →Book depreciation under the Companies Act (SLM and WDV from useful life), time-proportionate depreciation, and income-tax block rates with the half rate for assets used under 180 days.
Read article →Compare two projects with NPV and IRR, find the payback year, and measure a real SIP return with XIRR using actual dates.
Read article →EMI, interest and principal split, year-1 interest for tax, outstanding balance and how many EMIs a ₹2 lakh prepayment saves, with PMT, IPMT, PPMT, CUMIPMT, CUMPRINC and NPER.
Read article →