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 →Category Archives: Coding
Start-to-finish programming for people who work with data: Python, SQL, Java, R, JavaScript, Rust and PowerShell.
Java Streams for Beginners: filter, map and collect Explained
Java Streams for Beginners: filter, map and collect Explained
Java Streams let you process lists in a clear, declarative style. Learn filter, map, sorted, collect and groupingBy with a small sales example.
Read article →Python for Office Automation: The Complete Starter Guide
Python for Office Automation: The Complete Starter Guide
Use Python to automate everyday office work: set up Python, handle files and folders, read and write Excel, create Word reports, send emails safely,…
Read article →Merge 100 Excel Files into One with Python (in 10 Lines)
Merge 100 Excel Files into One with Python (in 10 Lines)
Combine every Excel file in a folder into one sheet with Python and pandas — with a source column, header checks and a summary.
Read article →Beautiful Charts in R with ggplot2 (for Excel Users)
Beautiful Charts in R with ggplot2 (for Excel Users)
Build bar, line and scatter charts in R with ggplot2, and learn the “grammar of graphics” idea that makes every chart the same few…
Read article →Why Learn Rust? Your First Rust Program, Explained for Beginners
Why Learn Rust? Your First Rust Program, Explained for Beginners
What makes Rust different — speed without crashes — and a gentle walk through your first program: variables, ownership, and a tiny CSV-style summary.
Read article →SQL from Zero: A Complete Beginner’s Guide (with Practice)
SQL from Zero: A Complete Beginner’s Guide (with Practice)
Learn SQL from the very beginning: tables, SELECT, WHERE, ORDER BY, aggregates, GROUP BY, JOINs, NULLs, subqueries, CTEs, window functions and changing data —…
Read article →Google Sheets QUERY Function for Excel Users
Google Sheets QUERY Function for Excel Users
Google Sheets’ QUERY function lets you filter, group and sort with SQL-like syntax in one formula. Learn it with examples mapped to Excel features…
Read article →Python Lists, Dictionaries and Loops for Excel Users
Python Lists, Dictionaries and Loops for Excel Users
The three Python building blocks you use in every script — lists, dictionaries and loops — explained with Excel comparisons and small, runnable examples.
Read article →Read and Write Excel Files in Java with Apache POI
Read and Write Excel Files in Java with Apache POI
A beginner-friendly guide to reading and writing .xlsx files in Java using Apache POI — with complete, working examples and common pitfalls.
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 →SQL for Excel Users: 10 Queries That Replace Everyday Excel Work
SQL for Excel Users: 10 Queries That Replace Everyday Excel Work
Learn SQL through tasks you already do in Excel — filters, sorting, pivot tables, VLOOKUP and remove duplicates — with 10 queries you can…
Read article →