Training course
Automate Everyday Tasks with Python & AI
Automate repetitive office work with Python — spreadsheets, files, email prep, and scheduled tasks with AI-assisted scripting.
- Python Foundations course or equivalent (variables, loops, functions, files).
- Comfortable with Excel or CSV exports from your line-of-business system.
Ready to enrol?
Secure one-off checkout via Stripe. Attendance is tracked per session.
Enrol — £349Missed a session? Enrolled learners can book a private make-up lesson from the course portal.
- Scripts run on your own PC or server — we do not host your data.
- Access to sample data provided; you may use anonymised real exports in the capstone.
Course outcomes
By the end you will…
Measurable results we design each phase around — not vague “awareness” goals.
- Automate CSV/Excel exports and produce summary reports.
- Batch-rename, move, and organise files with audited scripts.
- Schedule scripts safely on Windows or Linux.
- Combine Python with AI to draft transformations you verify and run locally.
- Deliver a capstone workflow that saves measurable time each week.
What you are taught
Skills and topics covered
Hands-on subjects in live sessions — distinct from outcomes above (what you can do afterwards).
Automation patterns
- Reading and writing CSV and Excel (openpyxl / pandas intro)
- Path handling with pathlib
- Logging and dry-run modes
Reliability
- Idempotent scripts and rollback plans
- Task Scheduler / cron introductions
- Email-ready reports (HTML/text generation)
AI for automation
- Describing transformations in plain English
- Generating script drafts you test on copies
- Documenting scripts for handover
Course content
Phased curriculum
4 phases aligned to live sessions — select a phase to see topics and deliverables.
Align on Python basics and set up a safe automation workspace.
What you will cover
- venv, requirements.txt, and project folders
- argparse for CLI flags (--dry-run)
- Logging to file vs console
Starter automation repo layout.
Ingest exports, clean data, and output management summaries.
What you will cover
- pandas read_csv / to_excel basics
- Column normalisation and deduplication
- Pivot-style summaries for stakeholders
Weekly sales/export report script.
Organise downloads, invoices, or scans automatically.
What you will cover
- glob patterns and shutil operations
- Naming rules and conflict handling
- Archiving with date stamps
Inbox-to-archive file organiser.
Design, test, and document an end-to-end automation for your workplace.
What you will cover
- Scoping ROI and failure modes
- Scheduling and monitoring
- Handover README and runbook
Production-ready capstone script + schedule.
Questions before you enrol?
Speak with the training team about scheduling, prerequisites, or team bookings.
