Python for Excel Users: Replace Your VBA with 10x Better Code
A complete guide for Excel VBA users learning Python. Every concept mapped to its Excel equivalent — VLOOKUP becomes merge(), SUMIF becomes groupby(), Pivot…
Read article →Python
Python for analysts and office automation.
🐍
← Coding
Python
Python for analysts and office automation.
📄 28 articles⬇️ 27 with practice files🕒 Updated 11 Nov 2026
🎓 Start here: Rust Course → 🎓 Start here: Java Course → 🎓 Start here: R Course →Python Intermediate Lesson 10: Project – A Monthly Report Pipeline
Python Intermediate Lesson 10: Project – A Monthly Report Pipeline
Final project: read every monthly CSV in a folder, combine, enrich with products and customers, compute KPIs and write a multi-sheet Excel report with…
Read article →Python Intermediate Lesson 9: Command-Line Tools With argparse
Python Intermediate Lesson 9: Command-Line Tools With argparse
Turn a script into a reusable tool with options and help text using argparse, and run it from a batch file or Windows Task…
Read article →Python Intermediate Lesson 8: JSON and APIs
Python Intermediate Lesson 8: JSON and APIs
Read and write JSON, call a REST API with requests, check status codes and handle errors, and convert rupees to other currencies from an…
Read article →Python Intermediate Lesson 7: Formatted Excel Reports With openpyxl
Python Intermediate Lesson 7: Formatted Excel Reports With openpyxl
Write Excel files people like to open: several sheets, live formulas, header styles, number formats, frozen panes and a chart, all from Python with…
Read article →Python Intermediate Lesson 6: Regular Expressions for UPI, GSTIN and PAN
Python Intermediate Lesson 6: Regular Expressions for UPI, GSTIN and PAN
Use Python regex with named groups to parse UPI bank narrations and validate GSTIN, PAN and phone numbers, with patterns explained piece by piece.
Read article →Python Intermediate Lesson 5: pandas in Depth – Merge, GroupBy and Pivot Tables
Python Intermediate Lesson 5: pandas in Depth – Merge, GroupBy and Pivot Tables
Clean types with to_datetime and to_numeric, merge three tables, use named aggregations in groupby and build pivot tables, avoiding the duplicate-column trap.
Read article →Python Intermediate Lesson 4: Dates, Formats and the Indian Financial Year
Python Intermediate Lesson 4: Dates, Formats and the Indian Financial Year
Parse and format dates with strptime and strftime, compute FY labels and quarters, add working days with holidays and find month ends with datetime.
Read article →Python Intermediate Lesson 3: Errors, try/except and Logging
Python Intermediate Lesson 3: Errors, try/except and Logging
Process files with bad rows without crashing: catch specific exceptions, log what was skipped and why, and use finally for clean-up.
Read article →Python Intermediate Lesson 2: Comprehensions, Generators and Sorting
Python Intermediate Lesson 2: Comprehensions, Generators and Sorting
Write shorter, faster Python: list, dict and set comprehensions, generator expressions, enumerate, zip and sorted with a key function, on real invoice data.
Read article →Python Intermediate Lesson 1: Project Folders, pathlib and Virtual Environments
Python Intermediate Lesson 1: Project Folders, pathlib and Virtual Environments
Set up Python projects properly: one folder per project, a virtual environment, requirements.txt and pathlib paths that work wherever the script runs.
Read article →Python Lesson 12: Project — Automate a Monthly Report
Python Lesson 12: Project — Automate a Monthly Report
Build a real automation: combine every monthly CSV in a folder, clean and summarise with pandas, write a multi-sheet Excel report with KPIs, and…
Read article →