Reduce repetitive Excel work by combining modern spreadsheet skills with Pandas and scripted report generation. 1. Who can join Suitable for: Excel users, finance teams, reporting analysts and office professionals Mandatory prerequisites: Comfort with Excel formulas and sheets; no prior Python needed 2. Duration 32 live hours • Approximately 6 weeks at 6 hours per week; actual timetable to be confirmed. 3. Mode Classroom - Thaiyur / Kelambakkam, OMR Chennai (subject to schedule) Live Online (subject to schedule)
4. Syllabus — five modules
Module 1: Modern Excel: Dynamic Arrays, Power Pivot & XLOOKUP Masterclass Learning outcome: Use lookups, dynamic arrays and Power Pivot on relevant examples. Module 2: Introduction to Python for Excel Users (Pandas DataFrames vs. Sheets) Learning outcome: Represent worksheets as Pandas DataFrames. Module 3: Replacing VLOOKUPs, Pivots & Formulas with Pandas Code Learning outcome: Replace repetitive merges and pivots with reusable Python code. Module 4: Automated Excel File Creation & Formatting with openpyxl & XlsxWriter Learning outcome: Generate styled Excel workbooks with validation and charts. Module 5: Automated Data Extraction: Web Scraping & API Requests into Excel Learning outcome: Collect data from an allowed API and schedule a sample report. 5. Practical project Source capstone title: Build a Script that Automatically Fetches API Data and Generates Excel Reports Student deliverable: A working Python script that retrieves approved sample/API data, cleans it and exports a formatted multi-sheet Excel report.
6. What is included Live trainer-led sessions Practical assignments Sample code or templates, as applicable Project feedback Learning assessment Perizona course-completion certificate subject to assessment 7. Upcoming batch
Start date: To be announced. Students can register interest; dates are shared only after confirmation.
