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 →Coding
Start-to-finish programming for people who work with data: Python, SQL, Java, R, JavaScript, Rust and PowerShell.
💻
Coding
Start-to-finish programming for people who work with data: Python, SQL, Java, R, JavaScript, Rust and PowerShell.
📄 112 articles⬇️ 105 with practice files🕒 Updated 12 Nov 2026
🎓 Start here: Rust Course → 🎓 Start here: Java Course → 🎓 Start here: R Course →Migrating Excel VBA Macros to Python: A Step-by-Step Translation Guide
Migrating Excel VBA Macros to Python: A Step-by-Step Translation Guide
Step-by-step roadmap to convert slow Excel VBA macros (.xlsm) into fast, automated Python scripts using pandas, openpyxl, and xlwings.
Read article →PowerShell for Office Work: 10 Small Scripts That Save Real Time
PowerShell for Office Work: 10 Small Scripts That Save Real Time
Practical PowerShell for non-programmers: rename hundreds of files, find duplicates, combine CSVs, clean old downloads, check disk space and more — each script explained…
Read article →Linux Server Basics: 15 Commands Every Website Owner Needs
Linux Server Basics: 15 Commands Every Website Owner Needs
The Linux commands you actually need to look after a small website server: disk space, memory, logs, services, permissions, updates and safe file editing…
Read article →PowerShell Lesson 6: Robust Scripts, Error Handling and Scheduled Tasks
PowerShell Lesson 6: Robust Scripts, Error Handling and Scheduled Tasks
Turn commands into reusable scripts with param() blocks and switches, log what happened, and run them automatically with Windows Task Scheduler.
Read article →PowerShell Lesson 5: Working With CSV, JSON and Excel Files
PowerShell Lesson 5: Working With CSV, JSON and Excel Files
Import CSV files, add calculated columns, summarise with Group-Object and Measure-Object, export results to CSV, and options for real Excel files (ImportExcel module).
Read article →PowerShell Lesson 4: Variables, Arrays, Hash Tables, Loops and Conditions
PowerShell Lesson 4: Variables, Arrays, Hash Tables, Loops and Conditions
Store values in $variables, use arrays and hashtables, if/elseif/else, foreach and while loops, and the -f format operator for neat output.
Read article →PowerShell Lesson 3: The Pipeline — Filtering, Sorting, Selecting and Custom Objects
PowerShell Lesson 3: The Pipeline — Filtering, Sorting, Selecting and Custom Objects
Chain commands with the pipeline: Where-Object to filter, Sort-Object, Select-Object for columns and top N, Group-Object and Measure-Object — objects, not text.
Read article →PowerShell Lesson 2: Files and Folders — Managing, Filtering and Bulk Renaming
PowerShell Lesson 2: Files and Folders — Managing, Filtering and Bulk Renaming
Create, list, copy, move, rename and delete files with PowerShell: New-Item, Get-ChildItem with filters, Rename-Item with patterns, -WhatIf for safety and paths with Join-Path.
Read article →PowerShell Lesson 1: Basics — Cmdlets, Discovery and Execution Policies
PowerShell Lesson 1: Basics — Cmdlets, Discovery and Execution Policies
Open PowerShell, understand Verb-Noun cmdlets, find commands with Get-Command, read Get-Help, use tab completion and the execution policy for running scripts.
Read article →Rust Lesson 6: Project — A CSV Summary Tool
Rust Lesson 6: Project — A CSV Summary Tool
Build a small command-line tool that reads sales.csv, parses rows safely, totals sales by region in a BTreeMap and prints a report, with next…
Read article →Rust Lesson 5: Error Handling With Result
Rust Lesson 5: Error Handling With Result
Handle failures without exceptions: Result and Option, the ? operator, map_err, expect vs unwrap, and returning clear errors.
Read article →