Automation

Intermediate5–7 hrsComing soon

Har mahine ka manual report kaam ek script me convert kar sakte ho.

This track's lessons are still being written.

M1 · When to Automate What

20 min

Automation decision tree: formulas → Power Query → Office Scripts → VBA → Apps Script → PythonSoon

ROI calculation: kitna time bachega vs banane me kitna lagegaSoon

90 min

Macro recorder, absolute vs relative recording, .xlsm aur trust settingsSoon

VBA Editor tour: modules, Immediate window, breakpointsSoon

Recorded code ko clean karna — .Select hataoSoon

Variables, data types, Option ExplicitSoon

Range, Cells, Offset, .End(xlUp) — last row nikalnaSoon

For / For Each loops, If, With blocksSoon

Error handling aur Application.ScreenUpdating = False speed trickSoon

45 min

Sheet splitter — ek sheet ko column value ke hisaab se alag files meSoon

Bulk PDF export loopSoon

Outlook se automated email with attachmentSoon

90 min

Apps Script editor, SpreadsheetApp basicsSoon

getRange / getValues / setValues — aur batch operations kyun zaroori hainSoon

Custom functions — apna =MYFUNC()Soon

Triggers: onOpen, onEdit, time-driven (daily 9 AM report)Soon

MailApp / GmailApp se automated alertsSoon

UrlFetchApp — API se live data kheenchnaSoon

90 min

openpyxl vs pandas vs xlwings — kab kaunsaSoon

pandas: read_excel, filtering, groupby, mergeSoon

to_excel with multiple sheets aur ExcelWriterSoon

openpyxl se formatting, column width, conditional formatting, chartsSoon

xlwings — live Excel ko Python se control karnaSoon

Mini project: monthly report generator scriptSoon

45 min

Windows Task Scheduler / cron se script daily chalanaSoon

GitHub Actions se weekly report automationSoon

Office Scripts + Power Automate quick tourSoon

40 min

Capstone: end-to-end pipeline — CSV folder → clean → aggregate → formatted xlsx → email → scheduleSoon