Build a CSV Cleaner Without Writing Code Yourself
A complete vibe-coding session: from a messy bank or vendor export to a clean file, built step by step with an AI assistant, with…
Read article →Atul Vij
DVARP Function in Excel: Population Variance of Matching Records
DVARP Function in Excel: Population Variance of Matching Records
DVARP returns the population variance for matching records. Like all D-functions it uses a database range and a criteria range you can edit on…
Read article →Describe It Well: Prompts That Produce Working Code
Describe It Well: Prompts That Produce Working Code
A template for describing a tool to an AI assistant: goal, inputs, outputs, rules, examples and what done looks like — with before-and-after prompts.
Read article →Tokens Explained: Why AI Models Count Pieces of Words
Tokens Explained: Why AI Models Count Pieces of Words
AI models read and write tokens, not words. What a token is, why Hindi and code use more of them, how tokens decide price…
Read article →Set Up Your AI Coding Workspace
Set Up Your AI Coding Workspace
Choose an AI coding assistant, install Python, create a project folder with sample data and an instructions file, and learn the run-describe-fix rhythm.
Read article →Power Automate Lesson 4: Excel Table to Reminder Emails
Power Automate Lesson 4: Excel Table to Reminder Emails
Send reminder emails from an Excel table: scheduled trigger, List rows present in a table, filter by due date, send personalised emails and mark…
Read article →What Vibe Coding Is (and Is Not)
What Vibe Coding Is (and Is Not)
Vibe coding is building software by describing it to an AI assistant. What it is good for, where it fails, and the mindset that…
Read article →VBA Project: Generate PDF Invoices From Excel and Email Them Automatically
VBA Project: Generate PDF Invoices From Excel and Email Them Automatically
A complete VBA project: fill an invoice template from a data sheet, export each invoice to PDF with a proper file name, and email…
Read article →Power Automate: Send Automatic Payment Reminders From an Excel Table
Power Automate: Send Automatic Payment Reminders From an Excel Table
Build a scheduled cloud flow that reads an Excel table in OneDrive, finds invoices due in 3 days or overdue, and emails each customer…
Read article →Essbase Explained: Cubes, Dimensions and Why Finance Teams Love It
Essbase Explained: Cubes, Dimensions and Why Finance Teams Love It
What Oracle Essbase is, how cubes, dimensions and members work, the difference between BSO and ASO, and a first look at calc scripts —…
Read article →TOROW Function in Excel: Flatten Into One Row
TOROW Function in Excel: Flatten Into One Row
TOROW flattens a block into a single row, optionally skipping blanks and errors.
Read article →Look Up the Price Valid on a Date in Excel (Rate Changes, Price Lists, Tax Rates)
Look Up the Price Valid on a Date in Excel (Rate Changes, Price Lists, Tax Rates)
Pick the rate that was valid on a transaction date from a price history — XLOOKUP with match mode -1, LOOKUP, MAXIFS + INDEX…
Read article →