Intermediate5–7 hrsEnglish + हिन्दी
Automation
- Har mahine ka manual report kaam ek script me convert kar sakte ho.
- Modules
- 7
- Lessons
- 28
- Duration
- 5–7 hrs
Your progress0 of 28 lessons · 0%
Module roadmap
Macro recorder, absolute vs relative recording, .xlsm and trust settings13 minVBA Editor tour: modules, Immediate window, breakpoints13 minCleaning recorded code — remove .Select13 minVariables, data types, Option Explicit13 minRange, Cells, Offset, .End(xlUp) — finding the last row13 minFor / For Each loops, If, With blocks13 minError handling and the Application.ScreenUpdating = False speed trick12 min
Apps Script editor, SpreadsheetApp basics15 mingetRange / getValues / setValues — and why batch operations matter15 minCustom functions — your own =MYFUNC()15 minTriggers: onOpen, onEdit, time-driven (daily 9 AM report)15 minAutomated alerts with MailApp / GmailApp15 minUrlFetchApp — pulling live data from an API15 min
openpyxl vs pandas vs xlwings — which one when15 minpandas: read_excel, filtering, groupby, merge15 minto_excel with multiple sheets and ExcelWriter15 minopenpyxl — formatting, column width, conditional formatting, charts15 minxlwings — controlling live Excel from Python15 minMini project: monthly report generator script15 min