Excel for Finance Intermediate Lesson 8: Project – A Financial Ratio Dashboard
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 →Atul Vij
Excel for Finance Intermediate Lesson 7: A 13-Week Cash Flow Forecast
Excel for Finance Intermediate Lesson 7: A 13-Week Cash Flow Forecast
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…
Read article →Excel for Finance Intermediate Lesson 6: Budget vs Actual Variance Reporting
Excel for Finance Intermediate Lesson 6: Budget vs Actual Variance Reporting
Variance in rupees and %, Over/Under/OK status with tolerance bands, the biggest overspend and conditional formatting that makes problems obvious.
Read article →Free HTTPS for Your Website: Cloudflare Origin Certificate + Nginx (Full Strict)
Free HTTPS for Your Website: Cloudflare Origin Certificate + Nginx (Full Strict)
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,…
Read article →Excel for Finance Intermediate Lesson 5: TDS on Payments – Rates, Limits and No-PAN Cases
Excel for Finance Intermediate Lesson 5: TDS on Payments – Rates, Limits and No-PAN Cases
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…
Read article →Free Cloud Servers Compared: AWS vs Azure vs Google Cloud vs Oracle
Free Cloud Servers Compared: AWS vs Azure vs Google Cloud vs Oracle
What each big cloud really gives you for free — always-free vs 12-month trials, server sizes, limits and gotchas — and which to choose…
Read article →Excel for Finance Intermediate Lesson 4: GST Reconciliation – Books vs GSTR-2B
Excel for Finance Intermediate Lesson 4: GST Reconciliation – Books vs GSTR-2B
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…
Read article →Excel for Finance Intermediate Lesson 3: Depreciation – SLM, WDV and the 180-Day Rule
Excel for Finance Intermediate Lesson 3: Depreciation – SLM, WDV and the 180-Day Rule
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…
Read article →Excel for Finance Intermediate Lesson 2: NPV, IRR, XIRR and Payback
Excel for Finance Intermediate Lesson 2: NPV, IRR, XIRR and Payback
Compare two projects with NPV and IRR, find the payback year, and measure a real SIP return with XIRR using actual dates.
Read article →Excel for Finance Intermediate Lesson 1: Loan Schedules and the Effect of Prepayment
Excel for Finance Intermediate Lesson 1: Loan Schedules and the Effect of Prepayment
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,…
Read article →Host a Website for Free: Oracle Cloud Server + One Setup Script (Complete Guide)
Host a Website for Free: Oracle Cloud Server + One Setup Script (Complete Guide)
Step-by-step guide to an always-free Oracle Cloud server: create the VM, open ports, point your domain through Cloudflare, and run one script that installs…
Read article →Word Intermediate Lesson 8: Project – A Company Report Template (.dotx)
Word Intermediate Lesson 8: Project – A Company Report Template (.dotx)
Final project: a reusable company report template with styled headings, automatic numbering, a cover page with property fields, section-based page numbers and a TOC.
Read article →