8-Day Intensive

Automation with Python & AI

Turn your office tasks into automated workflows in 8 days.

Beginner to Advanced8 DaysLive Batch (Weekend + Weekday)Online

A hands-on course designed to take a Finance professional with zero coding background from spreadsheets to building real automation tools — using Python, AI APIs, Google Suite, and no-code bridges. Every concept is taught through a real Finance use case, not abstract programming exercises.

What You'll Learn

Automate repetitive office tasks using Python scripts

Read, write, and process Excel and Google Sheets with Pandas

Interact with Google Drive and Gmail APIs programmatically

Generate automated reports and email them on a schedule

Use OpenAI / Gemini API to add AI capabilities to your scripts

Build and share web apps using Streamlit — no HTML required

Package scripts into standalone .EXE files for non-technical colleagues

Build and present a complete automation project on Day 8

Day-by-Day Syllabus

Day 1

Automation Basics & Mindset

→Windows Command Prompt & PowerShell basics
→Writing & running Batch (.bat) scripts
→Scheduling tasks with Windows Task Scheduler
→Automation mindset: identifying what to automate
→File operations via command line (copy, move, rename)

CMDBatch ScriptingTask Scheduler

Day 2

Python Foundations

→Google Colab setup & navigation
→Variables, data types, and operators
→Input/output and basic string formatting
→Writing and running your first Python scripts
→Installing & importing Python libraries

PythonGoogle Colabpip

Day 3

Core Python Logic

→Lists, tuples, and dictionaries
→Loops: for, while, list comprehensions
→Conditionals and logical operators
→Functions, arguments, and return values
→Error handling with try/except

LogicFunctionsData Structures

Day 4

File, Excel & Google Suite Automation

→Running .py scripts locally & scheduling with cron/Task Scheduler
→File handling: read, write, move, rename with os & shutil
→Pandas intro: read/write Excel, filter & transform data
→Google Sheets API: read & write data from Python
→Google Drive API: upload, download, organize files
→Working with JSON: parse, modify, and save data

PandasGoogle Sheets APIJSONDrive API

Day 5

Real-World Automation Use Cases

→Advanced Excel: auto-generate reports, charts & summaries
→PDF automation: merge, split, extract text (PyPDF2 / pdfplumber)
→Email automation: send bulk emails via smtplib / Gmail API
→Google Apps Script: automate Sheets, Docs & Forms
→AppScript triggers: time-based & event-based automation
→Web scraping basics: requests + BeautifulSoup
→Working with APIs: REST, authentication & JSON responses
→AI integration: using OpenAI / Gemini API in automation scripts

AppScriptGmail APIOpenAI APIPDFWeb ScrapingREST APIs

Day 6

Advanced Tools: GUI, Keyboard Simulation & App Building

→PyAutoGUI: mouse control, screen interaction & screenshots
→Keyboard simulation: hotkeys, typing, keypress automation
→Building desktop GUI apps with Tkinter
→Building web apps with Streamlit (shareable via browser link)
→Packaging scripts into standalone .EXE files with PyInstaller
→Deploying Streamlit apps to the cloud

PyAutoGUIKeyboard SimTkinterStreamlitPyInstaller.EXE Creation

Day 7-8

Capstone: Build Your Own Automation Solution

Apply everything learned to build a complete, real-world automation project. Students choose a project from their own work context and present it on Day 8.