Skip to content

AJ's Techie & Wacky World

  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact
  • 📲 Get App
Why Is Indian Standard Time 5 Hours 30 Minutes Ahead?

8 Jul 2025 · History · 2 min read

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 →
Excel Pivot Tables: The Complete Guide from First Click to Dashboard

30 Jun 2025 · Power Query & Pivots · 4 min read

Excel Pivot Tables: The Complete Guide from First Click to Dashboard

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 →
Excel for Finance Intermediate Lesson 8: Project – A Financial Ratio Dashboard

24 Jun 2025 · Excel for Finance · 1 min read

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 →
Excel for Finance Intermediate Lesson 7: A 13-Week Cash Flow Forecast

23 Jun 2025 · Excel for Finance · 1 min read

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 biggest outflow week.

Read article →
Excel for Finance Intermediate Lesson 6: Budget vs Actual Variance Reporting

22 Jun 2025 · Excel for Finance · 1 min read

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)

21 Jun 2025 · Cloud & Servers · 2 min read

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, force HTTPS and add HSTS — with troubleshooting for 525/526 errors.

Read article →
Excel for Finance Intermediate Lesson 5: TDS on Payments – Rates, Limits and No-PAN Cases

21 Jun 2025 · Excel for Finance · 1 min read

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 missing, and get the deposit due date.

Read article →
Free Cloud Servers Compared: AWS vs Azure vs Google Cloud vs Oracle

20 Jun 2025 · Cloud & Servers · 2 min read

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 for a website, a learning lab or a database.

Read article →
Excel for Finance Intermediate Lesson 4: GST Reconciliation – Books vs GSTR-2B

20 Jun 2025 · Excel for Finance · 2 min read

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 you can safely claim.

Read article →
Excel for Finance Intermediate Lesson 3: Depreciation – SLM, WDV and the 180-Day Rule

19 Jun 2025 · Excel for Finance · 2 min read

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 used under 180 days.

Read article →
Excel for Finance Intermediate Lesson 2: NPV, IRR, XIRR and Payback

18 Jun 2025 · Excel for Finance · 1 min read

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

17 Jun 2025 · Excel for Finance · 2 min read

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, CUMIPMT, CUMPRINC and NPER.

Read article →
Older posts
Newer posts
← Previous Page1 … Page44 Page45 Page46 … Page107 Next →

AJ's Techie & Wacky World

Curated by Atul Vij • © 2026 • All Rights Reserved

About Courses Free Tools Templates Privacy Policy Contact GitHub
Did you know?

Why? →