Skip to content
omarsoliman.dev
Tools & Tutorials

Tools & Tutorials

Reusable prompts, Excel and AI how-tos, and step-by-step recipes you can run today.

RSS feed →
Editorial clay-and-paper illustration in a warm cream, terracotta, ink and olive palette: a stack of messy handwritten paper invoices on the left connects by curved ink wires and plug connectors through a row of four rounded terracotta-clay automation nodes — an n8n-style workflow — into a tidy, neatly-ruled VAT-ready ledger on the right, where one tax row is highlighted in olive and a small gold pile of coins sits beside the AED currency mark. Messy invoices in, a structured VAT-ready ledger out.
Jul 1, 2026 · 14 min

Invoices land in your inbox, a VAT-ready ledger builds itself: a no-code n8n pipeline

New

The prompt trick reads one document. The Excel trick cleans what you already have. This one catches supplier invoices as they arrive, extracts the nine VAT fields, checks the arithmetic itself, and appends a clean row to your ledger — zero-touch after setup. Here's the exact six-node build.

AITechnologyMENAVATn8nautomationno-code
Editorial illustration in a warm clay-and-paper palette: a terracotta clay speech bubble offers a drafted figure beside a cream paper ledger, while a hand holds a magnifying glass over the figures and an ink check-mark marks a verified row — the AI drafts, the human verifies.
Jun 20, 2026 · 6 min

AI Literacy for Finance Professionals: What You Actually Need to Know in 2026

Most finance professionals were handed a chatbot and told to figure it out — no manual, no warnings, no sense of where AI is genuinely useful versus where it will quietly embarrass you. This is the orientation that should have come first.

AIFinanceExcelData
A clay-and-paper editorial illustration of a spreadsheet grid resolving from a messy, jumbled left side into clean aligned rows on the right, with a small eight-pointed-star accent.
Jun 15, 2026 · 7 min

Cleaning tax data with an AI copilot, part 1: three Excel tricks for a VAT-ready CSV

Part 1

Most tax work isn't analysis — it's dragging a messy export into shape before you can file anything. Here's how I use Excel and an AI assistant to do the boring 80%, ending with three exact moves that turn a raw invoice dump into a VAT-ready CSV.

AITechnologyEgypt
Editorial illustration in a warm clay-and-paper palette: a cream tax-return form on the left, a focused beam sweeping across it, and the content reassembled into tidy structured data cards on the right, with a small eight-pointed star accent.
Jun 14, 2026 · 13 min

One prompt reads a whole VAT return — and checks its own math

New

Keying numbers out of a VAT return by hand is a quiet time sink. Here's the prompt technique I use to pull every table, the schedule tax, and the totals in a single pass — with the form's own arithmetic checked back, and not one fabricated number.

AIEgyptTechnology

Follow Tools & Tutorials

New Tools & Tutorials posts in your inbox, plus the rest of the weekly brief. No noise.