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 →Coding
Start-to-finish programming for people who work with data: Python, SQL, Java, R, JavaScript, Rust and PowerShell.
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 →VS Code for Office Users: 10 Features That Beat Notepad
VS Code for Office Users: 10 Features That Beat Notepad
Visual Studio Code is a free editor that is brilliant for cleaning text and data: multi-cursor editing, column selection, regex find and replace, sorting,…
Read article →Back Up a WordPress Site Automatically: The 3-2-1 Way
Back Up a WordPress Site Automatically: The 3-2-1 Way
A practical backup plan for a self-hosted WordPress site: database and files every night, a copy off the server, retention, and — most importantly…
Read article →JavaScript Lesson 5: Arrays — map, filter, reduce
JavaScript Lesson 5: Arrays — map, filter, reduce
Work with lists of data: create and index arrays, filter rows, map to new values, reduce to totals and groups, sort, and the spread…
Read article →JavaScript for Excel Users: Arrays, map, filter and reduce Explained
JavaScript for Excel Users: Arrays, map, filter and reduce Explained
Learn JavaScript’s most useful array tools — map, filter, reduce, sort — by comparing each one with an Excel formula you already know. Run…
Read article →Office Scripts: Automate Excel on the Web Without VBA
Office Scripts: Automate Excel on the Web Without VBA
Office Scripts bring automation to Excel for the web and Microsoft 365. Record a script, read the TypeScript it creates, and write a report-formatting…
Read article →Free HTTPS for Your Website: Cloudflare Origin Certificate + Nginx (Full Strict)
Free HTTPS for Your Website: Cloudflare Origin Certificate + Nginx (Full Strict)
Set up end-to-end HTTPS for free with Cloudflare in front of an Nginx server: create an Origin Certificate, install it, choose Full (strict) mode,…
Read article →Free Cloud Servers Compared: AWS vs Azure vs Google Cloud vs Oracle
Free Cloud Servers Compared: AWS vs Azure vs Google Cloud vs Oracle
What each big cloud really gives you for free — always-free vs 12-month trials, server sizes, limits and gotchas — and which to choose…
Read article →Host a Website for Free: Oracle Cloud Server + One Setup Script (Complete Guide)
Host a Website for Free: Oracle Cloud Server + One Setup Script (Complete Guide)
Step-by-step guide to an always-free Oracle Cloud server: create the VM, open ports, point your domain through Cloudflare, and run one script that installs…
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 →Python Lesson 11: Excel Files With openpyxl
Python Lesson 11: Excel Files With openpyxl
Create formatted Excel reports from Python: write DataFrames to sheets, style headers, set number formats and column widths, add formulas and a chart with…
Read article →