An AI Agent That Searches Your Documents
Turn RAG into a tool: the agent decides when to search, can search more than once with better wording, and combines document answers with…
Read article →Power Query Lesson 4: Unpivot and Pivot
Power Query Lesson 4: Unpivot and Pivot
Turn a cross-tab with months across the top into a proper data table with Unpivot Other Columns, pivot data back into columns, and know…
Read article →Better Retrieval: Chunk Size, Scores and a “Don’t Know” Threshold
Better Retrieval: Chunk Size, Scores and a “Don’t Know” Threshold
Measure retrieval instead of guessing: build a small test set, compare chunk sizes, and add a score threshold so the assistant refuses when your…
Read article →RAG: Make AI Answer From Your Own Documents
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 →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 →