Excel, SAP, Oracle & automation tips — plus wacky facts
Automate files, Excel and email with Python.
Automate files, Excel and email with Python.
📄 7 articles⬇️ 4 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 →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 →Rename scanned invoices, photos or reports in bulk using an Excel sheet of old and new names — with a dry run, a log,…
Read article →Use Python to automate everyday office work: set up Python, handle files and folders, read and write Excel, create Word reports, send emails safely,…
Read article →Combine every Excel file in a folder into one sheet with Python and pandas — with a source column, header checks and a summary.
Read article →A complete Python script that calls a JSON API, reshapes the data with pandas, and writes a formatted Excel report with openpyxl — ready…
Read article →A 25-line Python script that moves files into Year/Month folders based on their modified date, with a dry-run mode so you can check before…
Read article →
