Archive

Every Ask Eijaz article in one place — the full archive of Excel, data and analytics write-ups, newest first and grouped by year.

2026

Aug 27
Build an ASC 842 Lease Modification Tracker That Auto-Remeasures Liabilities and ROU Assets Excel 365
Aug 26
Build an ASC 606 Contract Modification Engine That Auto-Classifies and Calculates Catch-Up Adjustments Excel 365
Aug 19
Why Your NPV Is Wrong (and the XNPV Fix Analysts Swear By) Excel 365
Aug 19
Build a Loan Amortization Schedule in One Formula (No Helper Columns) Excel 365
Aug 17
Tiered Commission Formulas in Excel 365: Why VLOOKUP Gets It Wrong Excel 365
Aug 17
How to Find the LAST Matching Value (Not the First) in a List Excel 365
Aug 17
Fix Top-N Lists That Duplicate a Name When Scores Tie Excel 365
Aug 17
Build a Dropdown List That Removes Items Once They're Picked Excel 365