What Is an API? A Plain-English Guide With a Real Example
APIs explained with a restaurant analogy, then a real example: fetch exchange rates with a URL, read the JSON, and pull it into Excel…
Read article →Category Archives: Dev Tools
Git, Docker, Linux, regex, JSON and APIs explained for people who work with data.
Docker for Beginners: Run Any App Without Installing It
Docker for Beginners: Run Any App Without Installing It
What containers are, why “works on my machine” disappears, and your first Docker commands — run a database, a Jupyter notebook and your own…
Read article →JSON Explained Simply (for Excel People)
JSON Explained Simply (for Excel People)
What JSON is, how to read it, how it maps to rows and columns, and how to load JSON into Excel with Power Query…
Read article →Linux Command Line for Windows Users: 20 Commands to Survive a Server
Linux Command Line for Windows Users: 20 Commands to Survive a Server
The 20 Linux terminal commands you need when you first log in to a server — moving around, reading logs, finding files, permissions and…
Read article →Regular Expressions (Regex) for Office Users: 10 Patterns You Will Reuse
Regular Expressions (Regex) for Office Users: 10 Patterns You Will Reuse
Learn regex step by step with ten practical patterns — emails, phone numbers, PAN, dates, invoice numbers — usable in Notepad++, VBA, Python, SQL…
Read article →Git for Beginners: Save Versions of Your Work Without “final_v7”
Git for Beginners: Save Versions of Your Work Without “final_v7”
Understand Git in plain English — repository, commit, branch, merge — and learn the eight commands that cover almost everything, with a first project…
Read article →