Excel, SAP, Oracle & automation tips — plus wacky facts
Stop doing it by hand: VBA, Python, SAP GUI scripting, Power Automate, Office Scripts and AutoHotkey.
Stop doing it by hand: VBA, Python, SAP GUI scripting, Power Automate, Office Scripts and AutoHotkey.
📄 59 articles⬇️ 48 with practice files🕒 Updated 12 Nov 2026
🎓 Start here: SAP GUI Scripting Course → 🎓 Start here: AutoHotkey Course → 🎓 Start here: Office Scripts Course →Automating Monthly Executive PowerPoint Presentations with Python Corporate reporting cycles often force analysts to spend days copying Excel tables, formatting metric cards, and pasting…
Read article →Run-time error '1004': Application-defined or object-defined error is the most common and frustrating error encountered by VBA developers
Read article →A complete guide for Excel VBA users learning Python. Every concept mapped to its Excel equivalent — VLOOKUP becomes merge(), SUMIF becomes groupby(), Pivot…
Read article →10 practical Power Automate workflows you can build today — from saving email attachments to SharePoint, to automated approval workflows, Teams notifications, and scheduled…
Read article →A short Office Script for Excel on the web that highlights duplicate values in a chosen column, clears old highlights and runs from a…
Read article →A one-page template to write down any office process — trigger, inputs, steps, rules, exceptions, outputs and checks — so automation projects start from…
Read article →A simple way to decide which repetitive task to automate first: frequency, time, error cost and stability — with a scoring sheet and examples…
Read article →Use the Smart View VBA functions HypConnect, HypRetrieve and HypDisconnect to refresh every Essbase/EPM sheet in a workbook with one click.
Read article →Use MaxL scripts to automate Essbase: log in, clear and load data with a rules file, run a calculation and log errors — with…
Read article →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 →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 →Scripts and macros, RPA, workflow tools, browser automation, ERP scripting like SAP GUI Scripting, schedulers, data pipelines, infrastructure as code and AI agents —…
Read article →
