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
GST Reconciliation in Excel: Match GSTR-2B With Your Purchase Register

14 Sep 2021 · Excel for Finance · 2 min read

GST Reconciliation in Excel: Match GSTR-2B With Your Purchase Register

Step-by-step GSTR-2B vs purchase-register reconciliation in Excel: clean GSTINs and invoice numbers, build a match key, find missing and mismatched invoices, and prepare the vendor follow-up list.

Read article →
AMORLINC Function in Excel: Depreciation With Part-Year Start

13 Sep 2021 · Excel Functions A–Z · 1 min read

AMORLINC Function in Excel: Depreciation With Part-Year Start

AMORLINC returns straight-line depreciation for an accounting period, prorating the first period by purchase date (French accounting system).

Read article →
COUPDAYSNC Function in Excel: Days From Settlement to Next Coupon

12 Sep 2021 · Excel Functions A–Z · 1 min read

COUPDAYSNC Function in Excel: Days From Settlement to Next Coupon

COUPDAYSNC counts days from settlement to the next coupon date. Used for bond pricing and accrued interest on half-yearly coupons.

Read article →
COUPPCD Function in Excel: Previous Coupon Date

11 Sep 2021 · Excel Functions A–Z · 1 min read

COUPPCD Function in Excel: Previous Coupon Date

COUPPCD returns the last coupon date before settlement. Used for bond pricing and accrued interest on half-yearly coupons.

Read article →
COUPNCD Function in Excel: Next Coupon Date

8 Sep 2021 · Excel Functions A–Z · 1 min read

COUPNCD Function in Excel: Next Coupon Date

COUPNCD returns the next coupon date after settlement — useful for cash-flow calendars of a bond portfolio.

Read article →
COUPNUM Function in Excel: Coupons Left Until Maturity

3 Sep 2021 · Excel Functions A–Z · 1 min read

COUPNUM Function in Excel: Coupons Left Until Maturity

FinancialLevel: ExpertAvailable in: Excel 2007+COUPNUM counts coupon payments remaining.Syntax=COUPNUM(settlement, maturity, frequency.

Read article →
ODDFPRICE Function in Excel: Price of a Bond With an Odd First Period

2 Sep 2021 · Excel Functions A–Z · 1 min read

ODDFPRICE Function in Excel: Price of a Bond With an Odd First Period

ODDFPRICE prices a bond whose first coupon period is shorter or longer than normal.

Read article →
TBILLEQ Function in Excel: Bond-Equivalent Yield of a T-Bill

31 Aug 2021 · Excel Functions A–Z · 1 min read

TBILLEQ Function in Excel: Bond-Equivalent Yield of a T-Bill

TBILLEQ converts a T-bill discount rate into a bond-equivalent yield, so you can compare it with coupon bonds and FDs.

Read article →
PRICEDISC Function in Excel: Price of a Discounted Security

31 Aug 2021 · Excel Functions A–Z · 1 min read

PRICEDISC Function in Excel: Price of a Discounted Security

PRICEDISC returns the price per 100 of a discounted security such as a T-bill or commercial paper.

Read article →
YIELDMAT Function in Excel: Yield of a Security Paying Interest at Maturity

30 Aug 2021 · Excel Functions A–Z · 1 min read

YIELDMAT Function in Excel: Yield of a Security Paying Interest at Maturity

FinanceLevel: ExpertAvailable in: Excel 2007+YIELDMAT returns the yield of a security that pays interest at maturity.Syntax=YIELDMAT(settlement, maturity.

Read article →
ODDLPRICE Function in Excel: Price of a Bond With an Odd Last Period

30 Aug 2021 · Excel Functions A–Z · 1 min read

ODDLPRICE Function in Excel: Price of a Bond With an Odd Last Period

FinanceLevel: ExpertAvailable in: Excel 2007+ODDLPRICE prices a bond whose last coupon period is irregular.Syntax=ODDLPRICE(settlement, maturity.

Read article →
MDURATION Function in Excel: Modified Duration

29 Aug 2021 · Excel Functions A–Z · 1 min read

MDURATION Function in Excel: Modified Duration

MDURATION estimates the percentage price change for a 1% change in yield — the number fund managers quote.

Read article →
Older posts
Newer posts
← Previous Page1 … Page75 Page76 Page77 … 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? →