Smart View Lesson 1: What Essbase and Smart View Are
Understand Essbase cubes, dimensions, members and hierarchies, how Smart View connects Excel to them, and where it fits with Planning and EPM Cloud.
Read article →Ship It Safely: Secrets, Data and Maintenance
Ship It Safely: Secrets, Data and Maintenance
Share your AI-built tool responsibly: keep API keys out of code, protect personal data, write a README, version it with Git and plan for…
Read article →Check AI Code: Tests, Reviews and Red Flags
Check AI Code: Tests, Reviews and Red Flags
How non-developers can verify AI-written code: expected-output tests, a 10-point review checklist, asking a second AI to review, and red flags that mean stop.
Read article →Build a CSV Cleaner Without Writing Code Yourself
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 →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 →