RAG: Make AI Answer From Your Own Documents
Retrieval-augmented generation in plain Python: split documents into chunks, score them against a question, and send only the best chunks to the model with…
Read article →Atul Vij
Power Query Lesson 3: Removing Junk Rows, Duplicates and Errors
Power Query Lesson 3: Removing Junk Rows, Duplicates and Errors
Clean an ERP-style export: remove top rows, promote headers, fill down group labels, filter out subtotals, remove duplicates and rows with errors, and keep…
Read article →Your First Tool-Using AI Agent in Python
Your First Tool-Using AI Agent in Python
Build a working agent loop with the Claude API: define tools as JSON schemas, run the model, execute tool calls and send results back…
Read article →Power Query Lesson 2: Cleaning Text — Trim, Case and Split
Power Query Lesson 2: Cleaning Text — Trim, Case and Split
Clean messy text columns in Power Query: Trim and Clean, Capitalize Each Word, Replace Values, Split Column by delimiter, and Extract text — the…
Read article →What an AI Agent Really Is (and When You Don’t Need One)
What an AI Agent Really Is (and When You Don’t Need One)
An AI agent is a model in a loop with tools. Learn the loop, the difference between a chatbot, a workflow and an agent,…
Read article →GAMMAINV Function in Excel: Inverse Gamma (Older Name)
GAMMAINV Function in Excel: Inverse Gamma (Older Name)
GAMMAINV returns the value at a gamma probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →Power Query Lesson 1: What Power Query Is and Your First Query
Power Query Lesson 1: What Power Query Is and Your First Query
Meet Power Query in Excel: import a CSV with Get Data, the Power Query Editor, Applied Steps, setting data types (including dd-mm-yyyy dates), Close…
Read article →Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time error 1004 is Excel VBA’s catch-all error. Here are the 7 causes I see most often — with the exact fix for each.
Read article →OpenClaw Alternatives Compared: OpenHuman, ZeroClaw, PicoClaw, NanoClaw, IronClaw and More
OpenClaw Alternatives Compared: OpenHuman, ZeroClaw, PicoClaw, NanoClaw, IronClaw and More
The OpenClaw ecosystem explained: lightweight rewrites in Rust, Go, Zig and C, security-focused agents with sandboxing, OpenHuman’s Rust agent harness, and cloud options like…
Read article →GAMMADIST Function in Excel: Gamma Distribution (Older Name)
GAMMADIST Function in Excel: Gamma Distribution (Older Name)
GAMMADIST returns the gamma probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →PowerShell for Office Work: 10 Small Scripts That Save Real Time
PowerShell for Office Work: 10 Small Scripts That Save Real Time
Practical PowerShell for non-programmers: rename hundreds of files, find duplicates, combine CSVs, clean old downloads, check disk space and more — each script explained…
Read article →WRAPCOLS Function in Excel: Fold a List Into Columns
WRAPCOLS Function in Excel: Fold a List Into Columns
WRAPCOLS takes a long list and wraps it into columns of a fixed height — printable labels, seating plans.
Read article →